A DbDataAdapter issue

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
    - problem with typed dataset This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C4CBC7.D8C472A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I have a small problem with typed dataset.=20 I have created a DataSet (MyDataSet.xsd) and draged some SQL tables into = it. All tables have a column called "ID" that is identity(1,1) type = column. When I get propeties for "ID", for some table, value for = "Autoincrement" property is "true" and some are "default".=20 Can anyone explain me why the "Autoincrement" shows as "default" instead = of "true"? Thanks in advance. Dinesh Priyankara ------=_NextPart_000_0008_01C4CBC7.D8C472A0 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.3790.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DVerdana size=3D2>Hi All,</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>I have a small problem with typed = dataset.=20 </FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>I have created a DataSet = (MyDataSet.xsd) and=20 draged some SQL tables into it. All tables have a column called "ID" = that is=20 identity(1,1) type column. When I get propeties for "ID", for some = table, value=20 for "Autoincrement" property is "true" and some are "default". = </FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Can anyone explain me why the = "Autoincrement"=20 shows as "default" instead of "true"?</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Thanks in advance.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Dinesh = Priyankara</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C4CBC7.D8C472A0-- Tag: A DbDataAdapter issue Tag: 99200
  - 2
    - How to handle deleted rows This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C4CB58.39DB7220 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am using databinding with a few textboxes. I also have a grid on a = separate screen where I show the entered data plus more details. I can go into the grid the delete records. When I later reopen the grid, if I have deleted all of the rows, I will = add a single new row to the grid. Part of this process for adding the = new row is that I get the ID, which is a guid, of the row that I have = added and set that to a property within my class. In order to set the currency manager, I need to get the ProposedCostID = of the new row and loop through each row until I get the index of the = row. (NOTE: you cannot use a Find on a column that is a GUID, I found = that out the hard way). Once I have the index, I can set the currency = manager. I then use this property to set the currency manager so that the data on = the screen will be bound to the correct record. The real problem below = is that the index retrieved is not really the index, it just happens to = be that way because of the way I set the counter. This looping works = correctly if I do not have deleted records in the table. -------------------------------------------------------------------------= -------------------------------------------------------------------------= --------------------- 'Here is my code for getting the currency manager and the property Dim liRowIndex As Integer Dim lCurrMgr As CurrencyManager Dim myRow As DataRow liRowIndex =3D 0 For Each myRow In ds.Tables(strTable).Rows If myRow.RowState <> DataRowState.Deleted Then 'the new row was added prior to calling this function. The new guid = was stored in the class property 'ProposedCostID. Loop through the rows to get the index of the row = that has a matching guid Dim strG As Guid strG =3D myRow.Item("ProposedCostID") If (strG.ToString =3D Me.ProposedCostsID.ToString) Then Exit For End If liRowIndex =3D liRowIndex + 1 End If Next lCurrMgr =3D CType(Me.BindingContext(ds.Tables(strTable)), = CurrencyManager) ' Set the initial Position of the control. lCurrMgr.Position =3D liRowIndex ------------------------------------------------ I'm not sure, maybe my only choice around this mess is to truly save the = data to the database each time a row is deleted, then everything should = be set correctly. Any help appreciated. Norton ------=_NextPart_000_0008_01C4CB58.39DB7220 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.2900.2523" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>I am using databinding with a few = textboxes. I also=20 have a grid on a separate screen where I show the entered data plus more = details.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I can go into the grid the delete=20 records.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>When I later reopen the grid, if I have = deleted all=20 of the rows, I will add a single new row to the grid. Part of this = process for=20 adding the new row is that I get the ID, which is a guid, of the row = that I have=20 added and set that to a property within my class.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>In order to set the currency manager, I = need to get=20 the ProposedCostID of the new row and loop through each row until I get = the=20 index of the row. (NOTE: you cannot use a Find on a column that is a = GUID, I=20 found that out the hard way). Once I have the index, I can set the = currency=20 manager.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I then use this property to set the = currency=20 manager so that the data on the screen will be bound to the correct = record. The=20 real problem below is that the index retrieved is not really the index, = it just=20 happens to be that way because of the way I set the counter. This = looping=20 works correctly if I do not have deleted records in the = table.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial=20 size=3D2>----------------------------------------------------------------= -------------------------------------------------------------------------= ------------------------------</FONT></DIV> <DIV><FONT face=3DArial size=3D2>'Here is my code for getting the = currency manager=20 and the property</FONT></DIV> <DIV> <P><FONT face=3DArial size=3D2>Dim liRowIndex As Integer<BR></FONT><FONT = face=3DArial=20 size=3D2>Dim lCurrMgr As CurrencyManager<BR></FONT><FONT face=3DArial = size=3D2>Dim=20 myRow As DataRow</FONT></P> <P><FONT face=3DArial size=3D2>liRowIndex =3D 0</FONT></P> <P><FONT face=3DArial size=3D2>For Each myRow In=20 ds.Tables(strTable).Rows<BR></FONT><FONT face=3DArial = size=3D2>   =20 </FONT><FONT face=3DArial size=3D2>If myRow.RowState <> = DataRowState.Deleted=20 Then</FONT></P> <P><FONT face=3DArial size=3D2>    'the new row was = added prior=20 to calling this function. The new guid was stored in the class=20 property<BR>    'ProposedCostID.  Loop through the = rows to=20 get the index of the row that has a matching guid</FONT><FONT = face=3DArial=20 size=3D2><FONT face=3DArial = size=3D2><BR></FONT>    </FONT><FONT=20 face=3DArial size=3D2>Dim strG As Guid<BR></FONT><FONT face=3DArial=20 size=3D2>    strG =3D = myRow.Item("ProposedCostID")<BR></FONT><FONT=20 face=3DArial size=3D2>    If (strG.ToString =3D=20 Me.ProposedCostsID.ToString) Then<BR></FONT><FONT face=3DArial=20 size=3D2>        Exit = For<BR></FONT><FONT=20 face=3DArial size=3D2>    End If</FONT></P> <P><FONT face=3DArial size=3D2>    liRowIndex =3D = liRowIndex +=20 1</FONT></P> <P><FONT face=3DArial size=3D2>End If</FONT></P> <P><FONT face=3DArial size=3D2>Next</FONT></P> <P><FONT face=3DArial size=3D2></FONT> </P> <P><FONT face=3DArial size=3D2>lCurrMgr =3D=20 CType(Me.BindingContext(ds.Tables(strTable)), = CurrencyManager)</FONT></P> <P><FONT face=3DArial size=3D2>' Set the initial Position of the=20 control.<BR></FONT><FONT face=3DArial size=3D2>lCurrMgr.Position =3D=20 liRowIndex<BR></FONT><FONT face=3DArial size=3D2><BR></FONT></P> <P><FONT face=3DArial=20 size=3D2>------------------------------------------------</FONT></P> <P><FONT face=3DArial size=3D2>I'm not sure, maybe my only choice around = this mess=20 is to truly save the data to the database each time a row is deleted, = then=20 everything should be set correctly.</FONT></P> <P><FONT face=3DArial size=3D2>Any help appreciated.</FONT></P> <P><FONT face=3DArial size=3D2></FONT> </P> <P><FONT face=3DArial size=3D2>Norton</FONT></P></DIV></BODY></HTML> ------=_NextPart_000_0008_01C4CB58.39DB7220-- Tag: A DbDataAdapter issue Tag: 99197
  - 3
    - fill datagrid from other table. I have 1 dataset called "dataset1" that contains 2 tables called "course" and "courseload". in my form i have a datagrid. the datasource of this datagrid is "dataset1" and the datamember is "courseload". here's the fields of every table in my dataset. "Course" table CourseID CourseCode CourseDescription Program Year "Courseload" table CourseLoadID CourseID Grades CourseID in course table is a primary key and CourseID in CourseLoad table is a foreign key. now my question is on how can i fill this datagrid w/ records from course table based on the criteria like Program and Year. example: Course table CourseID CourseCode Program Year 1 IT 1 BSIT 1 2 IT 2 BSIM 1 3 MATH 1 BSIT 2 so for example in my form i want to fill the datagrid w/ records from course table that has Program = BSIT and Year = 1 so the datagrid now will have CourseID Grades CourseLoadID 1 2 Note: I have already done this using MS Access but I ported my apps to VB.NET i use the Docmd.RunSQL command then the insert statement like this one: DoCmd.RunSQL "INSERT INTO CourseLoad ( CourseID) " _ & "SELECT Course.CourseID " _ & "FROM Course " _ & "WHERE Course.Program = " & Forms![Students]![Program] & " AND Course.Year= " & Me!Year; this is pretty simple w/ MS Access. thanks in advance for any help. Tag: A DbDataAdapter issue Tag: 99194
  - 4
    - DataColumn.Expression Property - operator "Between" Is "Between" a valid operator in the DataColumn.Expression? I tried to use and it throw an error. Ray Tag: A DbDataAdapter issue Tag: 99193
  - 5
    - Sorry to be a pain but THIS IS A REAL BUG... so could anyone please advise me who I should send this to in order to have it sorted out? "Dallara" <someone@microsoft.com> wrote in message news:#hyo6T6xEHA.3376@TK2MSFTNGP12.phx.gbl... Ok, Ryan. Thanks for your attention. Do you get 0 rows in which one of the result sets? Because it shows 2 result sets. One with the expected result and another one, where the extra brackets were added with the "wrong" result. Just like bellow: -------------------------------------------------------------------------------------------------------------------------------------- C:\Temp>AdoTableSelectTest LESS BRACKETS FILTER RESULTS ( Description = 'Type B' and Number = 7 ) and ( Code = 'B' ) Row Count: 0 Code - Number - Description --------------------------- EXTRA BRACKETS FILTER RESULTS ( ((Description = 'Type B')) and ((Number = 7)) ) and ( Code = 'B' ) Row Count: 2 Code - Number - Description --------------------------- B - 2 - Type B B - 3 - Type B C:\Temp> -------------------------------------------------------------------------------------------------------------------------------------- Note that the values in the Number column in the 2nd result set are 2 & 3 respectively. But the filter clause says "Number = 7"(???). If both result sets are returning 0 rows, then I don't know what it is. It might be that you have a different MDAC or .NET Framework version where this problem has already been fixed. Many thanks, Dalmo "W.G. Ryan eMVP" <WilliamRyan@NoSpam.gmail.com> wrote in message news:eJcEwwfxEHA.1452@TK2MSFTNGP11.phx.gbl... > Dallara: > > I'm not sure I follow you - I copied the code below and ran it - and I'm > getting 0 rows selected. When I change the code block to this : > DataRow Row1 = Table.NewRow(); > > Row1["Code"] = "A"; > > Row1["Description"] = "Type A"; > > Row1["Number"] = 1; > > Table.Rows.Add(Row1); > > I get exactly what I'd expect. > > > -- > W.G. Ryan MVP (Windows Embedded) > > TiBA Solutions > www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com > > > "Dallara" <someone@microsoft.com> wrote in message > news:#7rGTIexEHA.2016@TK2MSFTNGP15.phx.gbl... >> Hi >> >> Just found a bug in the System.Data.DataTable.Select() method in ADO.NET. >> To reproduce the bug, just create a C# Console application with the code >> bellow on the start up class and execute it. >> >> What happens is that in some specific situations when you add some extra >> brackets to the filter string, rows that don't match the filter criteria > are >> selected. If you remove the brackets the select works fine. And it's not >> a >> matter of precedence as all conditions are joined by AND. >> >> In the spike bellow, one of the filter conditions is "Number = 7". This >> condition doesn't match any rows in the test table. Even thought, in the >> select where extra brackets are added to the filter, 2 rows that match >> the >> other conditions are improperly selected. These rows have Numbers 2 and 3 >> respectively (not 7). >> >> >> Thanks, >> Dallara // -------------------------------------- // -- SPIKE TO CATCH THE BUG -- // -------------------------------------- using System; using System.Data; namespace AdoTableSelectSpike { class Class1 { [STAThread] static void Main(string[] args) { TestAdoTableSelect(); } protected static void TestAdoTableSelect() { DataTable Table = GetTestTable(); string Condition0 = "Description = 'Type B'"; string Condition1 = "Number = 7"; string Condition2 = "Code = 'B'"; string LessBracketsFilter = String.Format("( {0} and {1} ) and ( {2} )", Condition0, Condition1, Condition2); DataRow[] LessBracketsRows = Table.Select(LessBracketsFilter); WriteResults(LessBracketsRows, LessBracketsFilter, "LESS BRACKETS FILTER RESULTS"); string ExtraBracketsFilter = String.Format("( (({0})) and (({1})) ) and ( {2} )", Condition0, Condition1, Condition2); DataRow[] ExtraBracketsRows = Table.Select(ExtraBracketsFilter); WriteResults(ExtraBracketsRows, ExtraBracketsFilter, "EXTRA BRACKETS FILTER RESULTS"); } protected static DataTable GetTestTable() { DataTable Table = new DataTable("TestTable"); Table.Columns.Add("Code", typeof(System.String)); Table.Columns.Add("Description", typeof(System.String)); Table.Columns.Add("Number", typeof(System.Int32)); DataRow Row1 = Table.NewRow(); Row1["Code"] = "A"; Row1["Description"] = "Type A"; Row1["Number"] = 1; Table.Rows.Add(Row1); DataRow Row2 = Table.NewRow(); Row2["Code"] = "B"; Row2["Description"] = "Type B"; Row2["Number"] = 2; Table.Rows.Add(Row2); DataRow Row3 = Table.NewRow(); Row3["Code"] = "B"; Row3["Description"] = "Type B"; Row3["Number"] = 3; Table.Rows.Add(Row3); return Table; } protected static void WriteResults(DataRow[] Rows, string FilterString, string ResultsCaption) { Console.WriteLine(""); Console.WriteLine(""); Console.WriteLine(ResultsCaption); Console.WriteLine(""); Console.WriteLine(FilterString); Console.WriteLine("Row Count: " + Rows.Length.ToString()); Console.WriteLine("Code - Number - Description"); Console.WriteLine("---------------------------"); foreach (DataRow Row in Rows) { string Line = String.Format( "{0} - {1} - {2}", Row["Code"].ToString(), Row["Number"].ToString(), Row["Description"].ToString()); Console.WriteLine(Line); } Console.WriteLine(""); } } } // -------------------------------------- Tag: A DbDataAdapter issue Tag: 99192
  - 6
    - 508 Compliancy Tools for ASP.NET Does any one know of any 508 Compliancy Tools for ASP.NET to help automate the process before deployment. Tag: A DbDataAdapter issue Tag: 99190
  - 7
    - little problem replacing commandbuilder IÂ´m filling a typed Dataset in order to update a SqlServer DB I created the DataAdapter and I used the CommandBuilder to generate the INSERT Statement, Good!! Now I don't want to use the CommandBuilder anymore (performance) but when I setup the dataAdapter.InsertCommand property (with both the Insert query generated by the wizard either generated by Commandbuilder) INSERT INTO Ventas( ID , NroTicket , FechaHora , IDLoteria , NumeroJugado , MontoJugado ) VALUES ( @p1 , @p2 , @p3 , @p4 , @p5 , @p6 ) I receive an error like this : The variable @p1 has not been defined. What am I doing wrong? Ken Tag: A DbDataAdapter issue Tag: 99186
  - 8
    - AutoIncrement not incrementing I have a dataset with about 12 tables in it. I'm using this to support a little demo app I'm building for proof of concept for a potential client and there's no backend database involved. When I add record to a to the dataset table all goes well except the autoincrement field stays at zero. this is also the PK field for the table. I set the AutoIncrement property to True, AutoIncrementSeed to 1 and AutoIncrementStep to one but its still not added a value. I even removed all the data from the table and tried again to no avail. also just after I add the datarow to the table I all the AcceptChanges() method but that didn't seem to have any effect. Can anyone help me trouble shoot this? Thanks. -- moondaddy@nospam.com Tag: A DbDataAdapter issue Tag: 99180
  - 9
    - DataRowView I have a dataTable(s) that I wish to locate a specific row in, then update a column value within that row. I have created a dataView and applied a rowFilter to the dataView, but am unclear on how I access specific rows, and dataColumns within the row. I believe that a dataRowView is the answer, but have had no success implementing it. Tag: A DbDataAdapter issue Tag: 99179
  - 10
    - Newbie Question I need help: I want to add a new row to an Access Table "Table1" with its default values, but it doesn't work at all. Here is the code: Dim Adapter As OleDb.OleDbDataAdapter Dim Dataset As New Data.DataSet Dim DataTable As New Data.DataTable Dim DataRow As System.Data.DataRow Adapter = New OleDb.OleDbDataAdapter("SELECT * FROM Table1", Connection) Adapter.Fill(Dataset, "Table1") DataTable = Dataset.Tables( "Table1") DataRow = DataTable.NewRow DataTable.Rows.Add(DataRow) Adapter.Update(Dataset, "Table1") Tag: A DbDataAdapter issue Tag: 99176
  - 11
    - question about DataRow Is it a possibel to assign an array to a DataColumn then bind it to a Combo box?? Is the follwoing code right? public static DataSet InsertParamsToDS(ReportParameter[] arrParams) { DataSet RepDS=new DataSet(); DataTable objDataTable=new DataTable("ReportParams"); RepDS.Tables.Add(objDataTable); objDataTable.Columns.Add("Name",typeof(string)); objDataTable.Columns.Add("ValidValues",typeof(ValidValue[])); foreach(ReportParameter repParam in arrParams) { DataRow objDR=objDataTable.NewRow(); objDR ["Name"]=repParam.Name; /**** I want in my Datagrid instead textbox for ValidValues a combobox holds the values of "repParam.ValidValues"*////// objDR ["ValidValues"]=repParam.ValidValues; objDataTable.Rows.Add(objDR); } return RepDS; } Tag: A DbDataAdapter issue Tag: 99173
  - 12
    - nullable columns Hello, how do you get the table definition of any Relational Database by using the OLEDB client. (it is either SQL Server or Oracle, but I would expect this to work with any Relational Database supporting SQL92 standards and using the OLEDB client.) ? I need to figure out if a field is a required field (not null) or not. Thanks a bunch... Haz Tag: A DbDataAdapter issue Tag: 99172
  - 13
    - Typed Dataset parent child relation problem. Hi, I created a XSD shemas defenition for two tables that has parent child relation. I create the shemas by using XMLSpy. The relation is well deffine in xsd file. I generated a Types Dataset form that xsd file by using XSD utilty of .Net framework. The data relation seems to be well define, a DataRalation is add to the typed dataset source code.. But if I create an XMLDataDocument from that dataset the parent child relation is not respected in the generated XML. ex:. It must Get this. <table1> <field1></field1> <field2></field2> <field3></field3> <table2> <field1></field1> <field2></field2> </table2> </table1> But a get That <table1> <field1></field1> <field2></field2> <field3></field3> </table1> <table2> <field1></field1> <field2></field2> </table2> What can be the problem with the typed dataset that make the datarelation not respected? Regards Alain Martineau Publishing Business System Tag: A DbDataAdapter issue Tag: 99171
  - 14
    - Generic OLEDBConnection Hi all, i need to make a connection to a database, but i can't know in advance what kind of database it will be. That can be an oracle database, access database, sql server database, and so on ... My user will create an ODBC DSN and will set it's name in my application. Then i will have only this information : the DSN NAME i thought that odbc can implement a generic way of connection. So i've create an OleDbConnection object : Private theOleDbConnection As OleDbConnection ... theOleDbConnection = New OleDbConnection theOleDbConnection.ConnectionString = ?? what kind of connection string should i use (i've tried some without any result) ? is there's an other way to have a generic connection ?? thanks a lot in advance for your help. Nicolas H. Tag: A DbDataAdapter issue Tag: 99164
  - 15
    - Issue with Managed Oracle Provider in .NET Can any one clarify this issue with Managed Oracle Provider in .NET ? I am trying to run a very simple SQL query using the ExecuteScalar() method of the command object. I get an error stating: ORA-00911: invalid character --------------------Code------------------------ public Object fetchScalar( IDbConnection con, String strSql) { IDbCommand cmd = null; try { //Prepare the Command cmd = con.CreateCommand(); cmd.Connection = con; cmd.CommandText = strSql; cmd.CommandType = System.Data.CommandType.Text; try { cmd.CommandTimeout = 30; Object result = cmd.ExecuteScalar(); return result; } finally { if (null != cmd) cmd.Connection = null; cmd = null; } } catch( Exception e ) { throw new Exception( ERR_CantFetchData, e ); } } -------------------End Code--------------------- --------------------SQL------------------------- select B2.BUS_NAME_ID BusNameId from business_name B1, business_name B2 where B1.BUS_NAME_ID = 2201110001 and B1.BUS_NAME_TYPE_CD = 1004 and B1.ENTITY_ID = B2.ENTITY_ID and B2.BUS_NAME_TYPE_CD = 1001; -------------------End SQL---------------------- ------------------Error Message----------------- Error: ORA-00911: invalid character Module: System.Data.OracleClient at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean isReader, Boolean needRowid, OciHandle& rowidDescriptor, ArrayList& refCursorParameterOrdinals) at System.Data.OracleClient.OracleCommand.Execute(OciHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciHandle& rowidDescriptor) at System.Data.OracleClient.OracleCommand.ExecuteScalarInternal(Boolean needCLStype, Boolean needRowid, OciHandle& rowidDescriptor) at System.Data.OracleClient.OracleCommand.ExecuteScalar() -----------------End Error---------------------- Tag: A DbDataAdapter issue Tag: 99160
  - 16
    - Create a Share I have an existing folder. I want to share it so that other user can access this folder. How can I create it from VB.NET Thanks, Richard Tag: A DbDataAdapter issue Tag: 99155
  - 17
    - deleting related records Hi I have strongly typed data set. I want to delete record in one table. It has related tables (it is parent table). How to load all related records from child tables and delete them (and also discover and delete they children records) to have possibility to delete parent record. Thanks Konrad Tag: A DbDataAdapter issue Tag: 99143
  - 18
    - Problem with Access-MemoField that contains Data > 255 characters Hi there! When the Memo field of a Access Database is over 255 characters, OleDbDataAdapter doesn't fill well my DataTable (only the first 255 characters). I tried with OleDbDataReader, GetChars and filling a StringBuilder, and it seems it only has 255 characters; it doesn't reach the rest. Please help! oliver Tag: A DbDataAdapter issue Tag: 99142
  - 19
    - Help-General network error. Check your network documentation. Hi, This is regarding a connection pooling error which I am getting regularly on my shopping cart application. I am getting a message like 'General network error. Check your network documentation. ' on opening the shopping cart ,when it is opened multiple times(7 or 8 times). I had used datareader to retrieve data in the page. Later on I changed it to Dataset and explicitly closed all the connections after retrieving data to the dataset. but it still showing the same message . I am using Microsoft data access block to connect to the database. Please Help. Regards Franco Vincent Tag: A DbDataAdapter issue Tag: 99139
  - 20
    - Error using Container.DataItem("<field>") in Repeater ItemTemplate Hi. I have a straight-forward "OleDbDataReader" object that's been returned from a SELECT statement against an MS Access file. I've tested the DataReader and it has data and is set up right. Now I'm trying to use the ASP.NET Repeater WebControl to display the data. I read the documentation and it says that in the <ItemTemplate> section of the Repeater, I can use the following notation: <ItemTemplate> <%# Container.DataItem("LastName") %> </ItemTemplate> BUT when I do this, I get the following error: "CS0118: 'System.Web.UI.WebControls.RepeaterItem.DataItem' denotes a 'property' where a 'method' was expected" What does this mean? If I replace this notation with: <%# DataBinder.Eval(Container.DataItem, "ID") %> it works, but I've read that that's FAR less efficient. What am I doing wrong? Thanks. Alex Tag: A DbDataAdapter issue Tag: 99129
  - 21
    - How do I force a value into a datatable column? I have a datatable that has been created from a new row in a datagrid. There is a field that is defined in the datatable that is NOT displayed in the datagrid (key field), although the column IS defined in the datatable. I want to force a value into the column before I update the dataAdapter. How do I do this? TIA, Larry Woods Tag: A DbDataAdapter issue Tag: 99126
  - 22
    - interop.ADOX and VB.Net distributions I have a VB.Net application that primarily uses ado.net to manipulate an Access/JET database. It uses adox to create a new empty database if one doesn't already exist. This works fine on the development machine but on trying a test deployment (to a Win2K PC) the step to create the new database fails as an unhandled exception with the error 'Interop.ADOX or one of its dependencies was not found' Now AFAICS interop.adox.dll was included as part of the .msi installation package and can be found in the application folder. MSadox.dll wasn't for some reason packaged (actually I think it was a permissions problem) but I moved it manually to the program folder. Obviously something is not right in this scheme of things. Can anyone suggest where to look first. TIA JGD Tag: A DbDataAdapter issue Tag: 99125
  - 23
    - Is there an Ole DB (or ODBC) provider for Microsoft Works db Is there an Ole DB (or ODBC) provider for Microsoft Works database? *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: A DbDataAdapter issue Tag: 99121
  - 24
    - SQL Select satement question Hi All, This may be a bit of a newbie question with an obvious answer, but I've dug around everywhere and can't find out how to do it. I'm creating a .net web app and have a series of drop-down lists that are all tied to sql tables. The select statement in each of the drop-downs is based on the selection in the previous drop-down (think the same sort of functionality that you see at large automotive sites where you pick the year, and then the make and finally the model). I know that I have to concatenate all of the select statements after the first one, but I don't know how to grab the selected value. The page itself is asp.NET but the code behind everything is vb.NET Thanks in advance, -Mike Tag: A DbDataAdapter issue Tag: 99119
  - 25
    - Select statement based on previous field Hi All, This may be a bit of a newbie question with an obvious answer, but I've dug around everywhere and can't find out how to do it. I'm creating a .net web app and have a series of drop-down lists that are all tied to sql tables. The select statement in each of the drop-downs is based on the selection in the previous drop-down (think the same sort of functionality that you see at large automotive sites where you pick the year, and then the make and finally the model). I know that I have to concatenate all of the select statements after the first one, but I don't know how to grab the selected value. The page itself is asp.NET but the code behind everything is vb.NET Thanks in advance, -Mike Tag: A DbDataAdapter issue Tag: 99118
- Next
  - 1
    - remoting/web services passing typed datasets We are testing speed/functionality of remoting and web services while planning a distributed windows forms application. With web services, it is very easy to pass a dataset, but is it possible to pass a typed dataset? If not, is there a way to convert the dataset into the typed dataset? Masa Tag: A DbDataAdapter issue Tag: 99117
  - 2
    - Windows SP2 conflicts with SQL Server Has anybody had problems arise with connecting to SQL Server from a web app after installing SP2? I am getting an access denied error on a web app after installing SP2. I have verified that the ASPNET user is permitted in SQL server. I can connect through Enterprise Mgr., and the database was not affected during the upgrade, however, I am not able to access the DB through Query Analyzer either. Any ideas? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: A DbDataAdapter issue Tag: 99111
  - 3
    - Get Table and Field Names How do I get the names of the tables in a database via ado.net? Once I have the table names, how do I get the names of the Fields for each table? I used to use OpenSchema in vb6 but do not find a correlating command for .net. Thanks. Tag: A DbDataAdapter issue Tag: 99107
  - 4
    - Unspecified Error on MyConnection.Open() to MS Access File Hi. I'm trying to connect to an MS Access .MDB file from ASP.NET (in C#). I've Imported System.Data and System.Data.OleDb. My code looks like: OleDbConnection myConnection = new OleDbConnection(); myConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\xyz.mdb"; myConnection.Open(); when I try to do the last line ("myConnection.Open()"), I get an Unspecified Error. I have no idea how to debug this! * Is it because it can't reach the .MDB or that there are permissions problems on it? * Is it because maybe I don't have that exact "Provider" installed (how do I check that)? One more related question: in an ASP.NET .ASPX page, when I provide the path in the connection string, if I want it to be a relative path, how do I determine what OleDb considers to be the current path in which it would look for the file if I provided no path information? Your help is much appreciated. Alex Tag: A DbDataAdapter issue Tag: 99104
  - 5
    - Updating a DataGrid that is disconnected from a data source Hi, I am trying to use a data grid in a web application in which I have three tiers. The DataGrid is not set up to a data source, or a data adapter, so everytime I make a change I send the cell information to another object which forms an SQL query and makes the query to the DB (actually to a DBFacade object). In any case, please see the code I have listed below for my update DataGrid event. With this code, the DB is updated using the old data in the datagrid prior to the users changes, why is this and how can I take the new data out of the grid after the user makes changes? Thanks very much! private void coursesDataGrid_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { // get primary key courseID TableCell courseIDCell = e.Item.Cells[1]; string courseID = ((TextBox)courseIDCell.Controls[0]).Text; // get section TableCell sectionCell = e.Item.Cells[2]; string section = ((TextBox)sectionCell.Controls[0]).Text; // get semester TableCell semesterCell = e.Item.Cells[3]; string semester = ((TextBox)semesterCell.Controls[0]).Text; // get title TableCell titleCell = e.Item.Cells[4]; string title = ((TextBox)titleCell.Controls[0]).Text; // get school name TableCell schoolNameCell = e.Item.Cells[5]; string schoolName = ((TextBox)schoolNameCell.Controls[0]).Text; // update database here coursesDataGrid.DataSource = courseManager.UpdateCourse(user, schoolName, semester, courseID, title, section); coursesDataGrid.EditItemIndex = -1; coursesDataGrid.DataBind(); } Jon Agiato Tag: A DbDataAdapter issue Tag: 99103
  - 6
    - Connection string does not work from asp.net web application If I run the following code on my development machine as a "Windows Application", it works. If I run the following code on my development machine as an "ASP.NET Web Application", I get the error "SQL Server does not exist or access denied." when trying to open the connection. I would appreciate any assistance in determining why. Private Sub TestAdo() Dim conn As New System.Data.SqlClient.SqlConnection Dim cmd As New System.Data.SqlClient.SqlCommand Dim dr As System.Data.SqlClient.SqlDataReader conn.ConnectionString = "Data Source=np:SQLSERVER1;uid=username;pwd=password;Initial Catalog=STARMT;Connection Timeout=5;" conn.Open() cmd.Connection = conn cmd.CommandText = "select * from customers" dr = cmd.ExecuteReader() Do While dr.Read ' Loop dr.Close() conn.Close() End Sub Thanks in advance. Clay Tag: A DbDataAdapter issue Tag: 99102
  - 7
    - SQLConnection I have few forms that I am trying just to display the data. In each form I need to fire different sqlstatements to get the data. Before executing each sql statement I am opening the connection, executing sqlreader, closing sqlreader and closing the connection. Sometimes I get errors like SQL connection is already open or sqlcon is busy fetching etc. What is the better approach for me to accomplish this. Thanks Tag: A DbDataAdapter issue Tag: 99097
  - 8
    - Missing SourceColumn mapping?! Hi all, having trouble with an Access database, it has a table "Books", the program uses a dataset to work with the database. I set up the schema for the table "Books" as follows: (C#) //////////////////////////// m_dataset.Tables.Add("Books"); DataColumn PrimaryKeyColumn = m_dataset.Tables["Books"].Columns.Add("ID",typeof(int)); m_dataset.Tables["Books"].PrimaryKey = new DataColumn[] {PrimaryKeyColumn}; m_dataset.Tables["Books"].Columns.Add("Name",typeof(string)); m_dataset.Tables["Books"].Columns.Add("ISBN",typeof(string)); m_dataset.Tables["Books"].Columns.Add("Price",typeof(float)); m_dataset.Tables["Books"].Columns.Add("iStock",typeof(int)); m_dataset.Tables["Books"].Columns.Add("mStock",typeof(int)); m_dataset.Tables["Books"].Columns.Add("Barcode",typeof(string)); m_dataset.Tables["Books"].Columns.Add("Description",typeof(string)); //////////////////////////// and then everytime i try to fill it with the dataadapter an exeption "Missing SourceColumn mapping for 'ID' " is thrown. Im totaly in the dark with this one, nothing I try makes any difference, any help would be great! Val Tag: A DbDataAdapter issue Tag: 99083
  - 9
    - Parameters.Add I am new to .Net. I have a windows form in which I am using a Stored Procedure to get the data. I am successful in retrieving the data, however after closing the form and reopening the form I landed in a problem . The error is too many parameters.What I did was I included a line SqlCmd.Parameters.Clear before Parameters.Add - line and I fixed the issue. Can any explain why this is happening and how I can control it? thanks Vb Tag: A DbDataAdapter issue Tag: 99082
  - 10
    - WriteXml & XmlDataDocument questions Hi everyone, I have a question regarding DataSets and the WriteXml method. Specifically, I'm having trouble writing out my DataSet, then reading the contents back in to an XmlDataDocument. For instance, my code reads like this: ///////////////////////// StringWriter l_strWrite = new StringWriter(); XmlDataDocument l_XMLDocument = new XmlDataDocument(); //MyDataSet is a pre-existing DataSet MyDataSet.WriteXml(l_strWrite,System.Data.XmlWriteMode.WriteSchema); l_XMLDocument.LoadXml(l_strWrite.ToString()); //////////////////////// No errors when I run this, however when all is said and done, my XmlDataDocument's DataSet member has zero tables, whereas the original ("MyDataSet") has one table in its collection. Something's not right-- maybe I'm not saving the DataSet correctly via WriteXml()? I realize the XmlDataDocument class has a DataSet member that I can assign to, however in my code I can't just simply set things equal to MyDataSet....I'm trying to write out the DataSet to a string then pass it around from one section of my program to another. Only later on will I create my XmlDataDocument. Maybe I should create a temporary DataSet from my string when the time comes, then assign it to my XMLDataDocument's DataSet member? Sounds like a hack, but maybe it's an option. I don't know. If you have any suggestions or ideas on how I can correctly write out/read in my DataSet to an XMLDataDocument, I'd be glad to hear them. Thanks very much. -Jim Tag: A DbDataAdapter issue Tag: 99078
  - 11
    - Select Top 10 from a DateTable??? Hi! I want to select only 10 rows from a dataTable each time, just as from a database("SELECT TOP 10 FROM orders WHERE ID <100 ORDER BY ID"). for example: DataTable myTable = new DataTable("orders"); DataRow[] rows = myTable.Select("TOP 10 ID < 100"); 1)How can I write the correct statement. 2)Can I ues "TOP" key word or there's other way to do it? P.S. I mean from a dataTable. Thank you very much. :shock: *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: A DbDataAdapter issue Tag: 99065
  - 12
    - Concurrency violation: the UpdateCommand affected 0 records. Wanted to post my scenario about this error message for others to benefit from... I was getting this error on a certain table and could not figure out why to save my life. I use the same data access strategy for all DA objects and was not having the problem with any other object/table. Here's what was going on: The Update proc generated by the Data Adapter Configuration Wizard creates 2 fields for every one... one for the current value and one for the "Original" value. I had a table with these columns: Logon_ID Username Password Original_Username Original_Password You should start to see the problem now. What happened was the DACW creates a parameter for the Username called "Original_Username", then I ALSO had the real field name "Original_Username". ADO.NET got confused and thought that the field had changed because it was looking at the wrong field, and it threw the "Concurrency violation: the UpdateCommand affected 0 records." error. I changed my field names to O_Username and O_Password and it was fixed. I liked to never found this. It was a real problem for a couple days. So, I wanted to share this info. I've had other problems like this stemming from using certain words for/in field names, so I've resolved to, at my next project, come up with a prefix to put in front of all column names. It will be kind of clumbsy when working directly in the Db (SQL), but the names can then be abstracted (the prefix can be stripped) in the business objects. At least it will avoid weird problems like this. Tag: A DbDataAdapter issue Tag: 99056
  - 13
    - how to determine logged on user? I have MSDE2000 using integrated authentication. How can I determine the username of the logged on user from my asp.net app? Tag: A DbDataAdapter issue Tag: 99053
  - 14
    - DataBind problem i made tow combobox one of them filled in page load and the other one fill when the user select a value form the First one but i got this error: "The Column prefix 'System.Data' does not match with a table name or alias name used in the query" and this my code: the First Combobox: SqlConnection cnn = new SqlConnection(); cnn.ConnectionString = DB.ConnectionSTR(DB.Current_DB()); SqlCommand cmd = cnn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Select Client_ID,Client_Name From Client"; SqlDataAdapter da = new SqlDataAdapter(); DataTableMapping TblMap; DataColumnMapping ColMap; TblMap = da.TableMappings.Add("Client","Client"); ColMap = TblMap.ColumnMappings.Add("Client_ID","Client_ID"); ColMap = TblMap.ColumnMappings.Add("Client_Name","Client_Name"); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds,"Client"); cboClient_Name.DataSource = ds; cboClient_Name.DisplayMember = "Client.Client_Name"; cboClient_Name.ValueMember = "Client.Client_ID"; The Seconde combobox: SqlConnection cnn = new SqlConnection(); cnn.ConnectionString = DB.ConnectionSTR(DB.Current_DB()); SqlCommand cmd = cnn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Select MSA_ID,MSA_Effective_Date From MSA Where Client_ID="+cboClient_Name.SelectedValue.ToString()+""; SqlDataAdapter da = new SqlDataAdapter(); DataTableMapping TblMap; DataColumnMapping ColMap; TblMap = da.TableMappings.Add("MSA","MSA"); ColMap = TblMap.ColumnMappings.Add("MSA_ID","MSA_ID"); ColMap = TblMap.ColumnMappings.Add("MSA_Effective_Date","MSA_Effective_Date"); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds,"MSA"); cboClient_Name.DataSource = ds; cboClient_Name.DisplayMember = "MSA.Client_Name"; cboClient_Name.ValueMember = "MSA.Client_ID"; Tag: A DbDataAdapter issue Tag: 99050
  - 15
    - DataBind problem i made tow combobox one of them filled in page load and the other one fill when the user select a value form the First one but i got this error: "The Column prefix 'System.Data' does not match with a table name or alias name used in the query" and this my code: the First Combobox: SqlConnection cnn = new SqlConnection(); cnn.ConnectionString = DB.ConnectionSTR(DB.Current_DB()); SqlCommand cmd = cnn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Select Client_ID,Client_Name From Client"; SqlDataAdapter da = new SqlDataAdapter(); DataTableMapping TblMap; DataColumnMapping ColMap; TblMap = da.TableMappings.Add("Client","Client"); ColMap = TblMap.ColumnMappings.Add("Client_ID","Client_ID"); ColMap = TblMap.ColumnMappings.Add("Client_Name","Client_Name"); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds,"Client"); cboClient_Name.DataSource = ds; cboClient_Name.DisplayMember = "Client.Client_Name"; cboClient_Name.ValueMember = "Client.Client_ID"; The Seconde combobox: SqlConnection cnn = new SqlConnection(); cnn.ConnectionString = DB.ConnectionSTR(DB.Current_DB()); SqlCommand cmd = cnn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Select MSA_ID,MSA_Effective_Date From MSA Where Client_ID="+cboClient_Name.SelectedValue.ToString()+""; SqlDataAdapter da = new SqlDataAdapter(); DataTableMapping TblMap; DataColumnMapping ColMap; TblMap = da.TableMappings.Add("MSA","MSA"); ColMap = TblMap.ColumnMappings.Add("MSA_ID","MSA_ID"); ColMap = TblMap.ColumnMappings.Add("MSA_Effective_Date","MSA_Effective_Date"); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds,"MSA"); cboClient_Name.DataSource = ds; cboClient_Name.DisplayMember = "MSA.Client_Name"; cboClient_Name.ValueMember = "MSA.Client_ID"; Tag: A DbDataAdapter issue Tag: 99049
  - 16
    - Performance counters SqlConnection vs ODBC vs OLE DB I'm trying to monitor connection pooling in a web app on our development web server. The connection string is a .Net SqlConnection string. I'm trying to monitor connection pooling via the .Net CLR data SQLClient counters but I am not seeing any connections being made in the pools. (pooling is on by default) Why am I not seeing any of the counters? I did see a reference someplace that said the counters would only show connections made by an ODBC connection string. Can anyone confirm this? Thanks John Tag: A DbDataAdapter issue Tag: 99047
  - 17
    - Still Problem with Dataview.Find Hello, When I Do Desc, It works but everything is backwards. All the records go from Z - A. I need them to go from A - Z and grab the first one it finds. ASC reproduces the behaviour stated below: I am retrieving data from a database "Order By LastName", when I use a dataview to find a Last Name it does not give me the first instance of the Last Name. ie. ADataView.Sort = "LastName" AnInteger=ADataView.find("Smith") BindingContext(ADataView).Position = AnInteger If there are more than one "Smith" in the database it goes to the second one instead of the First one. What I need is for it to go to the first one. Any suggestions will be greatly appreciated. Thanks, Chuck Tag: A DbDataAdapter issue Tag: 99046
  - 18
    - MSDTC Wrap Directly? Looking for any sample code on using MSDTC directly, without inheriting from ServicedComponent. I want to use MSDTC with xcopy deployment, so nothing can be hard-installed into the COM+ catalog or require Administrator rights. OS is XP and Win2003. Thanks. Tag: A DbDataAdapter issue Tag: 99045
  - 19
    - finding row position in a dataview based on multiple keys.... I am trying to find a row in a dataset using the key values (whether it is sorted by them or not) and then move to that row in the dataset. the DataView.Rows.Find(Keys()) works fine to return the row, but then I need to move the CurrencyManager to the correct position for the resulting datarow. Is there a way to move to a record in a dataview based on multiple keys? -- -Rick ________________________________ Hardware, n.: Part of a computer, that when played with long enough, will eventually break. Software, n.: Part of a computer, that when played with long enough, will eventually work. Tag: A DbDataAdapter issue Tag: 99038
  - 20
    - OdbcConnection with compatibility level 2 Hello, is there any way to initialize an OdbcConnection object restricted to ODBC V2 features even though the ODBC driver is version 3? I have a .NET assembly that is used as a COM-Server by another application. That application uses ODBC 2 and the ODBC driver returns the results in the version 2 way. After the app initializes the COM Server an my assembly connects to the same database using the same driver, the ODBC driver returns the result codes in the version 3 way. To the driver the app and the COM-Server appear as one process because it is an Inproc-Server. That confuses the app because statements like "delete from tableXYZ where 1=2" now return SQL_NO_DATA instead of SQL_SUCCESS. Anything but SQL_SUCCESS ist treated as an error by the SQL libs of that app. Sad but true. In the Reflector I discovered OdbcConnection has an internal property IsV3Driver and cache the major version of the driver. But everything seems to be private or internal. Do you have an idea? Any help is appreciated. Tag: A DbDataAdapter issue Tag: 99037
  - 21
    - Calling a Mdi child Form from a modal one The application loads the main form (mdi parent) and then it shows a modal form for validation porpuses. After the user writes the password the validation form closes, and then I need to call a Mdi child form. How can I do this? Tag: A DbDataAdapter issue Tag: 99032
  - 22
    - Update Command I am using parameters etc when populating a dataset using a DataAdapter. I have an Update command of the folllowing form : UPDATE projects SET ID=@ID,Address1=@Address1,Address2=@Address2,Postcode=@Postcode WHERE ID=@ID Where ID is my primary key. When I change Addres1 etc.. then use DataAdapter.Update(changes) everything is updated nicely, however if I change the ID value of one of the rows then use adapter.update(changes) I get a concurrency violation exception, presumably this occurs because I am trying to update the ID value when ID is in the WHERE clause. Is there anything I can do to correct this problem? Thanks, Steven Tag: A DbDataAdapter issue Tag: 99018
  - 23
    - Performance of Find? I was wondering what kind of algorithm is behind the DataRowCollection.Find method, where you are searching by the primary (and unique) key. Can I expect "table-scan"-like performance O(n) or is there some sort of indexing that makes it constant or logarithmic in performance? I'm currently contemplating doing some complex sums, either in the DB (which - of course - has the best performance on the actual calculations), or in my client (which would remove the connection overhead, and improve multiuser-scalability) Jesper. Tag: A DbDataAdapter issue Tag: 99016
  - 24
    - msde error Hi, I install msde 2000 using the command line like this => setup SAPWD="pass" But when I try to create a new database using access sql server database wizard he ask me for a login id and password! First if my password is pass what is the login id? When I try the login id of my computer user name or sa and the password as pass I always get an error message: Connection failed: SQLSTate:28000 SQLserver error:18452 Why??? Did my msde installation is good I set the server name and the msde icon in the try icons is on and running! Thanks! Tag: A DbDataAdapter issue Tag: 99014
  - 25
    - Using a multi-select ListBox to delete records I have a ListBox bound to a DataSet. I'd like to be able to select two or more items in the ListBox and delete the corresponding records in the Access table which serves as the data source. I have figured out how to edit multiple records, by using a Do...Loop construct to check each item in turn, test its state and edit it if it's selected. But I couldn't make that approach work when deleting records, because of course the number of records, and the index of each, changes every time a record is deleted. I know about the For Each...Next construct and the SelectedIndices collection, but I can't figure out how to use them to achieve the goal. Any ideas, anybody? Tag: A DbDataAdapter issue Tag: 99010

Hi all:

I have a view in my SQL, which combines 3 data from 3 tables. I have dragged
and dropped the View to my WebForm and VS created a DataAdapter. However it
cannot add the proper Update and Delete commands. I have tried creating 2
stored procedures for that purpose and I have modified the DataAdapter, but
when I call the DataAdapter.Update(MyDataSet), updating rows causes an
exception (some parameters of the sp haven't been passed), and deleting rows
silently fails.

Any tips?

Manuel.

Top

Re: A DbDataAdapter issue by Kris

Kris
Tue Nov 16 04:40:09 CST 2004

You have a parameter mismatch.
I assume that the update is for one of the tables. Drag this single table to
a component and verify the generated dataAdapter.

"Manuel Vázquez Acosta" <manu@chasqui.cu> wrote in message
news:OUhqLk5yEHA.3708@TK2MSFTNGP14.phx.gbl...
> Hi all:
>
> I have a view in my SQL, which combines 3 data from 3 tables. I have
> dragged
> and dropped the View to my WebForm and VS created a DataAdapter. However
> it
> cannot add the proper Update and Delete commands. I have tried creating 2
> stored procedures for that purpose and I have modified the DataAdapter,
> but
> when I call the DataAdapter.Update(MyDataSet), updating rows causes an
> exception (some parameters of the sp haven't been passed), and deleting
> rows
> silently fails.
>
> Any tips?
>
> Manuel.
>
>

Top