How can I add or Delete records using DataGrid and dataAdapter??

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Transaction State Dear M$, I think after paying $$$ for your products I do deserve to have the State propery in SqlTransaction. Please do not waste time on answering how I can overcome this limitation, just give me the State propery. MH Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65849
  - 2
    - Sql Server CE How i can pull data between Sql Server and Sql Server CE Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65848
  - 3
    - Copy data from DataTable to another ? Hello, What is the best way to create a new DataTable with data from exists DataTable i have already in my application ? Thanks, Boba. Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65847
  - 4
    - MS-SQL and Oracle StoredProc In MS-SQL, when I want to use stored proc to query data out from the server and process it in ADO.NET DataAdapter / DataReader stuff. I don't have to bind the "out" parameter for getting the output. However, for Oracle DBRS, I need to create an additional "Cursor" output parameter, and I've to bind one more additional parameter. It makes my data access layer inconsistent. I've to seperate them. Does it has a easier way to solve this problem without duplication of my "query" codes ? Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65846
  - 5
    - How can i get the size of the datatable? Hi,All: How can i get the size of the datatable(including data in the datatable) in memory? Thanks David Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65843
  - 6
    - dataadapter update Using W2K, SQL2000, Framework 1.0 I don't understand why the corrected field is NOT witten back to disc. Table PERS has two coloumns: ID and data (image) // Task: exchange first byte in field 'data' with 0x49. Conn.Open(); SqlDataAdapter da = new SqlDataAdapter("Select * from PERS where ID='1'",Conn); SqlCommandBuilder myCB = new SqlCommandBuilder(da); DataSet ds = new DataSet("PERS"); byte[] myData = new byte[5000]; da.Fill(ds,"PERS"); DataRow myRow; myRow = ds.Tables["PERS"].Rows[0]; myData = (byte[]) myRow["data"]; // offset 0 has the correct value myData[0] = 0x49; myRow["data"] = myData; ds.Tables["PERS"].Rows[0]["data"] = myData; da.Update(ds,"PERS"); What have I done wrong in this sniplet? Regards, flemming Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65838
  - 7
    - Using dataset after insert, update, or delete I'm trying to refresh a datagrid after I insert, update, or delete rows from a DataSet. Once the database has been altered, do I need to re-query the database?? Or is the DataSet reflective of the current state of the database? thanks Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65837
  - 8
    - Problem writing Binary to SQL using OLE.DB. Can this be done. Gentlemen: I am trying to write Binary data to SQL using both SQLClient and OleDb. SQLClient works, but OleDb fails. When I try to update using OleDb, I get the error "Must declare the variable '@BLOB'". But I am declaring this "@BLOB" parameter, so why am I getting this error. Now the same code in SQLClient works fine, and I get no error. Is updating binary possible with OleDb, or only in SQLClient? Does the approach have to be altered for OleDb? If so how? Here is my code: ========================================================== Dim intLength As Integer = 0 'Lenght of Blob being saved. Dim cn As OleDb.OleDbConnection 'Connection Object. Dim pParameter As New OleDb.OleDbParameter 'If > 0, then UPDATE succeeded. Dim intResult As Integer 'Add Parameters. Dim cmdUpdateCommand As New OleDb.OleDbCommand 'Update Command object. Dim strUpdateCommand As String 'Update Command. .... 'Define Connection. intLength = mbytPhoto.Length 'Attempt to get length of the Blob. strUpdateCommand = "UPDATE Employees SET Photo = @BLOB WHERE EmployeeID = 10" pParameter = New OleDb.OleDbParameter 'Beginning of Parameter pParameter.ParameterName = "@BLOB" 'Input Parameter name. pParameter.Direction = ParameterDirection.Input 'Input Parameter direction. pParameter.OleDbType = OleDbType.Binary 'Type is binary. pParameter.Size = mbytPhoto.Length 'Length of Photo Blob. pParameter.Value = mbytPhoto 'Add Photo BLOB Parameter. cmdUpdateCommand.Parameters.Add (pParameter) 'Add BLOB Parameter. cmdUpdateCommand.CommandText = strUpdateCommand 'Define update command. cmdUpdateCommand.CommandType = CommandType.Text cn.Open () 'Open a connection. cmdUpdateCommand.Connection = cn 'Define connection. Try intResult = cmdUpdateCommand..ExecuteNonQuery 'Update Database with new BLOB. Catch Bad As OleDbException strUpdateCommand = Bad.Message 'Error Returned: "Must declare the variable "@BLOB" Why? End Try cn.Close () 'Close the Connection. Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65830
  - 9
    - Multiple comboboxes bound to same datasource I have multiple ComboBox controls bound to the same DataSource (a DataSet). The DataValue and DataMember properties are all bound to the same columns of the DataSet. The SelectedValue properties of the ComboBoxes are each bound to unique columns of another DataSet (a different DataSet from the DataSource property). When I change the value of any of the ComboBoxes (by selecting a different item from the drop down), the value of all up the ComboBoxes update to this newly selected value. How can I get rid of this behavior? I want each ComboBox to be populated with the same data, but be able to each have a different value selected... Thanks, Mike Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65825
  - 10
    - Stored Procedure Parameters with oldDb The oldDb Command does not support Named Parameters. If I am reading them correctly, the docs say that the order of the parameter should match the order they are declared in the Stored Procedure. When I do this the data ends up in the wrong fields. I am using C# standard with the MSDE. If I understand it correctly I can't use the SqlCommand because C# standard does not allow that. It also will not work with an SQL server, only an MSDE (and it does know the difference). The Stored Procedure is: INSERT INTO dbo.DemoShipments (PTYPE, RequestDate, Company, Dept, Name, JobTitle, Phone, Ext, Addr1, City, State, Zip, email, Source) VALUES (@PTYPE, @RequestDate, @Company, @Dept, @Name, @JobTitle, @Phone, @Ext, @Addr1, @City, @State, @Zip, @Email, @Source) private void Button1_Click(object sender, System.EventArgs e) { oleDbCmdAddDemoReq = new OleDbCommand("SpAddDemoReq", oleDbConDemoReq); oleDbCmdAddDemoReq.CommandType = CommandType.StoredProcedure; // NOTE: ORDER OF PARMS ADDS MUST MATCH ORDER OF PARMS oleDbCmdAddDemoReq.Parameters.Add("@PTYPE", ThisType); oleDbCmdAddDemoReq.Parameters.Add("@RequestDate", System.DateTime.Now); oleDbCmdAddDemoReq.Parameters.Add("@Company", txtCompany.Text); oleDbCmdAddDemoReq.Parameters.Add("@Dept", txtDept.Text); oleDbCmdAddDemoReq.Parameters.Add("@Name", txtName.Text); oleDbCmdAddDemoReq.Parameters.Add("@JobTitle", txtTitle.Text); oleDbCmdAddDemoReq.Parameters.Add("@Phone", txtPhone.Text); oleDbCmdAddDemoReq.Parameters.Add("@Ext", txtExt.Text); oleDbCmdAddDemoReq.Parameters.Add("@Addr1", txtMailAddr.Text); oleDbCmdAddDemoReq.Parameters.Add("@City", txtCity.Text); oleDbCmdAddDemoReq.Parameters.Add("@State", drpState.SelectedValue); oleDbCmdAddDemoReq.Parameters.Add("@Zip", txtZip.Text); oleDbCmdAddDemoReq.Parameters.Add("@Email", txtEmail.Text); oleDbCmdAddDemoReq.Parameters.Add("@Source", "Web Form"); oleDbCmdAddDemoReq.Connection.Open(); oleDbCmdAddDemoReq.ExecuteNonQuery(); oleDbCmdAddDemoReq.Connection.Close(); } When I do this the Zip info ends up in the Source field, the State ends up in the Zip, the City ends up in the State and the Source ends up in the City field. Yes, I can fix this by moving the fields around but if they were not all text fields I would have been getting odd error messages that I would not have understood. What am I doing wrong? Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65824
  - 11
    - IDbTransaction.Dispose() behavior Hello, I have noticed that during Dispose() uncommitted transaction is automatically rolled back . This behavior is exactly what i am expecting, but I have not found any reference in the documentation . Can I safely rely on such behavior in my code? Thanks in advance, Alexander Myachin Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65819
  - 12
    - Copy DataRow After I use DataTable.ImportRow(oOtherRow); How do I find the newly imported row in my DataTable since they neglected to return a rowid or the DataRow form the ImportRow() method. I'm assuming that is has to construct a new DataRow so it can set it's table property to be my table, so the row reference I added won't be the resulting one in the DataTable. Tony Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65818
  - 13
    - Sample Code for Forward, and Backward movement Could someone lead me to some simple code where I can select data from an access table via ado.net and display it in a grid for forward, and backward movement? Byron... Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65814
  - 14
    - displaing data from a dataset in another form Hello Putting the myDataSet in Form2 I'd like to put a DataGrid1 in Form1 that gets data from the myDataSet in Form2 If I select DataGrid1, selecting in the property window DataSource I can't see myDataSet, I know I can set that by code, but how can I do it visually? N.B. I'm using Visual c# .net Thanks, Peter Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65811
  - 15
    - Newbie Question - DataSet/DataView (DataGrid?) Hello , a newbie question : Background - I am building a simple application, and since I don't have a database server I am using XML to store the data and the DataSet.readXml() to load and save the date. Thus I can't as far as I know use SQL commands. (If anybody has an idea of a better way to do it , I would be VERY VERY thankfull!!). Question - I want to display to the user , a result query from two tables like : SELECT Employees.Name Bosses.ID FROM Employees, Bosses WHERE ... But with DataView.Select() I don't know how to get data from two tables , and in DataGrid I also don't know how to display in the same datagrid data from two tables... The tables are related child->parent. Any suggestion how can I do it? Thanks. Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65805
  - 16
    - Sub-Grid? Complicated relationships - how to proceed? Hi, I'm designing a web registration form used to link several related organizations together using asp.net. I'd really appreciate some advice on data and control structure. I have the following data structure in my SQL database: Users id,user name, password, first and last name, etc. Organization id, org name, description, logo binary/path, etc. Locations_Addresses id, street address, etc. States_Provinces id, state_province name, abbrev, state tax code, etc. What I need to do is associate Users.id with the Organizations.id within the datagrid(s?), in a way that will allow users to select which org they belong to, and also, "add" an unlisted org. In other words, I'd like to allow for a Select DropDownList with "Other/Add" as a default, with another textbox set for adding an unlisted org. In order to allow for moderation, "added/suggested/registered" organizations should remain "inactive" until reviewed and approved by an administrator, so they would not immediately be available in the dropdown list for other users without human interaction (admin). In the same way, I'd like to enable this "Select or Suggest" style interaction with my users for other fields like their Locations_Addresses, States_Provinces, etc. Taking the idea to completion, Suggested/Moderated field sets of this nature should be un-editable once suggested, so that a user would need to add a new org/location/state and suggest at the same time a cancellation of the old data (ie address change). Can someone please give me some guidance on how to accomplish this sort of functionality? I'm already weeks into this form and I can finish it with this one (although fairly complex) element. One example of the use of this form structure is to allow a multi-denominational church registration where members either pick a registered denomination, and then choose from a list of associated locations (or add one), with an associated state, or register a new denomination with all new associated data. I'd like to avoid a separate "Add Organization" form if possible. I'd be glad to post my code so far if that's allowed in this group, as it's a good (I hope) example of datagrid add new record, edit login record code. I'd love suggestions on security, optimization, syntax, etc. Thanks for any help! Drew New York Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65802
  - 17
    - [BUG] OleDb driver for .NET doesn't report ordinals for PK fields correctly When you use the GetOleDbSchemaTable() method of the OleDb connection object with the parameter OleDbSchemaGuid.Primary_Keys and you request the primary key fields for a table which has the primary key fields at ordinal positions other than the first fields (for example column 3 is the primary key field), the GetOleDbSchemaTable() method will return a set of PK fields in a datatable but the column 'ORDINAL' in that datatable doesn't contain the right ordinals: it always contains values which start with '1' and count up. The ORDINAL column is therefore not usable, it doesn't reflect the correct value. Please fix. :) TIA Frans Bouma http://www.llblgen.com -- Get LLBLGen Pro, the new O/R mapper for .NET: http://www.llblgen.com Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65800
  - 18
    - ADO or ADO'T_Binding dataset to an array? I have an array which has been filled from a text file and want to load these several hundred fields into my db, which consists of 3 tables(each of which will be receiving a portion of this data) I also want to be able to do the reverse > load my db into an array for processing into a report. I've worked with several textbook examples of ADO.net programs to manipulate data within an Access db, but I haven't found anything that covers what I am trying to do now, other than a few hints that yes, a dataset can be bound to an array. Can anyone give me a hint as to how to go about doing this? Thanks - Sean Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65799
  - 19
    - select In DataSet Hi, I have dataset which contains the data like this TranDate PurchaseVal ------------ ------------- 2003-01-01 51 2003-01-02 52 2003-01-03 54 2003-01-04 53 2003-01-05 54 2003-01-06 56 2003-01-07 58 2003-01-08 52 2003-01-09 51 2003-01-10 55 From this data I want weekly Info Week Value 1 208 2 --- 3 --- How I can get this If I am using .Select("DatePart(week,TranDate)= " & 1) it is giving me the error DatePart is not defines Need Advice LIN Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65798
  - 20
    - How can I delete only the elements in a joined table?? I have Table1: CodeArticle, name, quantity Table2: CodeArticle, date SELECT * FROM table1,table2 WHERE table1.quantity>10 AND Table1.CodeArticle=Table2.CodeArticle Now, I want to delete only the elements in Table2 Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65797
  - 21
    - Multi-threaded DataTable causes NullReferenceException Hello, I'm using a single DataTable in multi-threaded scenario. The DataTable is not connected to any database, just created and filled in from local XML file. Since multiple threads can modify this single DataTable, I use C# lock statements whenever I make changes to the DataTable, but sometimes, where repro-steps are not exactly clear, ADO.NET causes NullReferenceException. Here's stack trace: at System.Data.DataTable.get_LiveIndexes() at System.Data.DataTable.SetNewRecord(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge) at System.Data.DataRow.EndEdit() at System.Data.DataRow.set_Item(DataColumn column, Object value) I don't remember where but I remember I read notes saying ADO.NET supports multi-thread only in DataSet/DataTable, so my understanding is that as long as I serialize modify-operations (new, add, delete, change), it should work. But since the exception occurs deep inside of the ADO.NET, I'm guessing this is ADO.NET bug. Has anyone experienced errors like this? Any pointers to workarounds are greatly appreciated. Note that similar errors were seen since .NET Framework 1.0, but stack traces were different. This is from .NET Framework 1.1. Thanks, Koji Ishii Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65796
  - 22
    - Oracle-Data not changeable in Server-Explorer Hello, I have a problem: I can not change data manually in any Oracle table from server-explorer of VStudio.NET 2003. I always get a messagebox that says "..not changeable" when I try to hit a key while editing a field. The database is an Oracle 9i Win2k Server SP4. The Client has the "Oracle Client" installed on Win2k. I remember that earlier it was possible. But at some point it was no more. May be this is a special Oracle problem. But hopefully someone can help me. thanks Frank Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65795
  - 23
    - Updating to Access Hello, I am new to ADO and VB.Net. I am not new to using Access. I am in the process of creating a very large entry system for dog shows and I am having a problem. All seems to work except one very important thing and that is saving the actual data that has been input to the bound controls between my Windows VB form and the actual Access table. I know that this is a very broad and general topic, but any little information may help. I have my ole db data adapter, my datasets in place and I have code that reads oledbdataadapter1.update(dsDataset1) When this runs, no data is updated. I have read about data tables, data views, adding rows, insert, update, delete, etc, but I am missing something other than simply creating a data adapter, creating a dataset and then using the data adapters update to write changed or new records back to the Access table. Again, thanks for any information. Brad Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65793
  - 24
    - HELP:Oracle.Client Execute StoreProcedure Find Exception:ORA-06550:row 1,col7,error paramater number and type who can help me,thank you very much Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65792
  - 25
    - Adding Records Hello all, I don't believe I forgot how to do this, I want to add a new record to a new access database and I cannot remember how to do this. I have a connection object which opens and closes correctly. What do I have to do to get that pesky little record into the database? I have tried several ways and nothing seems to be working for me. If someone would be kind enough to include a small example to insert a single item into a database I would be very grateful. I haven't worked with databases since vb6, I've been using mostly XML, the problem with this is I am parsing SUS (software update service) log files in excess of 25MB that is several hundred thousand records, I really need to be able to search and manipulate it quickly. Thanks in advance, Jared Here is one of my tries that went nowhere. 'Dim dt As DataTable = Me.MyDataSet.Tables("tblClientDetails") Dim dt As DataTable = MyTable Dim MyRow As DataRow MyRow = dt.NewRow MyRow("PingID") = NewRecord.Details.PING_ID MyRow("DateServiced") = NewRecord.DateServiced MyRow("TimeServiced") = NewRecord.TimeServiced MyRow("RequestingIP") = NewRecord.RequestingIP MyRow("ServicingIP") = NewRecord.ServicingIP MyRow("VERSION") = NewRecord.Details.VERSION MyRow("CLIENT") = NewRecord.Details.CLIENT MyRow("ACTIVITY") = NewRecord.Details.ACTIVITY MyRow("ITEM") = NewRecord.Details.ITEM MyRow("DEVICE") = NewRecord.Details.DEVICE MyRow("MAJ_VERSION") = NewRecord.Details.PLATFORM.MAJ_OS_VER MyRow("MIN_VERSION") = NewRecord.Details.PLATFORM.MIN_OS_VER MyRow("BUILD_NUM") = NewRecord.Details.PLATFORM.BUILD_NUM MyRow("PLAT_ID") = NewRecord.Details.PLATFORM.PLAT_ID MyRow("SUITE_MASK") = NewRecord.Details.PLATFORM.SUITE_MASK MyRow("PROD_TYPE") = NewRecord.Details.PLATFORM.PROD_TYPE MyRow("PROCESSOR_ARCH") = NewRecord.Details.PLATFORM.PROCESSOR_ARCH MyRow("LANGUAGE") = NewRecord.Details.LANGUAGE MyRow("STATUS") = NewRecord.Details.STATUS MyRow("ERRORCode") = NewRecord.Details.ERRORCode MyRow("MESSAGE") = NewRecord.Details.MESSAGE MyRow("PROXY") = NewRecord.Details.PROXY dt.Rows.Add(MyRow) Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65790
