No exceptions in sqldataadapter

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
    - DataView to datatable, howto? Hi all I have a little project that uses CR.NET (Crystal reports). Unfortunately, CR.NET doesn't support Dataviews as source for their data (known bug, but still to be fixed). So I have to: 1. Extract data into a datatable 2. Refine (filter) data in the table to a dataview 3. Copy back data in datatable format (ie create a new datatable with the same format as per the one in point 1, then copy rows from the dataview to the new table). How can I do point 3? Can someone post a lilttle fragment of code on how to do that (VB or C# doesn't matter). thanx in advance Tag: No exceptions in sqldataadapter Tag: 64593
  - 2
    - Modification of Application Block for Data Access. Is it advisable to modify the code for Application Block for Data Access? Please give your expert views and problems of versioning and other practicle problems you have faced. Thanks, Johns. Tag: No exceptions in sqldataadapter Tag: 64589
  - 3
    - System.Data.OracleClient bug what do you recommend how to fix this problem? ======================================= OracleDataAdapter.Fill method doesn't work against Oracle 7.3 server. An oracle error occures: ORA-01002: Fetch out of sequence. The way to reproduce the problem: 1. Server-side script ----------------------------------------------------- CREATE TABLE TEST ( TESTCOL VARCHAR2(30) ) / insert into test (testcol) values ('123'); commit; ----------------------------------------------------- 2. Client code using System; using System.Data; using System.Data.OracleClient; namespace OracleError { class Class1 { [STAThread] static void Main(string[] args) { string cnnString="Data Source=OracleServer;User Id=USERNAME;Password=USERPASS;Enlist=false;"; string cmdText="SELECT * FROM TEST"; OracleConnection cnn=new OracleConnection(cnnString); OracleCommand cmd=new OracleCommand(); OracleDataAdapter adp=new OracleDataAdapter(cmd); DataSet ds=new DataSet(); cmd.Connection=cnn; cmd.CommandText=cmdText; try { cnn.Open(); adp.Fill(ds); cnn.Close(); } catch (System.Data.OracleClient.OracleException err) { System.Console.Write(err.Message); } } } } Tag: No exceptions in sqldataadapter Tag: 64585
  - 4
    - Add row to dataview auto ForeignKey /* Hi all, Following is the code and my question is I have a component that provides clients different DataViews of a DataTable. So what I want to do is when the clients try to add a row into the DataView I want the row to be automatically filled with the foreign key. This question again appears in detail in the code below Thanks In Advance Sankar Nemani */ using System.Data; using System; public class Test { public static void Main() { DataSet ds; DataTable dtCountries, dtCities; DataView dvCitiesInIndia; //create the dataset ds = new DataSet(); //creating the two datatables dtCountries = new DataTable("Countries"); dtCities = new DataTable("Cities"); ds.Tables.Add(dtCountries); ds.Tables.Add(dtCities); //adding columns to the countries table dtCountries.Columns.Add("CountryID",Type.GetType ("System.Int32")); dtCountries.Columns.Add("Country"); dtCountries.PrimaryKey = new DataColumn[] {dtCountries.Columns["CountryID"]}; //adding columns to the cities table dtCities.Columns.Add("CountryID",Type.GetType ("System.Int32")); dtCities.Columns.Add("CityID",Type.GetType ("System.Int32")); dtCities.Columns.Add("City"); dtCities.PrimaryKey = new DataColumn[] {dtCities.Columns["CityID"]}; //now add the foreign key relation ds.Relations.Add ("CountryCityRelation",dtCountries.Columns ["CountryID"],dtCities.Columns["CountryID"],true); //add some data DataRow drNew; drNew = dtCountries.NewRow(); drNew["CountryID"] = 1; drNew["Country"] = "USA"; dtCountries.Rows.Add(drNew); drNew = dtCountries.NewRow(); drNew["CountryID"] = 2; drNew["Country"] = "India"; dtCountries.Rows.Add(drNew); drNew = dtCities.NewRow(); drNew["CountryID"] = 1; drNew["CityID"] = 1; drNew["City"] = "Atlanta"; dtCities.Rows.Add(drNew); drNew = dtCities.NewRow(); drNew["CountryID"] = 1; drNew["CityID"] = 2; drNew["City"] = "Seattle"; dtCities.Rows.Add(drNew); drNew = dtCities.NewRow(); drNew["CountryID"] = 1; drNew["CityID"] = 3; drNew["City"] = "New York"; dtCities.Rows.Add(drNew); drNew = dtCities.NewRow(); drNew["CountryID"] = 2; drNew["CityID"] = 4; drNew["City"] = "Mumbai"; dtCities.Rows.Add(drNew); drNew = dtCities.NewRow(); drNew["CountryID"] = 2; drNew["CityID"] = 5; drNew["City"] = "New Delhi"; dtCities.Rows.Add(drNew); drNew = dtCities.NewRow(); drNew["CountryID"] = 2; drNew["CityID"] = 6; drNew["City"] = "Chennai"; dtCities.Rows.Add(drNew); //create a dataview for cities in india dvCitiesInIndia = new DataView(dtCities); dvCitiesInIndia.RowFilter = "CountryID=2"; //add a new row to this dataview DataRowView drv = dvCitiesInIndia.AddNew(); drv["CityID"] = 7; drv["City"] = "Hyderabad"; drv.EndEdit(); /*************ISSUES***************************/ /*1.The following line of code would throw an exception because this row is no longer part of the dataview due to the DataView's RowFilter i.e., "CountryID=2"*/ //System.Console.WriteLine(drv["City"]); /*2.Now the city "Hyderabad" does not have a country associated with it*/ /************Questions***********************/ /*I have a component that provides clients different DataViews of a DataTable. So what I want to do is when the clients try to add a row into the DataView I want the row to be automatically filled with the foreign key ex:CountryID. Basically I want to set a default value for the CountryID column. I know I can set a default value for the CountryID column in the Cities "DataTable". But that would not set a different default value for each DataView. Then all cities would belong to only one country. So is there a way to set a default value for a column at a DataView level?*/ if(System.DBNull.Value.Equals(dtCities.Rows[6] ["CountryID"])) { System.Console.WriteLine("Country ID is null"); } System.Console.WriteLine(dtCities.Rows[6]["City"]); } } Tag: No exceptions in sqldataadapter Tag: 64580
  - 5
    - Ê±¼äÀàÐÍ ²åÈë£¬×ª»¯ cmd.parameter.add("@firstOnDuty",sqldbtype.datetime,"firstOnduty") cmd.parameter(0).value=cdate(firstOnDuty.text) Èç¹û firstOnDuty.text=9:00 ,cdate(firstOnDuty.text)=#9:00:00 AM#, ÏµÍ³»á±¨´í"SqlDateTime Òç³ö¡£±ØÐë½éÓÚ 1/1/1753 12:00:00 AM ºÍ 12/31/9999 11:59:59 PM Ö®¼ä" Èç¹ûcdate(firstOnduty.text)=#1/11979 9:00:00 Am#,ÏµÍ³²»»á³ö´í¡£ Èç¹ûÎÒÔÚsql server ÖÐÖ±½ÓÐ´Èë9£º00£¬ÏµÍ³»á×Ô¶¯×ª»»Îª9:00:00,²»»á±¨´í ËùÒÔÎÒÈÏÎªÊÇsqldbtype.datetime µÄÎÊÌâ£¬ÎÒÖ»Ïë²åÈëÊ±¼ä£¬²»Ïë²åÈëÈÕÆÚ£¬ÇëÎÊÎÒ ¸ÃÈçºÎ×ö£¿ Ð»Ð»£¡£¡ Tag: No exceptions in sqldataadapter Tag: 64577
  - 6
    - Encrypted password stored in registry I am storing encrypted password in registry and using it then to log on my application. However, my objConn.Open(str_connecton_string) crashes the application if I use the encrypted password. My connection string works fine with an unencrypted password and looks like: str_connection_string = "data source=XXXX;initial catalog=dbname;user ID=username;password=encryptedpassword;connection timeout = 5" Any help will be appreciated. -- Dino Buljubasic Software Developer http://rivusglobal.com Tag: No exceptions in sqldataadapter Tag: 64571
  - 7
    - Login Failed, catalog Information cannot be retrieved Has anybody actually ever resolved the problem described below? If so, would you please share the solution? I am trying to use MS Visual Studio to connect to an SQL Server database. When I use the Tools/Connect to Database, the DataLink Properties window pops up and I select the provider (MS OLEDB for SQL Server), then the server name and database on server. Then I check "Test Connection" and immediately get a dialog box that says "Test Connection Succeeded." I click the OK button and then I get 17 boxes, sequentially that say "Login Failed, Catalog Information cannot be retrieved." I dismiss each box by clicking "OK" and eventually the boxes all go away. I have seen this message numerous times in user groups over the last year, but I have not seen a solution that seems to have resolved the problem. I have twice reloaded the MDAC. The same file works fine when run from my server running Windows 2000 and SQL Server 2000, Enterprise Edition, so it isn't a bad database file. It also works fine in conventional ASP(VBScript) coding from the IIS on my XP Machine. I am running: - Windows XP with all the latest patches, fixes, etc.; - Visual Studio .NET, Enterprise Architect, Framework ver 1.0.3705, MDE 2002, ver 7.0.9466 - SLQ Server 2000 Desktop Engine - MDAC 2.8 (tried 2.7SP1WinXP same result) Thanks for any assistance Dick Marcum dm@herald21.com Tag: No exceptions in sqldataadapter Tag: 64566
  - 8
    - ExecuteReader requires an open and available Connection. The connection's curren Hi, I'm having problem with database connection in my asp.net application. It's some kind of mistery. It throws "ExecuteReader requires an open and available Connection. The connection's current state is Closed. " exception some times. I'm sure that in my code everything fine and my connection is open. If I refresh the page after this error pups up, it gets back to normal. Some time ago I came accross KB article stating that this is microsoft BUG, but it's not there anymore. Does any one know what might be wrong. I'm using SQL server as database. Thank you Lyuba Tag: No exceptions in sqldataadapter Tag: 64559
  - 9
    - Does .Net ADO work on Windows NT? I'm trying to run an application written in VB .Net on a Windows NT 4.0 (service pack 6a) workstation. The application is referencing .Net ADO. This reference causes the application to crash. Is this a known problem and is there any workaround for it? Thank you. Chris C Tag: No exceptions in sqldataadapter Tag: 64553
  - 10
    - ado.net v2 Hi What would be good in ado.net v2? Thanks Regards Tag: No exceptions in sqldataadapter Tag: 64550
  - 11
    - Is there a succinct FAQ link similar to the one I list for WindowsForms? The following is a link to a very handy FAQ for WindowsForms. Is there a similar one for WebForms? I know about the sites www.asp.net, www.gotdotnet.com and such, but is there one like this: http://www.syncfusion.com/faq/winforms/ Thanks, Eric Tag: No exceptions in sqldataadapter Tag: 64549
  - 12
    - AutoFormatting datagrid at runtime Is it possible to invoke the AutoFormat dialog (for DataGrids) at runtime and setting all the colors on OK? If so, what references and namespaces do I need? TIA, Bronco Tag: No exceptions in sqldataadapter Tag: 64548
  - 13
    - formatting numbers & columns in datagrid I am still working away to get to grips with .NET web forms. Can anyone help me with these conundrums? How do I programmatically control the with of a datagrid itself and the columns in it? At the moment my grid is wider than the columns, leaving a spare bit to the right, and yet some of my columns are too narrow. Can I even get them to adjust automatically, eg to the width of the widest cell value? Also, how do I get numeric data to display correctly? The data comes from a sql query. I want it to display to 2 decimal places even if ".00", but at the moment I can't get it to give me those extra zeros whatever I do. I also had a problem figuring out how to right align the columns of figures. I fiddled with the GUI and managed this, but more by accident than design and I still don't know how I did it. In any event for future reference I want to know how to do it programatically. Has anyone any tips? -- John Wilson Tag: No exceptions in sqldataadapter Tag: 64539
  - 14
    - Problem with OracleClient and Dotnet Framework 1.1 Hi folks, after upgrading from VS2002 to VS2003 I have a big problem with my database connection. I have two Oracle databases, comunication via a database link and the Data Provider for Oracle. MDB references the first database BDB references the second database. The Databases are connected via a TCP/IP Network and are running on different servers. A call like "SELECT * FROM <TABLE>@BDB" on the first server results in the error ORA-02401 Remote Client did not start a transaction! The Exception occurs when I call the ExecuteReader() Method OracleReader reader = ((OracleCommand)command).ExecuteReader(); !!! This worked perfectly with the OracleClient addon for Framework 1.0 !!! When I use the old library of System.Data.OracleClient in my software it works properly, but this can not be the solution. My System: ************************** XP PROF SP1 VS2003 (Framework 1.1) Oracle 8.1.7 Server Standard Edition Any help is very welcome, because in the moment I have no more ideas. Thanx in advance Frank Tag: No exceptions in sqldataadapter Tag: 64535
  - 15
    - GetXML doesn't show Computed Columns Anyone know if this is the way this is supposed to be working or any potential workarounds? I have a DateTime column 'DateExpires' which I am returning as a computed column via my SELECT statement. When I call GetXML() on the DataSet, it isn't returning the computed column. However, when I do a quickwatch on the DS, I see that the column is in the dataset. Also, I have a bound webform control which is getting populated with the value from this column in the dataset. strCmd = "SELECT ID, CAST((DATEPART(m, DateExpires)) as varchar(2))+ '/' + CAST((DATEPART(d, DateExpires)) as varchar(2))+ '/' + CAST((DATEPART(yy, DateExpires)) as varchar(4)) as DateExpires FROM Articles" sqlDA.SelectCommand = new SqlCommand(strCmd, sqlCN); sqlDA.Fill(objDS); objDS.GetXML() returns: <DSArticles xmlns="http://tempuri.org/Schema_Articles.xsd" /> <NewDataSet> <Articles> <ID>e75baa38-f084-472e-a14f-2517f00f3d67</ID> </Articles> </NewDataSet> XSD as follows: <?xml version="1.0" encoding="utf-8"?> <xs:schema id="Schema_Articles" targetNamespace="http://tempuri.org/Schema_Articles.xsd" elementFormDefault="qualified" xmlns="http://tempuri.org/Schema_Articles.xsd" xmlns:mstns="http://tempuri.org/Schema_Articles.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="Document"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="Articles"> <xs:complexType> <xs:sequence> <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" /> <xs:element name="DateExpires" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="DocumentKey1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Articles" /> <xs:field xpath="mstns:ID" /> </xs:unique> </xs:element> </xs:schema> Tag: No exceptions in sqldataadapter Tag: 64522
  - 16
    - Update Command / Data bound controls Problem Greetings All, I am currently working with VB .NET and having an issue with updating an ACCESS DB via ADO.NET.. Any help would be great. I am using the data object components. (oledbconn, dataAdapter, & Dataset).. The dataadapter fills the dataset just fine. The data is bound to several textboxes. My navigation controls work just fine as well. However whenever I make a change to a textbox field and hit update the changes are not made to the DB. Ive included a msgbox to say yeah or nah to changes. It always says false. I am using the generated UPDATE command. What am I doing wrong? Generic Code Snippett sub : LOADDB da.fill(ds,"Users") end sub sub UpdateDB messagebox.show(ds.haschanges) da.update(ds) end sub Thanks Rob Tag: No exceptions in sqldataadapter Tag: 64521
  - 17
    - Access is denied - SQL server Hello everyone. I installed new Win 2000 server(instead of Profi), Since then I can't connect to SQL server that is in another comuter although I used the same code and slq server is still the same. I have still exception : "System.ApplicationException: Access is denied." in SqlConnection.Open(). I use MDAC 2.8, but I also tryed 2.7 SP1 2.7 and 2.6 with the same result. Thanks Tag: No exceptions in sqldataadapter Tag: 64518
  - 18
    - Speed/Complexity Concern of ADO.NET Hello everyone. I'm still new to .NET, but have experience with VB6, C++ and the Java language, so I think Im catching on fast. My question is, everything I have been reading seems to indicate that ADO.NET is a lot more complicated than ADO was, and in fact, requires more programming to do the same thing. Also, looking at the descriptions of the datareader and datatable objects, seems that the datatable objects would require more memory and resources that the previoous ADO recordsets. We are getting ready to do a complete application rewrite and I am attempting to determine the best methods for the program, where to use this and that, etc. Can anyone offer their opinions or experiences with regards to working with ADO.NET? Thanks. Tag: No exceptions in sqldataadapter Tag: 64498
  - 19
    - DataTable.Select method problem (can't understand DateDiff) I've got a DataTable object which I want to filter using it's Select method, but it doesn't recognize the DateDiff function in the filter string (which is odd considering the DataTable was populated with a query containing the DateDiff function). Is there some way around this? Is there a different syntax for doing this in a datatable's Select method? - Don Tag: No exceptions in sqldataadapter Tag: 64496
  - 20
    - Displaying the nodes of the treeView in the listView any example of how to display the nodes of the treeView into the listView and update it everytime you select other nodes? a simple code i've created is as follows: --------------------------------------------------------------------- private void treeView1_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e) { foreach (DataRow dr in dt.Rows) { listView1.Items.Add(dr["Name"].ToString()); } } --------------------------------------------------------------------- any help or idea would be very much appreciated. thank u, Kam Tag: No exceptions in sqldataadapter Tag: 64486
  - 21
    - Distributed transaction problem I am using COM+ components, every client request kicks of a chain call of these components. One of the components executes a SQL query, and this fails every time for a particular client request. I am getting the following exception on execution of the query. Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. System.Exception _stackTraceString " at System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbDataReader.NextResult() at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal (CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader (CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.Execu teReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand (Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) Database : SQL Server 2000 SP3 .Net server : Windows 2003 Server on Dual processor m/c Data provider : OleDb MDAC : 2.7 Tag: No exceptions in sqldataadapter Tag: 64481
  - 22
    - Using Sum in SQL I am trying to figure out how to get the sum for each day. This is what I have for SQL SELECT fldDate, sum(total) FROM tbl GROUP BY fldDate ORDER BY fldDate The date field has date and time in it, I assume if I can format the date field to use only the date, then query will work. Please let me know how to format the date in query or there is a better way. Thanks Tag: No exceptions in sqldataadapter Tag: 64479
  - 23
    - odbc.net output parameter truncated to 256 bytes This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C3716A.3B7BFF80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,=20 I've an .NET application in C# who connects to a Sybase db through = ODBC.NET data provider of the 1.1 Framework. The code execute a simple stored procedure, GETOBJECT passing two = parameters, an input ID and a output OBJECT. The ID field is a = varchar(50), while the OBJECT is a VarBinary(7800). Here is the code I use to add parametes and execute the stored = procedure: OdbcConnection conn =3D new OdbcConnection(strOdbcConnSybase); OdbcCommand cmd =3D new OdbcCommand(); OdbcParameter id =3D new OdbcParameter(); id.Direction =3D ParameterDirection.Input; id.OdbcType =3D OdbcType.VarChar; id.Value =3D tbxKey.Text; id.ParameterName =3D "@ID"; cmd.Parameters.Add(id); OdbcParameter obj =3D new OdbcParameter(); obj.Direction =3D ParameterDirection.Output; obj.OdbcType =3D OdbcType.VarBinary; obj.Size =3D 7800; obj.ParameterName =3D "@OBJECT"; cmd.Parameters.Add(obj); cmd.Connection =3D conn; cmd.CommandType =3D CommandType.Text; cmd.CommandText =3D "{call GETOBJECT (?, ?) }"; conn.Open(); cmd.ExecuteNonQuery(); byte[] outData =3D (byte[])cmd.Parameters[1].Value; conn.Close(); Everything works fine with the ExecuteNonQuery, but where I try to = retrieve the output parameter OBJECT its Value is truncated to 256 = bytes, while on the db its value is 400 bytes. Changing the Value property of the output parameter nothing changes, = even if I set it to 100, the returned value is 255 (being on the db of = 400 bytes). So it's clear that the Size property of the parameter has = not been taken into account by the provider. Any suggestions? Bye Luca ------=_NextPart_000_000A_01C3716A.3B7BFF80 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>Hi, </FONT></DIV> <DIV><FONT face=3DArial size=3D2>I've an .NET application in C# who = connects to a=20 Sybase db through ODBC.NET data provider of the 1.1 = Framework.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The code execute a simple stored = procedure,=20 GETOBJECT passing two parameters, an input ID and a output = OBJECT. The=20 ID field is a varchar(50), while the OBJECT is a = VarBinary(7800).</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Here is the code I use to add parametes = and execute=20 the stored procedure:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> <P><FONT face=3DArial size=3D2>OdbcConnection conn =3D new=20 OdbcConnection(strOdbcConnSybase);<BR>OdbcCommand cmd =3D new=20 OdbcCommand();</FONT></P> <P><FONT face=3DArial size=3D2>OdbcParameter id =3D new=20 OdbcParameter();<BR>id.Direction =3D = ParameterDirection.Input;<BR>id.OdbcType =3D=20 OdbcType.VarChar;<BR>id.Value =3D tbxKey.Text;<BR>id.ParameterName =3D=20 "@ID";<BR>cmd.Parameters.Add(id);</FONT></P> <P><FONT face=3DArial size=3D2>OdbcParameter obj =3D new=20 OdbcParameter();<BR>obj.Direction =3D = ParameterDirection.Output;<BR>obj.OdbcType =3D=20 OdbcType.VarBinary;<BR><STRONG>obj.Size =3D = 7800;</STRONG><BR>obj.ParameterName =3D=20 "@OBJECT";<BR>cmd.Parameters.Add(obj);</FONT></P> <P><FONT face=3DArial size=3D2>cmd.Connection =3D = conn;<BR>cmd.CommandType =3D=20 CommandType.Text;<BR>cmd.CommandText =3D "{call GETOBJECT (?, ?)=20 }";</FONT></P> <P><FONT face=3DArial=20 size=3D2>conn.Open();<BR>cmd.ExecuteNonQuery();<BR><STRONG>byte[] = outData =3D=20 (byte[])cmd.Parameters[1].Value;<BR></STRONG>conn.Close();</FONT></P> <P><FONT face=3DArial size=3D2>Everything works fine with the = ExecuteNonQuery, but=20 where I try to retrieve the output parameter OBJECT its Value is = truncated to=20 256 bytes, while on the db its value is 400 bytes.</FONT></P> <P><FONT face=3DArial size=3D2>Changing the Value property of the output = parameter=20 nothing changes, even if I set it to 100, the returned value is 255 = (being on=20 the db of 400 bytes). So it's clear that the Size property of the = parameter has=20 not been taken into account by the provider.</FONT></P> <P><FONT face=3DArial size=3D2>Any suggestions?</FONT></P> <P><FONT face=3DArial size=3D2>Bye</FONT></P> <P><FONT face=3DArial size=3D2>Luca</FONT></P> <P><FONT face=3DArial size=3D2></FONT> </P></DIV></BODY></HTML> ------=_NextPart_000_000A_01C3716A.3B7BFF80-- Tag: No exceptions in sqldataadapter Tag: 64478
  - 24
    - Error Accessing ACCESS.MDB Hello All, I write the following code to access Data from a table But i get the exception "Syntax Error in From Clause" when i write the code in SQL then it works perfectly. OleDbConnection Myconnection = null; OleDbDataReader dbReader = null; Myconnection = new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source=C:\STTS.mdb"); Myconnection.Open(); OleDbCommand cmd = Myconnection.CreateCommand(); cmd.CommandText = "SELECT * FROM user"; dbReader = cmd.ExecuteReader(); string Email; while(dbReader.Read()) { Email = (string)dbReader.GetValue(0); lb.Items.Add(Email); } dbReader.Close(); Myconnection.Close(); Can anybody tell me where is the error Thanks Tag: No exceptions in sqldataadapter Tag: 64476
  - 25
    - Problem with NewRow of DataBindings. Hello, I need some help here, I will try to explain my situation in hope someone will can assist : 2 DataTables with Relations, 1 DataGrid on the form, 1 ListBox on the form. According the SelectedItem in the ListBox the data on DataGrid is changed (by using the Relations). The DataBindings is working perfectly ( DataGrid.DataBindings was set on the that Relation). The Problem : User add new item in the ListBox and then try to add new item to the DataGrid for the new item in the ListBox. The item will not appear in the DataGrid until I will change the item in the ListBox to other item and select again the new one. For Example : 1 DataTable for Shops, 1 DataTable for Customers, Relation between Shops.SHOP_ID to Customers.SHOP_ID. DataGrid.DataBinding set to that Releation, ListBox.DataSource set to DataTable of SHOPS. This way every click on the ListBox will display the Customers of that shop in the DataGrid Until here it's working perfect. The Problem occur when I'm trying to write this code : DataRow dr1 = dtShops.NewRow(); dtShops.Rows.Add(dr1); DataRow dr2 = dtCustomers.NewRow(); dtCustomers.Rows.Add(dr2); dr2["SHOP_ID"] = dr1["SHOP_ID"]; This code should display new item in the ListBox and new item in the DataGrid, but unfortunately the item in DataGrid can't display. If I want to it - I must change the item in the ListBox for other item and get back to the new shop I entered. Can it be bug in VS.NET ? 10x. Tag: No exceptions in sqldataadapter Tag: 64473
- Next
  - 1
    - Analysis Services with ADO.NET (OleDB) + ADOMD with .net Hi! We've been experimenting a bit with Analysis Services and .net. We've gotten as far as getting a dataset filled with results from an MDX query using the OLEDB provider for msolap. But when we try to bind the dataset to a grid, only the first column (rows dimension) in the result is shown. The grid is set to build columns at runtime. How come? :P Secondly, we've been experimenting with ADOMD in .net. What we wanted was to return a CellSet from a webservice - The result was an error like "CellSet doesn't support serializing". Is this not possible at all? Or do we have to encapsulate it in another class that can serialize it? And if we make this work.. can we databind a cellset? Any hints appreciated :) Lars-Erik Tag: No exceptions in sqldataadapter Tag: 64464
  - 2
    - Regional differences Hi, I try to insert a decimal number,say, "3.45" to a field, but because my regional settings are for europe, decimal separator is "," so "3.45" is taken as "345" by MS Access. How can I insert a decimal number, no matter is reginal setting? Thank you. Tag: No exceptions in sqldataadapter Tag: 64463
  - 3
    - Extended SQL Stroed Procedures Hello there, I'm looking for some doc or samples for creating Extended stored procedures within .NET (C#). Many thanks. Laurent.Lequenne@kickthatword.digipoint.be Tag: No exceptions in sqldataadapter Tag: 64454
  - 4
    - Using ODBC to make connections I've come from a background of using ODBC DSN's on Web Servers to make connections to SQL Server I see in ADO.NET this has been dropped (cant find samples where it is used) - may it's still there but I dont see examples. Does this mean by NOT using ODBC DSN's a connection can be made faster ? Background to statment: Making the connection is the slowest part of my SQL Server based interaction Any comments would be appreciated. - peteZ Tag: No exceptions in sqldataadapter Tag: 64453
  - 5
    - ODBC DBHandle Hi All, Is there any possability to retrieve the DBHandle (m_hdbc in MFC) from a .NET OdbcConnection class? We would need to do this because we need to call an MFC DLL for some updates in the same transaction that we started in our .NET server. TIA Thomas Bodell Tag: No exceptions in sqldataadapter Tag: 64452
  - 6
    - OracleParameterCollection Since I've upgraded to VS.Net 2003 I receive the following message every time I want to add a parameter to an OracleParameterCollection: The OracleParameter with ParameterName <ParamName> is already contained by another OracleParameterCollection. Does anyone know why this is happenning since it was working fine on the previous version? Tag: No exceptions in sqldataadapter Tag: 64449
  - 7
    - Getting A List Of Installed Data Providers I want to get a list of the installed ADO.NET Data Providers on a machine. The only way I can see to do this is to look at each and every assembly in the GAC and use Reflection to see whether the classes contained within have the necessary signatures which identify them as data provider classes (i.e. they support the IDbConnection, IDbCommand etc. interfaces). This seems a bit unnecessary and a bit low tech. Does anyone know of a better way ? Is there some sort of RegisterDataProvider technique which data providers have to use to register themselves which I might make use of ? Nick Carter Tag: No exceptions in sqldataadapter Tag: 64446
  - 8
    - System.Data.RowNotInTableException - Why? Hi everybody, I am having the following problem. While running my program I create a DataRow (State - Detached). Then I add it to the DataTable (State - Added), and delete it (State - Detached). Later I try to update the db by doing this DataAdapter.Update(DataTable.Select("", "", DataViewRowState.Added)) DataAdapter.Update(DataTable.Select("", "", DataViewRowState.Modified)) DataAdapter.Update(DataTable.Select("", "", DataViewRowState.Deleted)) When I try to update the deleted records I get the following message: "This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row. System.Data.RowNotInTableException" Does anyone know why this happens? Tag: No exceptions in sqldataadapter Tag: 64441
  - 9
    - Null and Stored Procedure How do I pass a null to a stored procedure from VB.Net. I have tried to pass nothing but that throws an exception. Here is my parameter command.Parameters.Add(New SqlParameter("@DLExpiration", SqlDbType.SmallDateTime, 4, ParameterDirection.Input, False, 16, 0, _ "DLExpiration", DataRowVersion.Proposed, DB.getDate(Me.DLExpirationDate.Text))) Tag: No exceptions in sqldataadapter Tag: 64420
  - 10
    - using DataLink files Hi I read in the Microsoft ADO.NET book that i could use a DataLink file to store/set the connection string. It said there that I should use the name-value pair File Name=myDataLink.udl. Now i tried this when creating a connection but it creates an error when trying to run. I looked in the help files and the name-value pair is not listed their for a connection constructor. Public Class frmMeny Dim con1 As New sds.SqlConnection("File Name=DbConnection.udl") Does anyone know how to get this to work? It would be really helpful! Thanks KMS Tag: No exceptions in sqldataadapter Tag: 64417
  - 11
    - could not find installable ISAM When I try to open a connection to Excel with this string: string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "DataSource=C:\\Worksheet1.xls;" + "Extended Properties=Excel 8.0;HDR=YES;"; con.open(); I receive this error when I try to open the connection: Unhandled Exception: System.Data.OleDb.OleDbException: Could not find installable ISAM. at System.Data.OleDb.OleDbConnection.ProcessResults (Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider () at System.Data.OleDb.OleDbConnection.Open() at RetrieveExcel.RetrieveExcel.Main(String[] args) Tag: No exceptions in sqldataadapter Tag: 64412
  - 12
    - DataSet Merge & Expression Fields Hi everyone, I've noticed something strange using expression fields with ds merge method in ado.net. First of all, I create the schema via code. I've added also an expression column in the Contracts Datatable: col = ds.Tables["Contracts"].Columns.Add("CompanyName"); col.Expression = "Parent(CustomersContracts).CompanyName"; I don't use a data adapter to fill the dataset in fact I need to call a web service method that returns a dataset. Once I get the dataset from the webservice, I merge the data retrieved in the Contracts Table. ds.Merge(RetrievedDataSet); If I try to read the expression field for the contracts retrieved they're all DBNull. This doesn't happen if I try to fill the dataset with a data adapter. Any idea? Do I need to call something before reading the expression column? Thanks Laura Tag: No exceptions in sqldataadapter Tag: 64408
  - 13
    - distinct selection in a dataview How can i get a dataview of a table, saiyng that i want to select the rows by a column y a distinct way for example i want to create a dataview of el the countries in a table, so a wna t to get yous the distinc value for the field country? txs Tag: No exceptions in sqldataadapter Tag: 64406
  - 14
    - Add row, ODBC and ADO.NET Hi! I have a beginner problem and hope that someone easily can solve my problem. I want to connect to my Access database with ODBC. I have downloaded MS ODBC library for connection with ODBC from .NET. It looks like I get the data and able to add the row, but when I should update the source with the new data it doesn't work. Can you please give me a good link or tell me what's wrong below. Please help! Code: // Create a SQL statement string mySelectQuery = "SELECT * FROM Bokning"; // ... a connection string string sConnString = "Dsn=Bokning_new"; OdbcConnection oODBCConnection = new OdbcConnection(); oODBCConnection.ConnectionString = sConnString; oODBCConnection.Open(); // Create a command object OdbcCommand myOdbcCommand = new OdbcCommand (mySelectQuery , oODBCConnection); // Create an adapter, initialized with the command object OdbcDataAdapter da = new OdbcDataAdapter(myOdbcCommand); // Create a dataset DataSet ds = new DataSet("bokning_new"); // Name could be whatever // Fill the DataSet with data from the database da.Fill(ds); DataTable myTable = ds.Tables[0]; //DataTable myTable = ds.Tables(0); DataRow newRow = myTable.NewRow(); newRow["Date"] = DateTime.Today.ToShortDateString(); myTable.Rows.Add(newRow); da.Update(ds); // Close connection oODBCConnection.Close(); Regards, /Marcus Tag: No exceptions in sqldataadapter Tag: 64405
  - 15
    - SP resulting in Timeout expired Hello, From a VB .net application I'm calling an SQL stored procedure and filling the results in an SQLDataReader, whose results are returned to an ASP .Net page. The procedure was running fine and all of a sudden it started giving this error: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. When I run the stored procedure in Query Analyzer it takes 1 sec. I tried to monitor it in Profiler by adding the Stored Procedure Events, and I found that it is getting stuck at a statement that goes similar to the following: INSERT INTO #Tempf SELECT t.SerNo, t.Name FROM #Temp t WHERE t.Value=x #Tempf and #Temp are created explicitly at the beginning of the procedure. #Temp contains around 16,000 records. This statement is not being completed. I have no idea about what the error might be from and I would appreciate any help or idea about what might be causing this error. Thanks, Grace Tag: No exceptions in sqldataadapter Tag: 64397
  - 16
    - BUG: Object reference not set to an instance of an object. This is a multi-part message in MIME format. ------=_NextPart_000_0018_01C370AC.30E3D7F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I found this error message, when trying to login to my database, i have tow text boxes 'userid' and 'password' and a button 'login' it is working perfectly but some time it generates the error messsage=20 Object reference not set to an instance of an object.=20 What is it mean? I am using to authenticate user via stored procedure having two param.=20 Please REply ASAP. Regards, --=20 Ather Ali Shaikh Software Engineer eIntelligence (Pvt.) Limited. Ph. (+92-21) 2434070, 2415929-30 email. ather.ali@eintelligencesoft.com web. www.eintelligencesoft.com ------=_NextPart_000_0018_01C370AC.30E3D7F0 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.2600.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2> I found this error message, when = trying to=20 login  to my database,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>i have tow text boxes 'userid' and = 'password' and a=20 button 'login'</FONT></DIV> <DIV><FONT face=3DArial size=3D2>it is working perfectly but some time = it generates=20 the error messsage </FONT></DIV> <DIV> <P><FONT face=3DArial color=3D#ff0000><STRONG>Object reference not set = to an=20 instance of an object. </STRONG></FONT></P></DIV> <DIV><FONT face=3DArial size=3D2>What is it mean?</FONT></DIV> <DIV><FONT face=3DArial size=3D2> I am using to authenticate user = via stored=20 procedure having two param. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Please REply ASAP.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Regards,</FONT><BR><FONT face=3DArial = size=3D2>--=20 <BR>Ather Ali Shaikh<BR>Software Engineer<BR>eIntelligence (Pvt.)=20 Limited.<BR>Ph. (+92-21) 2434070, 2415929-30<BR>email. </FONT><A=20 href=3D"mailto:ather.ali@eintelligencesoft.com"><FONT face=3DArial=20 size=3D2>ather.ali@eintelligencesoft.com</FONT></A><BR><FONT = face=3DArial=20 size=3D2>web. </FONT><A href=3D"http://www.eintelligencesoft.com"><FONT = face=3DArial=20 size=3D2>www.eintelligencesoft.com</FONT></A></DIV></BODY></HTML> ------=_NextPart_000_0018_01C370AC.30E3D7F0-- Tag: No exceptions in sqldataadapter Tag: 64395
  - 17
    - binding to a field on a child form Hello, I wish to bind a textbox on a child form (frmprojectinfo) to a dataset value, I originally bound it to a textbox on the current form and it worked perfectly. ' Here is the code I use to call the child form (frmProjectInfo) dim objchild as new frmProjectInfo objchild1.MdiParent = Me.MdiParent objchild1.Show() ' Here is the code that I use to bind the child form text box to projlist(a collection), the initial value is set ok Me.objchild1.ProjectSiteName.DataBindings.Add("Text", ProjList, "ProjectSiteName") This is the code that updates the bound field on the child form, datasetprojects is a dataset Dim DrCurrentProj As DataRow DrCurrentProj = datasetProjects.Tables ("Project").Rows.Find(IntProjectId) DrCurrentProj.BeginEdit() DrCurrentProj("projectSiteName") = Me.objchild1.ProjectSiteName.Text DrCurrentProj.EndEdit() Dim objCommandBuilder As New SqlCommandBuilder (MysqlDataAdapter) MysqlDataAdapter.Update(dsProjects, "Project") 'this does not update the bound field on the child form, it does not give an error, it just remains at the initial value, any ideas. Any ideas of what I need to do to update the ProjectSiteName text box on the child name, it worked fine when it was just me.projectsitename.text, do I need to refresh the child form or something. thanx in advance Robert Tag: No exceptions in sqldataadapter Tag: 64394
  - 18
    - Excel Transfert When i try to import excel data with Oledb. The column who have number value and blank value is not im my dataset. For the importation i do OleDbDataAdapter oCmd=new OleDbDataAdapter("SELECT * FROM [sheet1$]",strCn); DataSet oDS=new DataSet(); try { oCmd.Fil(oDS,"ExcelInfo"); dataGrid2.DataSource=oDS.Tables[0]; } Could give me an answer. What can i do in my code for having this column. Lukas . Tag: No exceptions in sqldataadapter Tag: 64393
  - 19
    - Help? Relational data... Hi all, I wonder if anyone can help? I have a need to display some data on my web page (the results of a search) for links. Here's the thing: Each link can belong to one or more category (yes, I have a many-to-many table). When the links are retrieved, I also want to retrieve the categories the link is found in. Let's say link A appears in categories X, Y, and Z, and a keyword search brings back link A - due to the way the query is structured (inner join), link A is retrieved three times due to it's presence in categories X, Y, and Z. The question is: How do I retrieve the categories (of which there may be 1 or more for each link) along with the link? Or can't I? I was thinking of multiple selects in a stored procedure (so they could be put into separate dataset tables), but that would need some correlation between the links found in the first query (i.e. the one that finds the links) and the second (the one that retrieves the categories for the links that have been found). Alternatively, I could just cache the category table, along with the LinkToCategory table and as I'm writing each entry to the page, look up the corresponding category then - if I'm using a DataRepeater, I think I can use the Item_Created event... However, I don't really want to do that, I'd rather do it at the database level. Any thoughts? Kind regards, Mike K. Tag: No exceptions in sqldataadapter Tag: 64386
  - 20
    - Joinview After switching from DBF to MySql, my Joinview of Microsoft doesn't work properly. I tried to figure it out, but still haven't found any solution. I looked at the relationships, the primary, the type of columns(it's a charvar).. Does anyone have the experience with Joinview and Mysql ? Richard Loupatty MIO Develoment bv Tag: No exceptions in sqldataadapter Tag: 64384
  - 21
    - Trouble with DataRelation on self ref table I am trying to setup the following DataRelation (C#) on a self referencing table. DataRelation dr = ds.Relations.Add("MenuItemHierarchy", ds.Tables["MenuItems"].Columns["UID"], ds.Tables["MenuItems"].Columns["ParentID"]); The trouble is the ParentID was setup in the database to use int 0 where there should be Nulls to use this relationship. Is it possible to change the 0's to Null before I try and setup the relationship? That is without adjusting the database itself. Regards, Kim Tag: No exceptions in sqldataadapter Tag: 64375
  - 22
    - Accessing RETURN values from a Stored Procedure (meant to post this SQL ADO message here instead of the C# Group) Using C#, I can access results returned from a stored procedure call OK, my question is how do you access the value from a RETURN statement in a stored procedure ? eg. In the Example below - how can I check on the Value -1000 (Customer not found) ? @CID = customer id . . . . -- Does Customer Exist ? IF NOT EXISTS (SELECT 1 FROM Customers (NOLOCK) WHERE CID = @CID) RETURN -1000 - Customer Exists, pass back values SELECT FirstName, LastName FROM Customers WHERE CID = @CID RETURN 0 thanks, - peteZ Tag: No exceptions in sqldataadapter Tag: 64373
  - 23
    - BUG: Dataset Returned From A XML WebService Containing Error Data Caused Exeption To Be Thrown In A Window Form Application Hi, I'm working on a project which includes XML WebServices and Windows Form application. The Windows Form application will call the XML WebServices to retrieve data from database. The data will be returned as DataSet. Now, here's the problem. On .NET Framework 1.1, if any rows in the dataset returned contain errors (marked by calling the SetColumnError() method or setting the RowError property of the DataRow), I get the following error message in the Windows Form application, "There is an error in XML doument (x,xxxxxxx)" If I forced the Windows Form application to run on .NET Framework 1.0, everything works fine. Here's the partial code for the WebService project Code: <WebMethod()> _ Public Function RetrieveDataSet() As DataSet Dim ds As New DataSet Dim dt As New DataTable Dim row As DataRow Dim i As Integer dt.TableName = "TestTable" dt.Columns.Add("TestColumn1", GetType(String)) dt.Columns.Add("TestColumn2", GetType(Integer)) ds.DataSetName = "TestDataSet" ds.Tables.Add(dt) For i = 0 To 10 row = dt.NewRow row("TestColumn1") = "This is row " & i row("TestColumn2") = i dt.Rows.Add(row) ' The following code trigger the error after the DataSet ' is returned to the calling Window Form application row.SetColumnError("TestColumn1", "Error message here") Next Return ds End Function For the Windows Form application, you need to insert a datagrid control (assumed as datagrid1). It will look something like this, Code: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim ws As localhost.Service1 Dim ds As DataSet Try ws = New localhost.Service1 ds = ws.RetrieveDataSet Me.DataGrid1.SetDataBinding(ds.Tables(0), "") Catch ex As Exception MsgBox(ex.Message) Finally If (Not (ws Is Nothing)) Then ws.Dispose() End If End Try End Sub I really hope someone could help me out with this one. Thanks in advance. ps: Please, before anyone reply to state that I did not choose the appropriate groups when making this post a crossposts post, please know that I'm currently in blind on what is causing this error. Is it the WebService? or is it the ADO .Net? or is it Windows Form application? or is it VB .Net? Well, it has something to do with WebService as it only happens to the DataSet returned by WebService. It also has something to do with ADO .Net as I'm using DataSet. And it definitely has something to do with Windows Form application as if I force the Windows Form application project to run on .Net Framework 1.0, everything works fine. Tag: No exceptions in sqldataadapter Tag: 64370
  - 24
    - Connect to Sybase Hi! I have to Connect to a Sybase Adaptive Server Anywhere 7.03 database with ADO.NET. I have connected in my app to a access-db with oledb. Now, I have to connect to a second db (Sybase). Now, I have installed the sybase asa-server. But the problem is: what does I have to write as connectionString? Now, can anyone give me a tipp, how does I can do that? Thanks very much thomas Tag: No exceptions in sqldataadapter Tag: 64365
  - 25
    - Reading Excel files with Jet OLE DB Provider I have some ADO.NET code that uses the Jet OLE DB Provider to read Excel files. The reading of the files works okay. However, I get strange behavious when I have Excel running and run the program that reads the file that Excel currently has loaded. Excel will pop-up messages such as "File is now available for read-write." In other cases, if I use Excel to modify the file and save it, then run my program, I get the old data, not the most recent data. I think maybe I have to tell the OLE DB provider to open the file in read-only mode, but I don't know how to do that. Thanks. - Kevin Tag: No exceptions in sqldataadapter Tag: 64363

hi,
I am trying to fill a dataset from an stored procedure in SQL Server
2000.
The code is:
string strSalida="";
SqlDataAdapter daAdapter = new SqlDataAdapter();
SqlCommand cmd;
try
{
cmd = new SqlCommand(strConParametros, myConnection );
daAdapter.SelectCommand = cmd;
daAdapter.Fill(dsResultado);
catch (Exception e)
{
strSalida = "lanzaConVuelta 1:" + e.Message;
}

The stored procedure return an error (invalid type conversion) but the
sqldataadapter don´t catch the error, no exception is detected in the
program.
How can I catch the error form the stored procedure?
Is a bug in the sqldataadapter?

Thanks
Alvaro

Top