- Next
  - 1
    - Thanks Guys. This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C37A1E.4D688990 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable CJ and others have pointed me in the right direction. After reading most = of th book i bought last night i realized i was creating my own = headaches by not seperating my data access, business logic, and = presentation layers. I have finally came to an understanding with the = new OOP practices available to VB .NET and now i am staring over and = wring completely re-useable code throughout my project. And i just = wanted to say thanks for you help and insight. Jeff Brown P.S. The book is pretty informative OOP: Building re-useable components = with Visual Basic .NET, I haven't started reading the ADO.NET book as i = realizeed my problem was not with ADO.NET but rather my architectual = structure of my program. ------=_NextPart_000_0008_01C37A1E.4D688990 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>CJ and others have pointed me in the = right=20 direction. After reading most of th book i bought last night i realized = i was=20 creating my own headaches by not seperating my data access, business = logic, and=20 presentation layers. I have finally came to an understanding with the = new OOP=20 practices available to VB .NET and now i am staring over and wring = completely=20 re-useable code throughout my project. And i just wanted to say thanks = for you=20 help and insight.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Jeff Brown</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>P.S. The book is pretty informative = <U>OOP:=20 Building re-useable components with Visual Basic .NET,  </U>I = haven't=20 started reading the ADO.NET book as i realizeed my problem was not with = ADO.NET=20 but rather my architectual structure of my = program.</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C37A1E.4D688990-- Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65789
  - 2
    - How to catch SQL event in managed code Hi, I have application which is writting data to SQL table. I have also some demon process, which is pooling new records from that table and if new record is found demon starts some task. Now I would like to change this pooling with triggering, of course if this is posible. So, my question is, is it possible in managed code to be registered for some event, which is triggerd from SQL server when for example new record is added to specific table. Thanks Edvin Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65786
  - 3
    - Dataset filtering problem Hi, I have a problem that might be easy to solve(possibly, I've just overlooked an easy solution). Here we go: I have a dataset with 2 datatables in it. Now, I need to do the following: if ds.table(0).rows(0).item("col1") = ds.table(1).rows(0).item("col2") then txtResult.text = ds.table(1).rows(0).item("col3") end if The problem is, that possible match exists in the database, but not nessasarily at Rows(0). It could be at different index. But how to actually get to the correct index?? I looked into the database, and in my case first possible match is at index Row(1) so the correct version'd be like this: if ds.table(0).rows(1).item("col1") = ds.table(1).rows(1).item("col2") then txtResult.text = ds.table(1).rows(1).item("col3") end if But of course, there is no way to know in advance, what index to use, so I'm lost a bit. Basically, I have a couple of ways of doing it. I could use Select or Find methods of datatable object to apply filtering on the datatables. But, the problem is that filtering needs to be applied on 2 different tables of the dataset, but I know how to do it for 1 datatable only. I need to merge 2 datatables into dataview and apply a filter. But how to do it? Anyway, if anyone has any ideas, so please share it with me. Thanks a lot in advance, --Alex Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65783
  - 4
    - Don't need connection.open() for adapter.Fill.. right!? I repeatedly see questions in the example exams from the Microsoft press self paced training kits that assert that a connection needs to be opened before adapter.Fill() can be called, and my understanding is that this is absolutely not the case. Has anyone else noticed this? Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65781
  - 5
    - One table two forms Hi I want to use one contacts table in two separate forms in different contexts. One form is the main entry form and the other is the lookup form. Currently I have the contacts table as part of my single dataset. Can I use the same table or do I need another instance of the table or do I use two dataadapters or what? Thanks Regards Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65777
  - 6
    - Databinding to Dataset Hi All, I have returned a dataset which as 13 rows. DsCustomers1.Clear() Dim con As New Component1 DsCustomers1 = con.FillCustomers(cboCountry.Text) MsgBox(DsCustomers1.Tables("Customers").Rows.Count) the dsCustomers1 is a dataset on Form1. I have the databindings.text property set to DsCustomers1 - Customers.CompanyName. Now when I get the dataset, it doesn't update the TextBoxes on the form. Any ideas? Thanks. Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65775
  - 7
    - error in databinding Thank u for replying but my problem is that the calculated value does appear in the text box but the database doesnt get updated. that text box is has data binding and iam updating it through data adapter.update( ) function. As soon as i click the update button previous calculated value is shown in the database not the new one ........ although it does appear in the text box thanks afsheen "Rizwan Ahmed" <rizwanahmed_81@hotmail.com> wrote in message news:OAGFMyaeDHA.3896@tk2msftngp13.phx.gbl... > You can just programatically code the TextField change Event > So, when the value will be chnaged in the text fields that are bound and > value will be changed > or you can out the calculating code in the updated code > thanx, > > > "afsheen" <afsheenj@hotmial.com> wrote in message > news:OrKAlFZeDHA.2080@TK2MSFTNGP12.phx.gbl... > > Thank you for your replyl > > > > My database is being updated with the rest of the values except for one > text > > box . The textbox's value with data binding is calculated > programmatically > > and when when i run the form the correct value appears but when i press > the > > update button, the old value appears in the same text box ..... how do i > > update the database with the programmtically calculated value in a text > box > > binded to the database > > > > thanks > > afsheen > > > > > > Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65773
  - 8
    - How to run SQL scripts? Hi, I have a *.sql file which includes a database script. How or where can I run it? Thanks, Rainer. Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65772
  - 9
    - Data Relation Problem i would like to know are there anyway to define a one/nothing-to-many relationship between 2 tables in a dataset. the scenario is like this: i have 3 tables (Customers, Orders, CustomerOrders). CustomerOrders is linked to Orders and Customers. i have define a relation for Customers(parent) and CustomerOrders(child) i have define a relation for Orders(parent) and CustomerOrders(child) the problem is an employee can also placed an other and the record is saved in the CustomerOrders table. i get an error when such records appears in the CustomerOrders table because there is a constraint that all the child records (CustomerOrders) must have a parent record (Customer) which is non existent. are there any other ways i can define a relation without disabling the constraint or add the Employee as one of the customers? are there anyway i can define any-to-many/ many-to-many relationship in a dataset? all help will be much appreciated. thanks Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65771
  - 10
    - ADO.net bindings to tect field Hey, i am bit concerned about the architecture provided in the .net frame work for ado.net. The disconnected architecture does nor serves you best on the desktop application. As you are not connected to database and if any other changes the table in the database you are not notified or your side data is still older one. As it was not in ADO we use to set the recordset properties to our need and we were quite happy. but not now. Example: Dim rs as ADODB.Recordset TextBox1.databindings.add("Text",rs,"id") (X) which is not allowed by the .net frame work, as i am using the Recordset that is in ADO not in ADO.Net and its required interface is not present. But i want to do that ... as it is quite easy to use this structure. I think there is problem with Microsoft they dont even support there ADO properties in their .net TextBox or any other control. They should provide the Implementation of connected recordset or simply implement the IList interface or any other interface that is required for the data binding in .net fram work. thanx, Rizwan Ahmed Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65765
  - 11
    - Maintaining format of multi-line textbox On submitting ASP.NET form data from a multi-line textbox, how can the user formatting (i.e. line breaks, tabs, etc.) be maintained when the data is displayed retrieved from the database? Thanks in advance. Michael Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65763
  - 12
    - error in the data binding Thank you for your replyl My database is being updated with the rest of the values except for one text box . The textbox's value with data binding is calculated programmatically and when when i run the form the correct value appears but when i press the update button, the old value appears in the same text box ..... how do i update the database with the programmtically calculated value in a text box binded to the database thanks afsheen Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65760
  - 13
    - One table binding to two forms Hi How can I bind one table from my dataset to two seperate forms? Do I need to have two dataadapters, one for each form? Thanks Regards Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65759
  - 14
    - One table binding to two forms Hi How can I bind one table from my dataset to two seperate forms? Do I need to have two dataadapters, one for each form? Thanks Regards Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65758
  - 15
    - TinyInt Conversion..... Hello All, In my ADO.Net(ASP.Net application) I am loading the data to a string variable. The data I am loading is tinyint (SQL Server column data type). I am using SqlDataReader. How to convert the data to string from tinyint. Please advice. Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65757
  - 16
    - Database type issue when inserting I've used mySQL extensively but I'm new to SQL 2k (MSDE) and .NET. When inserting data I'm having data type issue but they are a little weird. I have 2 tables, Items and Subjects. Items Type Length Allow Nulls ---------------------------------------------- ID INT 4 NO (Identity, Seed 1, Increment 1) Title INT 4 NO SubjectID INT 4 NO Description CHAR 100 NO Subjects Type Length Allow Nulls ---------------------------------------------- ID INT 4 NO (Identity, Seed 1, Increment 1) Name CHAR 50 NO Desc CHAR 100 YES I have a foreign key relationship between Items.SubjectID and Subjects.ID, with Subjects.ID as the primary and Items.SubjectID the foreign key.. I currently have 8 entries in my Subjects table. I have a form that I enter the Item information into and choose the Subject from a drop down box. When I submit the changes to the database it fails inserting to the Items table if SubjectID is higher than 3. Otherwise everything works great. I know this sounds bizarre, but it also happens in Visual Studio (Server Explorer) when I attempt to add data to the Items table.. I have no problem entering a Items.SubjectID as long as it is 3, 2, or 1. Otherwise I get the following error: --------------------------------------------------------------------------- UPDATE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Items_Subjects'. The conflict occured in datbase 'AppView', table 'Subjects', column 'ID'. The Statement has been terminated. ---------------------------------------------------------------------------- thanks for taking the time to read this.. Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65753
  - 17
    - DataTable.DisplayExpression property How is DataTable.DisplayExpression used? I need to provide a user friendly Table name in my data schema that controls such as grids etc. can use to display as a caption. I would like to store this value in a DataTable property much like the DataColumn.Caption property. MS Documentation seems to suggest that the DataTable.DisplayExpression property is to be used for this purpose but the implementation is vauge. Why is this an Expression? If I assign a string value to this property it attempts to resolve it as a column object to caculate an expression. This makes sense being that it is an "expression" type property but the documentation suggest that it is to be used to display the table name to the interface. What gives? -elton Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65750
  - 18
    - @@rowcount changed before Stored Proc. can check it We have a simple LoginUser stored proc that returns the user name and other info to the calling code. BEGIN Tran SELECT ... FROM... WHERE... IF @@error <> 0 ... IF @@rowcount <> 1 begin RAISERROR.. RETURN -1 end COMMIT TRAN RETURN 1 The interesting thing is that even though the Fill method on the .net side retrieves a record and continues without exception (see .net code below), the @@rowcount check returns 0 and gives RAISERROR (but the client doesn't catch it). The SP runs perfectly in Interactive SQL and rowcount returns 1. The theory is that the Fill method opens and closes a connection and as such resets the @@rowcount in the db prior to the SP checking it. Is that possible ? What are we doing wrong ??? Note, all our data retrieval, transaction handling, and business rule checking is done in stored procs, should we use the DataReader instead of the DataAdapter... how would any links or sample code pointers are appreciated. Thanks, Peter public LoginUserWrapper() { this.connection = (OdbcConnection) DbConnection.CreateDbConnection(); dataSet = new DataSet(); adapter = new OdbcDataAdapter(); adapter.SelectCommand = createSelectCommand(); dataTable = null; currentRow = -1; } // Create Select Command private OdbcCommand createSelectCommand() { String cmdText = "CALL LoginUser (?, ?)"; OdbcCommand cmd = new OdbcCommand (cmdText, connection); OdbcParameter p; p = cmd.Parameters.Add(new OdbcParameter("@email", OdbcType.Char, 60)); p.Direction = ParameterDirection.Input; p = cmd.Parameters.Add(new OdbcParameter("@pwd", OdbcType.Char, 20)); p.Direction = ParameterDirection.Input; return cmd; } // Create Insert Command // Create Insert1 Command // Create Update Command // Create Delete Command // Create Delete1 Command // Create Empty Table public void createEmptyTable() { dataTable = new DataTable("data"); DataColumn column; // Create and add columns column = new DataColumn(); column.DataType = System.Type.GetType ("System.String"); column.AllowDBNull = true; column.Caption = "USER_NAME"; column.ColumnName = "USER_NAME"; // column.DefaultValue = 0; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType ("System.Int32"); column.AllowDBNull = true; column.Caption = "USER_ID"; column.ColumnName = "USER_ID"; // column.DefaultValue = 0; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType ("System.Int32"); column.AllowDBNull = true; column.Caption = "MODEL_ID"; column.ColumnName = "MODEL_ID"; // column.DefaultValue = 0; dataTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType ("System.String"); column.AllowDBNull = true; column.Caption = "LANG_ID"; column.ColumnName = "LANG_ID"; // column.DefaultValue = 0; dataTable.Columns.Add(column); } // Select Command public void Select(string email, string pwd) { try { adapter.SelectCommand.Parameters["@email"].Value = email; adapter.SelectCommand.Parameters["@pwd"].Value = pwd; connection.Open(); try { adapter.SelectCommand.Prepare(); adapter.Fill (dataSet, "data"); dataTable = dataSet.Tables[0]; if (dataTable.Rows.Count > 0) { currentRow = 0; } } finally { connection.Close(); } } catch (OdbcException e1) { if (errors != null) { for (int i = 0; i < e1.Errors.Count; i++) { Utils.AddError(ref errors, Utils.GetErrorMessage(e1.Errors [i])); } } } catch (Exception e1) { if (errors != null) { Utils.AddError(ref errors, "General Error: " + e1.Message); } } } Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65748
  - 19
    - [ANN] PGSqlClient 1.0 Beta 1 released Hello: 1st Beta 1 version of PGSqlClient an ADO.NET Data Provider for PostgreSQL 7.4+ released. Beta 1 ( 12-09-2003 ) ---- - - -- -- ---- - * Better fit to ADO.NET. * Simple Transport Layer security ( TLS 1.0 ) implementation It's used yet for both TLS and non-TLS connections but it's not finished. * Improved Command Builder implementation. * Improved PgDataReader.GetSchemaTable method using prepared statements to retrieve column and primary key information. * Added SQL Server like Stored Procedure calls. * Improved compatibility with mono:: (http://www.go-mono.com) PGSqlClient 1.0 Beta 1 source code is available for download at: http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient1.0-Beta1-Src.zip?download A binary package for Windows and MS .NET Framework available at: http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient1.0-Beta1.exe?download -- Best regards Carlos Guzmán Álvarez Vigo-Spain Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65746
  - 20
    - Q: Login Oracle as SYSDBA ?? Can anyone tell me how you can log in to an ORACLE database using ado.net and the native Oracle provider by MS as a SYSDBA account? We are trying to write an app to compare the latest stats between our standby db and the prob db, to make sure they are in synch, but with the standby db, since it is effictively offline, the only way to login to it is as a sysdba. Thanks in advance, - Aaron Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65745
  - 21
    - Return ADODB.Recordset from .NET I want to have a client call new objects in .NET. I read this article http://support.microsoft.com/?id=316337 that explains how to do this by converting to XML, then transforming to a ADODB.Recordset. The only problem is that with more than 100 records this gets slow. Has anyone seen a better implementation of this (in memory transformation)? Luis *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65743
  - 22
    - Copy rows from one DataSet to another When trying to "copy" rows from one dataSet to another I get an exception that say: "This Row already belongs to another table". Any ways around this? I am trying to take a DS from a WebService and initially the RowState is unchanged. I went through the rows to fool the row state by iterating through the datarowcollection and setting dr[0] = dr[0]; however this changes the state to modified and the DataAdapter calls the Update command. I need to call the INSERT command because all those rows retrieved from the dataSet "MUST" be inserted into the SQL table. Any help would be greatly appreciated. Thanks! Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65742
  - 23
    - Updating SP Parameter values Folks, Can I update the value of a paramater used by a command AFTER adding the paramater to the command, and then update it to a new value? I want to loop through a set of values, and call a SP several times varying one of the paramaters each time. I had hoped to do something like this bit of psudocode; SqlCommand myCommand = new SqlCommand("SPname", myConnection); myCommand.CommandType = CommandType.StoredProcedure; SqlParameter parameterProductID = new SqlParameter("@ProductID", SqlDbType.Int, 4); myCommand.Parameters.Add(parameterProductID); myConnection.Open(); while (varying <n>) { parameterProductID.Value = productID(n); myCommand.ExecuteNonQuery(); } myConnection.Close() Does this look kosher? Chuck Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65741
  - 24
    - Using OleDb's GetOleDbSchemaTable to read meta data We're using the .NET OleDb classes to read meta data out of SQL Server, SQL has all of the proper SQL 92 Information Schema Views however the API in .NET doesn't return View information, it does for Tables and Stored procs? ====================================== ============== OleDbConnection cn = new OleDbConnection("my connection"); cn.Open(); DataTable schemaTable=cn.GetOleDbSchemaTable(OleDbSchemaGuid.Views, null); ==================================== I get the error: The Views OleDbSchemaGuid is not a supported schema by the 'SQLOLEDB' provider. Oracle supports it fully, SQL Server has all of the views I wonder why they didn't support this? Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65733
  - 25
    - Data Access Layer Anyone know where i can find a comprehensive tutorial on creating a data access layer? After reading alot and suggestions from others i think i need to implement one into my MDI project to make it easier to acces data from several differnt forms. Heading to books a million now to get yet another ADO .net book , the first one i bought just scratched this surface. Thanks, Jeff Tag: How can I add or Delete records using DataGrid and dataAdapter?? Tag: 65728

Hi,

I want to use datagrid to add/modify/delete record using datagrid.
I load some table in dataset then set datagrid.datasourse = dataset.

I tried to add record from datagrid, but it didnt work. It shows errors
that has not new added records. If I add new row into table, It shows
duplicate error.
my some code here..
dataadapter.fill(dataset, tb1)
dataGrid.dataSource = dataset.table("tb1")

then i click add button.
dataset.table("tb1").getchanges(rowstate.added)
dataAdapter.InsertCommand=("Insert into tb1 (@id,@name,@age)")
*******
I've set dataAdapter parameters and value here
*******
dataAdapter.update(dataset, "tb1")
dataset.table("tb1").acceptChange()

Thanks,
Kwok

Top