SQLDataReader and Columns

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
    - Execute File SQL in AdoNET VB Hello, I have a file .SQL Containing a Script to Create Tables and Stored Procedure... Example : if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP_ADVANCED_SEARCH]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[SP_ADVANCED_SEARCH] GO ....... SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TABLE [dbo].[TBLTEST] Etc Etc.... It is possible Execute Then Scirpt With AdoNet ... Tag: SQLDataReader and Columns Tag: 103768
  - 2
    - Passing OracleDateTime.null.value to store procedure??? using Data access application block for oracle, I try to pass a null value to the OracleDateTime to the store procedure. but I got an exception saying "this value si null", what am I missing here? shouldn't I be able to pass null parameters? Kevin Tag: SQLDataReader and Columns Tag: 103766
  - 3
    - Databinding in c# - Important Hello All the samples I found are based on datagrid for the child table. What if I don't want the child records to be displayed in a datagrid, but in their own data bound controls like "text box, combo & list boxes). And I want to provide a second level of navigation buttons to traverse those child records in the child table. I'm sure this is possible, but I can't seem to find any sample on it. Please let me know if you can throw any light on it. Thank You Tag: SQLDataReader and Columns Tag: 103761
  - 4
    - edit memory DataTable Hi, I created simple dataTable (one field numeric, one string). Then I prepared dataConnector and put DataGridView on the form. In datagrid I can edit now numeric field but string field after post is clear (NULL value). Can anyone help? Thanks Tag: SQLDataReader and Columns Tag: 103752
  - 5
    - edit string field in DataGridView Hi, I created simple DataTable (memory table) object with two fields -numeric Id -string Name then I configure dataConnection and put on the form DataGridView. I bind fields from table to columns and now I can edit numeric column but when I try edit string column then it is after post event clear (NULL value). Why? Thanks Tag: SQLDataReader and Columns Tag: 103751
  - 6
    - DataRow to XML Hello, I am creating a datarow (new or existing) in my data-tier and passing it to my business tier where it is filled with data and then passed back to data-tier to be inserted into the table. I need to keep original and updated versions of the datarow in xml format. Just need the datarow in xml format. So basically I need two strings - string1 containing data from initial state of datarow and string2 containing data from updated state of datarow. I think that xml read/write can only be done via datasets and not via datarow. Can anyone provide any pointers? Thanks Tag: SQLDataReader and Columns Tag: 103750
  - 7
    - Lock Table In a SQL Server 2000 Database I have a Table which is shared by many users. I have a VB.NET Procedure which contains many calls to Stored Procedures and ADO.Net Commands to clear and update this shared table. What I would like to do at the start of this lengthly procedure is to place an exclusive lock on the table until the whole procedure has finished running all its separate update statements. Then I will unlock it. If another user runs the same procedure while the table is locked by the first then I would like a message displayed to say that "the table is in use, Please try again later." Is there an easy way to achieve all of this? It would be difficult to put all the update commands in the same transaction as different connections are used. Tag: SQLDataReader and Columns Tag: 103741
  - 8
    - Current record of datatable in dataset Hi I have a datatable which I have linked to a combo control, via the datasource property of the combo control. I have also set the displaymember property of the combo, to ensure that my description is shown in the combo. However, I want to have another value of the same row of the datatable (as selected in the combo), displayed in a text box. ie. so that when I change the value in the combo, a text box displays a value from another field in the same datarow. Can anyone offer any tips, or code samples? Thanks Tag: SQLDataReader and Columns Tag: 103740
  - 9
    - how to prepare patch Sir, In a form i have kept 2 textboxes(a,b) and a button(add). which supports only of integer values i have written. after entering the values in the textboxes and after clicking the add button result is displayed on a message box. (this functionality supports only for ineteger values. after this i have given the exe of this program to the client. then client asks me to " if i give decimal values it must work ". now how to prepare the patch for the program to add decimal values also and how to update the exe which i have prepared. Tag: SQLDataReader and Columns Tag: 103327
  - 10
    - Cant connect to SQL Server 2000 Developer edition Hi, I have been trying to connect SQL Server2000 developer edition using the following string. SqlConnection conn = new SqlConnection("server=localhost;database=pubs;uid=sa;pwd="); I dont know where i am going wrong. SQL Server Service Manager shows the following: Server : Hemant Services : SQL Server Running \\Hemant -MSSQLServer Even tried this command and numerous other combination but none seems to work. SqlConnection conn = new SqlConnection("server=Hemant;database=pubs;uid=sa;pwd="); I want to establish connection using SqlConnection to the database pubs using C# in .NET IDE. Help me out. Where am i getting it wrong?? If someone else has answered this question then provide me the link. Tag: SQLDataReader and Columns Tag: 103130
  - 11
    - duplicate ids after insert Hi, I'm trying to create an archiving script, using the folowing query for all database tables insert into table2 select * from table1 (table1, table2 are 2 tables having exactly the same definition) The rpoblem is that the rows are,'t deleted from the table TABLE2, so the next time the user runs the script he'll find some rows already existing in TABLE2, so he'll have an error. How can I handle this without to know exacly what are the IDs or the structure, juste to say "if the row (the unique key) exists skip it, but continue with the other rows" Thanks. Tag: SQLDataReader and Columns Tag: 103126
  - 12
    - Timberline (Pervasive) ODBC Access Is anyone else out here working with Timberline version 7.x,8.x or 9.x and ODBC and .NET? If so any advice to offer? I am working with a number of older VB 6 applications that interface (mostly just read) Timberline data stored in a Pervasive SQL database that I am porting to VB.NET. Experimentation has shown me that I apparently need to use Timberlines own driver, I have had limited success with the Pervasive native drivers. I am trying to stay in an all managed solution so I have been using the System.Data.ODBC namespace but that appears to cripple my access to things like Schema info etc. Any suggestions or pointers to online resources would be appreciated. I am already aware of Event!'s web site. Thanks in advance. Bob Porter Tag: SQLDataReader and Columns Tag: 103125
  - 13
    - ExecuteReader requires an open and available Connection. The connection's current state is Closed. (Type your message here) -------------------------------- From: renu Friends, when I am trying to create a login page and connecting to the sqlserver database I am getting the following error ExecuteReader requires an open and available Connection. The connection's current state is Closed. and mycode is Dim strconn As String Dim strsql As String Dim command As SqlCommand Dim i As Integer Try strconn = "server =(local);trusted_connection=yes;database=consultants;" Response.Write("connection ok") Dim conn As New SqlConnection(strconn) strsql = "select count(*) from consul_login where uname='" & txtUname.Text & "'and pword='" & txtPassword.Text & "'" command = New SqlCommand(strsql, conn) conn.Open() Catch ex As Exception Response.Write(ex.Message) End Try i = command.ExecuteScalar() If i <> 1 Then Response.Redirect("e:\dotnet\authenticationdenied.aspx") Else Response.Redirect("e:\dotnet\timesheet.aspx") Response.Redirect("timesheet?n1" & txtUname.Text) End If can anybody help me out? thanks renu ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>gev9cu2MuEiLCsHn9s10qw==</Id> Tag: SQLDataReader and Columns Tag: 103113
  - 14
    - concurrency violation I have a dataset with a data adapter=2E The text fields are bound= to text boxes=2E When I use sqlprofiler to view the stored= procedure executed and the data, the fields of both the= @newComment and @orginalComment have both the same value=2E The= value in both fields is the same value entered into the textbox=2E= I know that the object is supposed to copy the orginal values= retrieved from the database, but I have no idea why the changes= are occuring to the @original=2E this=2EBindingContext[dsCollectionAgency1,= "Collection_Agency_Sel"]=2EEndCurrentEdit(); try =09{ =09daCollectionAgency=2EUpdate(dsCollectionAgency1,= "Collection_Agency_Sel"); =09} catch (Exception e) =09{ =09MessageBox=2EShow( Convert=2EToString(e=2EMessage), "Error Saving= Agency Information", MessageBoxButtons=2EOK,= MessageBoxIcon=2EExclamation); =09}=09=09=09 Does anyone have any idea why this occuring? From: Kevin Cabral ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>2NNKo4s1+06Jk0cWyZJuCw=3D=3D</Id> Tag: SQLDataReader and Columns Tag: 103112
  - 15
    - Fire query on DataSet DataSet is supposed to be an in-memory database=2E So is it= possible to fire a query on it=2E I want to fire a "Select" query= (with alises in it) and also a "Transform" (Crosstab) query=2E In= the current scenario I am putting things in an Access table but= for performance reasons want to deal with in-memory contents=2E Thanks in advance=2E -------------------------------- From: Arun Gupta ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>sTSX/kubC0qPi2iCiclPTg=3D=3D</Id> Tag: SQLDataReader and Columns Tag: 103111
  - 16
    - Can't get record to insert into Access I have a windows service that will insert records into an Access= database=2E Or at least that's the idea=2E The insert isn't= happening, but the code runs without raising any errors=2E When I= run the generated sql statement from a query window in Access,= the record inserts just fine=2E Can anyone help me? string sqlInsert =3D "INSERT INTO checks( PageNo, Template,= OriginFile, TargetFile, MICR, Account, Routing, CheckNumber,= CheckDate, CheckAmount, ScanBatchNum ) VALUES( '{0}', '{1}',= '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}'= )"; StringBuilder sb =3D new StringBuilder(); using( OleDbConnection cn =3D new OleDbConnection( m_ConnString )= ) { =09cn=2EOpen(); =09using( OleDbCommand cmd =3D new OleDbCommand( "", cn ) ) =09{ =09=09foreach( ChecksDS=2EChecksRow row in checkRecords ) =09=09{ =09=09=09sb=2EAppendFormat( sqlInsert, row=2EPageNo, row=2ETemplate,= row=2EOriginFile, row=2ETargetFile, row=2EMICR, row=2EAccount,= row=2ERouting, row=2ECheckNum, row=2ECheckDate, row=2ECheckAmount,= row=2EScanBatchNum ); =09=09=09cmd=2ECommandText =3D sb=2EToString(); =09=09=09cmd=2EExecuteNonQuery(); =09=09=09sb=2ERemove( 0, sb=2ELength ); =09=09} =09} =09cn=2EClose(); } Here's a generated sql statement=2E INSERT INTO checks( PageNo, Template, OriginFile, TargetFile,= MICR, Account, Routing, CheckNumber, CheckDate, CheckAmount,= ScanBatchNum ) VALUES( '3', 'Check', 'C:\Program= Files\FormStorm\urm\Queues\0120040901160314=2Etif', 'C:\Program= Files\FormStorm\URM\ImageExp\090920049091443253=2Etif',= 'A021204005A 0001538C 0404', '021204005', '0001538', '0404',= '', '20=2E00', '09092004909144325' ); I've tried with and without the ending semi-colon=2E What am I= missing? Thanks -------------------------------- From: Drew Burlingame ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>W3E/7KDtXkaxBUqfx/Y9Jg=3D=3D</Id> Tag: SQLDataReader and Columns Tag: 103110
  - 17
    - .Net master-detail interface I can build an interface for a master-detail database in about 5 minutes with vb6 using the data environment 1.0 reference. Does .Net have anything similar or must I define a connection, datadapters and the relational schema by hand? Tag: SQLDataReader and Columns Tag: 103109
  - 18
    - ADOMD.NET Hi, Does using Ado Md.Net require anything to be installed on the Analysis Services server (XMLA or as such) ? Thanks Tag: SQLDataReader and Columns Tag: 103108
  - 19
    - .Net Data Provider error help I've used the Microsoft .Net Data Provider for Oracle and also the Oracle .Net Data Provider . I'm issuing a simple select statement which would return a list of dates formatted as such 'MM/DD/YYYY'. The table is storing the dates in a field of date data type in the format of M/D/YYYY. There is no time portion on any of the dates, the data was imported from SQL Server. Here is the section of my statement which formats the date ' TO_CHAR(tblarInvoiceHeader.ARInvoiceDate,'MM/DD/YYYY')', I get the following error: ORA-01834: not a valid month I can issue the statement via SQL + and TOAD, and not generate the error, it has to be the data provider. Does anyone have a clue as to what's going on and the panacea to this issue? Best Regards, Ted. Tag: SQLDataReader and Columns Tag: 103106
  - 20
    - newbee needs help with code Hi, I have the following VB.Net code snippet: While datareader3.Read ......... strsql = "select * from InspectionViolations where propTableID=" & datareader3.Item(4) & " AND inspIDCleared IS NULL" ConnViolPresent.Open() CmdViolPresent = New SqlCommand(strsql, ConnViolPresent) adapterViolPresent.SelectCommand = CmdViolPresent adapterViolPresent.Fill(dsViolPresent) ConnViolPresent.Close() If (dsViolPresent.Tables(0).Rows.Count() > 0) Then 'For some reason, dsViolPresent.Tables(0).Rows.Count() always return 3 As you can see the code inside a while loop will generate a different SQL statement and send it to SQL server. However no matter what the SQL statement is, the result dataset stays the same and it's the result generated by the first SQL statement. What do I have to do to make dsViolPresent refreshed in every loop ? TIA Tag: SQLDataReader and Columns Tag: 103102
  - 21
    - Help! Operation is not allowed in this context. Hi, I got an error message - Operation is not allowed in this context. It said the error comes from the line objRS.Close() Anyone have any ideas why? Thanks a lot. Here is part of the code: Dim strConnectionString As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=c:\test.mdb" objConn = New ADODB.Connection objConn.Open(strConnectionString) objRS = New ADODB.Recordset objRS.ActiveConnection = oCn objRS.LockType = ADODB.LockTypeEnum.adLockOptimistic objRS.CursorType = ADODB.CursorTypeEnum.adOpenDynamic objRS.Open("SELECT * FROM Customers WHERE CustomerID = " & Session("CustomerID"), objConn) ' DO SOMETHING HERE' objRS.Close() *-----------------------* Posted at: www.GroupSrv.com *-----------------------* Tag: SQLDataReader and Columns Tag: 103099
  - 22
    - convert 2 XML files into a dataset Hi, I now have 2 xml files with same structure first.xml <dataset1> <table1> <col1>aaa</col1> <col2>bbb</col2> </table> ..... </dataset1> 2nd.xml <dataset1> <table1> <col1>ccc</col1> <col2>ddd</col2> </table> ..... </dataset1> how can I merge these 2 set of data into a single dataset? thanks Tag: SQLDataReader and Columns Tag: 103098
  - 23
    - No error information available: E_FAIL(0x80004005) SQL Server 2000 We have an e-commerce app built with ASP.NET, VB.NET and uses a SQL Server 2000 database. The app sustains moderate load in this particular environment (10-50 concurrent users). Note we also have this same codebase running in several other similar environments and everything works fine. For this one sql server 2000/windows 2003 server environment we get this error after the app has been up for a while: No error information available: E_FAIL(0x80004005). The SQL Server has to be restarted for the error to go away. My guess is there is some sort of sql server configuration or network problem because the app works fine in other similar environments. Any ideas on how to correct this? Thanks so much, Jenna Tag: SQLDataReader and Columns Tag: 103097
  - 24
    - SqlDataAdapter memory leak? I've been trying to track down a memory leak in a project and have been running around in circles for the past week or so. I've been using this as an opportunity to evaluate Compuware's devPartner, but unfortunately it seems to be doing more to confuse me than to help me. My problem can be illustrated by the block of code attached to KB article 318263 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q318263). The article gives this code as an example of a perceived, but not real, memory leak. However, I think there is a real memory leak within the SqlDataAdapter, unrelated to the perceived leaking that the article talks about. DataSet ds; SqlConnection cn = new SqlConnection("data source=localhost;initial catalog=Northwind;user id=USER;password=PASSWORD"); cn.Open(); SqlDataAdapter da = new SqlDataAdapter("Select * from Employees", cn); ds = new DataSet(); for (int i = 0; i < 1000; i++) { da.Fill(ds, "Table" + i.ToString()); } cn.Close(); The leak is not major -- devPartner only reports ~50k being leaked, and the entirety of it is reported as leaked by the da.Fill(...) method call. But, 50k in this snippet could (and seems to have been within my project) be amplified when adding larger tables to a DataSet. Has anyone looked into this before? Is this a real issue with the SqlDataAdapter, or am I hunting a snipe? Thanks for reading, -Matt Tag: SQLDataReader and Columns Tag: 103087
  - 25
    - Questions on Databinding Hello I've few questions regarding ADO & C#: 1) Is it possible to view tata from multiple tables in the Datagrid control ? Most of the examples I see are only for 1 table. 2) In Comboboxes, can we display multiple fields ? For example in a Form of customers, we have a combo box to select the customer you want to change, so in that combo box, when they drop down, can we have it to display "First Name, Last Name, Customer ID, Customer type" but its databound field is "Customer ID". I used to be able to do that in Access, C# is supposed to be powerful but how do I do it ? 3) If you copy an access database into MSDE or SQL and it has autogenerate fields, both in SQL & Access, how do we addresss that efficiently ? Any insight into the above questions would be helpful & very appreciated. Thank You Tag: SQLDataReader and Columns Tag: 103085
- Next
  - 1
    - Retrieving @@IDENTITY value from Access Database give always 0 !!!! I need to retrieve automunber ID from source access table after inserting new row... I tried to do this by this way: gRUPATableAdapter.Update(dataSetGrafik.GRUPA); oleDbConnectionForID.Open(); OleDbConnection oleDbConnectionForID = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Grafik\\GrafikApplication\\Import\\baza Access\\grafikStruktura.mdb;Persist Security Info=False"); OleDbCommand command = new OleDbCommand("SELECT @@IDENTITY", oleDbConnectionForID); IDnewAddedGRUPARow = (int)command.ExecuteScalar(); // why it always give 0 ???? oleDbConnectionForID.Close(); But it always gives me nothing... please, help me.. Previously i tried tho use standard solution my attending RowUpdated event (tutorial from MSDN website). This approach unfortunately cases that compliter gives my warning: Warning 5 The event 'GrafikApplication.GRUPATableAdapter.RowUpdated' is never used c:\Grafik\GrafikApplication\DataSetGrafik2.cs 71 67 I use VS C# Express - and it generics a lot of codes, declaration of events, like rowchanged, itd.. but I cannnot find where I can correctly attend RowUpdated event ? Is anyone who can help me ?? Tag: SQLDataReader and Columns Tag: 103084
  - 2
    - Warning: The event 'Application.SAMPLETableAdapter.RowUpdated' is never used - HELP WHY ??? In my applicaton I attend the RowUpdated event for retrieving the autonumber IDENTITY from Access Database (no stored procedure support) of new inserted row from one of my tables (SAMPLE). But event is not hanging properly, or not reqognized or doesn't fires, because I always receive 0 from database. I don't know what's wrong ??? I did accordantly to the microsoft's tutorial: 1) I declare: public event OleDbRowUpdatedEventHandler RowUpdated; in the body of definition SAMPLETABLEAdapter (thiss class was automaticalyy created by VS C# and is inherted from OleDbDataAdapter class - object of this class is the gSampleTableAdapter for SAMPLE table, in which RowUpdated event I want to detect, when I insert new row) 2) I Placed this line of code: gSampleTableAdapter.RowUpdated += new OleDbRowUpdatedEventHandler(OnRowUpdated); and below mentioned line i placed the code which can invoke this event: gSampleTableAdapter.Update(dataSetSample.SAMPLE); 3) and finally I define OnRowUpdated function: protected static void OnRowUpdated(object sender, OleDbRowUpdatedEventArgs args) { OleDbCommand command = new OleDbCommand("SELECT @@IDENTITY", oleDbConnectionDlaID); if (args.StatementType == StatementType.Update) { IDnewAddedRow = (int)command.ExecuteScalar(); MessageBox.Show("Database retrieve ID:" + IDnewAddedRow); args.Row["ID_SAMPLE"] = IDnewAddedRow; } } Everything compliles OK, except this one Warning: Warning: The event 'Application.SAMPLETableAdapter.RowUpdated' is never used what it's mean ??? When I checked the sample table in the access, I see, that the new rows are propery added, but is something wrong with this mechenism... Where is the case !! Please help me, because i'm starting to get nuts..... Tag: SQLDataReader and Columns Tag: 103083
  - 3
    - Mapping single table to many tables Hallo people, is it possible to map the columns return by a sql select command to a DataAdapter to different tables in ADO.NET? I tried the tablemappings collection but got the following error message: "The DataTableMapping.SourceTable is required to be unique, 'Table' already exists in the collection." with following code: DataAdapter.TableMappings.AddRange (new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "FirstTable", new System.Data.Common.DataColumnMapping[] {new System.Data.Common.DataColumnMapping bla bla...}), new System.Data.Common.DataTableMapping("Table", "SecondTable", new System.Data.Common.DataColumnMapping[] {new System.Data.Common.DataColumnMapping bla bla...}), new System.Data.Common.DataTableMapping("Table", "ThirdTable" bla bla...)}) It would seem logical that ADO.NET would support this. Any advice is more than welcome. Regards, Dimitris Tziouris Tag: SQLDataReader and Columns Tag: 103081
  - 4
    - Excel Import using ADO.net hi! I've managed to pull some data from an excel spreadsheet using ADO.net Rather simple. The Only problem is that whenever I put that data into dataGrid, it adds these F1, F2 words to the header whenever a null is retrived from the excel doc. In this example, all items are null, but that won't always be the case. I just want to get rid of the F1, F2 items that are automatically added. I took a screen shot, take a look: http://thekcins.com/caseyTest/Fhead.jpg Thanks for the Help! Casey Tag: SQLDataReader and Columns Tag: 103068
  - 5
    - Convert a DataTable to a Strongly Typed DataTable. Hi, The following code throws me an Error, i use a method to bring a DataTable object and i want to asigne it to a Strongly Typed DataTable, but VB doesn't allow me. How can i do this right? And if it couldn't be done, then wich would be an equivalent solution. Thank you very much. 'FoldersDataTable: Inherits from DataTable. Dim Data As New FoldersDataTable 'BringDataTable: Retrives a DataTable object Data = CType(BringDataTable("Select * From Folders"), FoldersDataTable) 'Error: 'InvalidCastExeption' Tag: SQLDataReader and Columns Tag: 103067
  - 6
    - Datareader to a DataGrid on a WINFORM Hi All, Is there really a way of binding a DataReader to a Datagrid in a Windows Forms Application?.I know that in ASP.NET ,you just simply set the datasource and call DataBind() method. Thanks Tag: SQLDataReader and Columns Tag: 103049
  - 7
    - ReadXML method Hi All, I have a xml file which is in a string variable(for example, sXML="<e1 at1=1 at2=2>aaa</e1>..."), how can I read it into dataset? Thanks Tag: SQLDataReader and Columns Tag: 103048
  - 8
    - Filtering columns from datareader Can I filter some columns out of a datareader in the code-behind? Or can I convert a dataset into datareader? Tag: SQLDataReader and Columns Tag: 103047
  - 9
    - using mySQL Most of my life as a developer has been spent working in Microsoft shops, but recently I have been asked to explore a little into the open source world, PHP and mySQL. Can anybody recommend tools for mySQL, that allow for some GUI administration of the DB, such as Enterprise Mgr does for SQL Server? Also, are there any good IDEs available for PHP? Thanks! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: SQLDataReader and Columns Tag: 103046
  - 10
    - Oracle Providers for ADO.NET 2 We're starting a big project now (using 1.1) and I want to use the best provider option with an eye towards ADO.NET 2.0. I have been using the Microsoft Oracle Provider, but I heard that Oracle's ODP is better for using the advanced database features. I don't need those features right now, but I don't know about my future needs. I also read that Oracle is working with Microsoft on having better Oracle support in 2.0. I understand the Server Explorer will be more Oracle-friendly, for example. Does this mean the Microsoft Oracle provider will also be enhanced? Will Oracle's ODP be enhanced for 2.0 also, or is that being dropped in favor of a single provider that will be a joint effort from the 2 companies? My main concern is that we pick the right choice now so we won't have to make major code changes later. Thanks! Eric Tag: SQLDataReader and Columns Tag: 103044
  - 11
    - converting dataset to excel .. please give me tips or code to convert a dataset to excel sheet Tag: SQLDataReader and Columns Tag: 103039
  - 12
    - csv header captions trimmed [urgent][?!] Just a while ago I've tried to solve an issue with reading CSV files and stepped into an issue where the header text is stripped if longer than 64 chars! this is unexpected. what's interesting is that Excel read this CSV file correctly. can I really write my own CSV reading routine to solve that issue or can anything easier be done to fix that? this constraint is new to me, I've never found any documents saying that header data cannot exceed the legth of 64 chars. thanks in advance Wiktor Zychla details: two drivers tested (JET.4.0 via OleDbc and Microsoft Text Driver via Odbc). both trim the header caption to the length of 64 chars. code: using System; using System.Data; using System.Data.OleDb; using System.Data.Odbc; using System.IO; class T { public static void Main() { using ( IDbConnection conn = new OdbcConnection() ) { try { string fileName = "c:\\003\\test.csv"; //conn.ConnectionString = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"{0}\";Extended Properties=\"text;HDR=Yes;FMT=Delimited\"", Path.GetDirectoryName(fileName) ); conn.ConnectionString = String.Format( "Driver={{Microsoft Text Driver (*.txt; *.csv)}};DBQ={0};Extensions=asc,csv,tab,txt;HDR=YES;Persist Security Info=False", Path.GetDirectoryName(fileName) ); conn.Open(); // inicjuj dataset IDataAdapter da = new OdbcDataAdapter( string.Format( "SELECT * FROM [{0}]", Path.GetFileName(fileName) ), (OdbcConnection)conn ); DataSet ds = new DataSet(); da.Fill( ds ); DataTable dt = ds.Tables[0]; Console.WriteLine( dt.Columns[0].Caption ); } catch( Exception ex ) { Console.WriteLine( ex.Message ); } } } } data [test.csv]: Z123456789Z123456789Z123456789Z123456789Z123456789Z123456789Z123456789Z123456789 1 Tag: SQLDataReader and Columns Tag: 103027
  - 13
    - Self Referencing parent child relation brick wall on dataadapter.update Anyone have experience with a similar scenario as the following? I have to believe someone has done this. I am trying to use a dataadapter.update method to create new records in one datatable with records from another. Quick background: Table1 has template records that need to be created in Table2. I say template records only in context of the application this is for, each record represents a project task for a particular customer that will always be a needed task for projects dealing with that customer, thus, template tasks. Anyways, each record from the template Table1 has an identity column["mid"] and a parent column["parentID"] which creates the hiearchical relationship of these tasks (to understand which are subtasks of others through this parent child relationship. The top level tasks' parentID is set to '0'. When I fill my dataset with the appropriate records, I then loop thru them and make a few slight adjustments to some of the other datacolumns to identify them more to the current new project at hand. Now I want to do dataadapter.update to put these records into the actual task Table2. Now this works great, the new tasks are inserted and the identity columns are obviously udpated to the Table2's latest autonumbers. The problem i have run into is the parentID field. In the template Table1, they reference the correct parent record, but once in the new Table2, the parentID column data is still the static data that it was in the template Table1. I am trying to find a way to keep this relation from Table1 into Table2 so that the new records in Table2's parentIDs reference the new autonumber fields that keep them tied to the appropriate parent tasks. I've read much about creating DataRelations, Constraints but I just can't get the formula correct, or maybe its not even the right way to do this. I'm looking for any ideas or experiences that would lead me to the answer here, the solution to this problem that has tied me up for a good 8 hours now. Thanks for any help jon Tag: SQLDataReader and Columns Tag: 103016
  - 14
    - SQL Connection Lifetime Hi, I am asking a generic question about SQL server (or any type server communication for that matter) and how one would keep the connection open for the life time of the application, or should one close the connection for each request (or set of related requests)? Does SharePoint open / close the connection to the database for every request? Does Exchange open / close the connection to the database for every request? BTW I define a request as more like a unit of work which could be made up of multiple sql statements (in this instance. A unit of work is to be run in the minimal amount of time possible. I personally think that keeping a connection to a server open when an application is IDLE is definately not on. Connection / Disconneciton also helps free resources, and in the event of a network failure (or dropped packets for that matter) then recovery is much 'cleaner' (e.g. in SQL server i know of an application that connects when the user logs on and closes when the user logs off and if a VPN link drops packets the application come up with communication link failure.) I am wondering on what is the best way to go with future projects that I might work on. Regards, Adrian. Tag: SQLDataReader and Columns Tag: 103015
  - 15
    - ADODB Reference Error on vb6 conversion Hello, OK - I'm trying to make the big jump from vb6 to vb.net. I took one of my vb6 programs and ran it through the converter and I'm getting some ADO errors that indicate a reference is required. I have a reference set to the 2.8 library. Here's some examples of the errors: Reference required to assembly 'ADODB' containing the type 'ADODB.CursorLocationEnum'. Add one to your project. Reference required to assembly 'ADODB' containing the type 'ADODB.LockTypeEnum'. Add one to your project. Reference required to assembly 'ADODB' containing the type 'ADODB.CommandTypeEnum'. Add one to your project. What reference do I need to add? I put together a test program with an ado recordset, referencing the 2.8 library and it worked fine. Under references on the form it is properly showing 2.8 as being referenced. Of course the form design won't come up because the error line is inside the generated code "Initialize Component"! TIA, Vic Tag: SQLDataReader and Columns Tag: 103011
  - 16
    - Template Column DataBinding Greets all, I've been doing some .NET web apps for a little while now and I _LOVE_ template columns within datagrids since I can make things really flexible for which content I use and which data I want to display. Typically when I setup a basic datagrid, I'll use the following structure for my columns on the aspx side: <asp:TemplateColumn HeaderText="Title"> <HeaderStyle Width="125px"></HeaderStyle> <ItemTemplate> <%# Container.DataItem("Title") %> </ItemTemplate> <EditItemTemplate> <asp:TextBox id="txtEditTitle" runat="server" MaxLength="15" Columns="16" Text='<%# Container.DataItem("Title") %>'> </asp:TextBox> </EditItemTemplate> </asp:TemplateColumn> That way on my codebehind page. All I have to do is set the data source and call the databind method. By doing it this way, I can also use a template column and create all the custom ItemCommands I want, all I have to do is add a CommandName and CommandArgument to my datagrid and have the events processed in a single method. Similarly, I can do some "fancy" things with RadioButtons and image displays by late binding methods on the aspx side as well. For instance, I can display an e-mail icon through the following code: <asp:ImageButton id="btnSendMessage" runat="server" Visible='<%# GetEmailVisibility(Container.DataItem("MemberID")) %>' ImageUrl="images/MessageButton.gif" CommandName="SendMessage" CommandArgument='<%# Container.DataItem("MemberID") %>'> </asp:ImageButton> My code behind page compares the Member's ID to the data table to see if they have an e-mail address on record. If so, then the visibility is set to "True" through the string it returns. Otherwise it is set to "False" to hide it. I give you all these to ask this question. Is this the best practice for databinding with TemplateColumns, or for databinding in general? I know the typical method is to separate as much user interface from server side code as possible through the .vb file, but sometimes processing the e.Item.FindControl...convert to this web control, get this parameter seems to be more hassle than its worth. What do you guys think? I really want to get this stuff right and to have it line up the way the "best practice" intends. Thanks for bearing with this lengthy post in the first place and for any feedback you can provide! Tag: SQLDataReader and Columns Tag: 103010
  - 17
    - Crystal Reports Login Problem...different I think A dollar to anyone with a working solution... Hello everyone, there are 101+ posts regarding the login exception but I think mine may be different as I have read through all the posts and couldn't find a single reference to my issue. Setup: I've built a class that exposes a public method which returns a datatable. I have created a report and set up it's data connection to point to this compiled class. The report runs great and without issue. However, I would like to access this report from a web page and so using the ReportDocument I load the report and try to export it I get the following error. I am trying to build Reports classes that I can use for all my reports and have the reports bind to the .dll. Like I said, the report generates properly when I run just the report, however, when I try to call the report from a webpage I get this issue. I'm confused because the .dll should be managing all the login credentials and simply send back a datatable. I don't understand why Crystal is trying to play with the login. Any thoughts? It seems like everyone else is adding the report to the project. I don't want to do that. I don't want the reports to be part of the project at all. Thanks. CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed. Details: mscorlib : File or assembly name AUS.Common.Reports.dll, or one of its dependencies, was not found. Failed to open a rowset. Error in File C:\WINNT\TEMP\{8188BFC4-0624-4BF0-9BFC-E7725B25BE0F}.rpt: Unable to connect: incorrect log on parameters. ---> System.Runtime.InteropServices.COMException (0x8004100F): Logon failed. Details: mscorlib : File or assembly name AUS.Common.Reports.dll, or one of its dependencies, was not found. Failed to open a rowset. Error in File C:\WINNT\TEMP\{8188BFC4-0624-4BF0-9BFC-E7725B25BE0F}.rpt: Unable to connect: incorrect log on parameters. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(Expor= tOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportReq= uestContext reqContext) --- End of inner exception stack trace --- at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(E= xception e) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportReq= uestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRe= questContext reqContext) at CrystalDecisions.CrystalReports.Engine.ReportDocument.y(ExportOptions 1) at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToHttpResponse(= ExportOptions options, HttpResponse response, Boolean asAttachment, String attachmentName) at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToHttpResponse(= ExportFormatType formatType, HttpResponse response, Boolean asAttachment, String attachmentName) at WebApplication3.WebForm1.test1() in c:\inetpub\wwwroot\webapplication3\webform1.aspx.cs:line 55 Tag: SQLDataReader and Columns Tag: 103009
  - 18
    - Select a range of Rows Anyone know if there is a way to select a range of rows. Much the same as using the Select Top 10 From .... Something Like Select Range 10 to 20 FROM .... ? I have searched and searched for something that will do this but can find anything Tag: SQLDataReader and Columns Tag: 103007
  - 19
    - Extend (Inherit) DataTable Hello, Here's my question: I'm preparing to develop some DTOs (Data Transfer Objects) to be used for transporting data from my data access layer to my business layer to my presentation layer. I've read mixed opinions on whether a DataSet/DataTable is a good fit for this. I'm used to building my DTOs/DTO collections by hand, but if DataTables will do the same thing, I might as well use the UI in VS.NET to build them instead. One thing I need to do is to extend DataTables. By that I mean I have one DataTable called Document. It has three properties: ID, MimeType and BinaryData. I also wish to have a DataTable called FormDocument. For now, this will have the same properties, but could have additional properties in the future related to FormDocuments, but not to Documents. So basically I would like to extend the Document DataTable in creating the FormDocument table rather than recreating an identical (or possibly similar) table. So in my happy DTO world I'd create a Document DTO and then extend it to create a FormDocument DTO. If I had a DocumentHandler object that could manipulate DocumentDTOs. Since FormDocumentDTO is an extension of DocumentDTO, I could pass the handler a DocumentDTO or a FormDocumentDTO and it could do things like merge, append, etc. I'd also have a FormDocumentHandler object that would manipulate FormDocumentDTOs solely. I could NOT pass it a DocumentDTO as it only accepts FormDocumentDTOs. It would perform tasks like filling form fields, etc. So, is there any way through the VS.NET UI or through the XSD coding that I can tell one DataTable to inherit from another? If not, it sounds like DataTables ARE NOT a good representation of a DTO and I'll be forced to create my own custom entities. Thanks, Leo Tag: SQLDataReader and Columns Tag: 103005
  - 20
    - Get certain no of records form a DataView? I am trying ot get a certain no of records from a DataView. I am looking ot do like a Top 15 in Sql, Is there a easy way to do this or should I loop till the count? Appreciate any help. -- Live one day at a time. Tag: SQLDataReader and Columns Tag: 103004
  - 21
    - Unspecified Error When Generating Dataset I am using Visual Studio.net framework 1.1 working on a Web Application. In my Solution\Project I have one sqlConnection and one sqlDataAdapter and one dataset. Using SQL Server 2000. Up until recently this project was fine. However, today I attempted to add another datadapter to the project and when I tried to generate the dataset I got an alert box with the message "Unspecified Error". At the time I was using the design wizard to configure the adapter to execute a simple stored procedure. Now I cannot do anything with the old adapter or the new one without getting the error message. All other Solutions\Projects that I work in still work fine. The problem project still compiles and runs without any issues what so ever. I have tried all the old stand by resolutions from shutting Down VS.NET and reopening, to rebooting my personal workstation and even stopping and starting the sql server. All to no avail. I have also tried to remove all the adapters, connections and datasets from the project and rebuilding them all. None of these efforts have helped in any way. Searches on the internet have yielded little help. In fact this does not seem to be a common issue as the number of search returns is quite low. If anyone can help with this issue I would greatly appreciate it as the only solution that appears to be vaible for me at this point is to rebuild the entire application in a new solution\project. I really don't want to do that. Thanks, Ty Akron, Oh Tag: SQLDataReader and Columns Tag: 103000
  - 22
    - Duplicate records being recorded Still working out a few bugs in a survey program I'm writing. The way I have it configured is as each survey is completed, the dataset is updated. When the program is closed, the database itself is updated. However, when I check the database table, there are some answers that are duplicated two and three times. Here are some snippets...(VB.NET, 1.1) //This sub is called on the last page of the survey when the "Finish" button is clicked. Sub GatherAndUpdateAnswers() //there is some code before this that gathers all the answers and assigns them to variables dim newrecord as datarow = mainform.dssurveydata1.survey_data.newrow newrecord(0) = QuestionOneAnswer newrecord(2) = QuestionTwoAnswer //repeats like this until twelve mainform.dssurveydata1.survey_data.rows.add(newrecord) end sub Sub UpdateData() dim pdsInsertedRows as system.data.dataset pdsInsertedRows = mainform.dssurvey_data1.getchanges(datarowstate.added) mainform.oledbdataadapter1.update(pdsInsertedRows) end sub Private Sub Form1_Closing(...) Call UpdateData() end sub When the "Finish" button is clicked on the last form, GatherAndUpdateAnswers() is called. Another problem I am having is Access cutting off some of the fields that require longer answers. I have these fields set to "Memo" in Access, but it's still cutting off after 255 characters. Any idea on how to correct this? Thanks for all responses. Tag: SQLDataReader and Columns Tag: 102999
  - 23
    - DateTime no Time I am using the OleDbAdapter to access a simple ACCESS database. One of the fields is a date/time field. When I insert a record from my NET app, the time portion of the field is missing in the database. I tried changing the data adapter to use a DBTimeStamp instead of a DBDate in the insert command and I get excpetions thrown on the insert "type mismatch in criteria expression" ideas??? I'm going nuts thanks Tag: SQLDataReader and Columns Tag: 102983
  - 24
    - Datacolumn Expression values from Crystal Reports for VS2003 I have urgent question.... I have computed/expression values in my dataset that i pass as the datasource for a report but when i refernce these fields from the report some have correct values others return incorrect values (zero or null)... any ideas would be welcome Tag: SQLDataReader and Columns Tag: 102982
  - 25
    - NullReferenceException, then Invalid Handle Hey everyone, I'm having an intermittent problem with my database connection using the MS provided ODBC drivers. The application is developed in .NET and pages will generally load fine, then all of a sudden I'll get a NullReferenceException error, and then any reload will cause a Invalid Handle error when trying to open a connection. So the 2 errors I get are as follows: ------------------------------------------------------------------------- Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. [NullReferenceException: Object reference not set to an instance of an object.] System.Data.Common.Odbc32.SQLAllocHandle(Int16 HandleType, HandleRef InputHandle, IntPtr& OutputHandle) +0 System.Data.Odbc.DBCWrapper.AllocateDbc(Int64 instanceId) +113 System.Data.Odbc.OdbcConnection.Open() +285 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior) +28 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +88 ------------------------------------------------------------------------- Exception Details: System.ArgumentException: Invalid Handle! [ArgumentException: Invalid Handle!] System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode) +32 System.Data.Odbc.OdbcConnection.Open() +332 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior) +28 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +88 -------------------------------------------------------------------------- The web server will also sometimes just hang and never come back at all. All the code is opening the connections with the using keyword, so they should get disposed of when it finishes. Thanks in advance, Kev -- Numbers in my email address are to prevent spam Tag: SQLDataReader and Columns Tag: 102970

How would I get the length of a column from a SQLDataReader? I'm looking
for something like Query Analyzer uses to display its data. So, I would
need to know that a varchar(200) is 200 where a varchar(20) is only 20.
Also I need to know how many characters a datetime would fill up. This
kinda information.

Does this make sense?

-Roger

Top

Re: SQLDataReader and Columns by W

W
Mon Jan 24 12:56:40 CST 2005

You can use the GetSchemaTable which will return Schema INformation if you
are using SqlClient
http://www.knowdotnet.com/articles/getoledbschematable.html

If you let an adapter fill a datatable - it will have the schema information
contained as well.

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Roger Webb" <rwebb@nos.twia.org> wrote in message
news:%23$wSwMkAFHA.2112@TK2MSFTNGP09.phx.gbl...
> How would I get the length of a column from a SQLDataReader? I'm looking
> for something like Query Analyzer uses to display its data. So, I would
> need to know that a varchar(200) is 200 where a varchar(20) is only 20.
> Also I need to know how many characters a datetime would fill up. This
> kinda information.
>
> Does this make sense?
>
> -Roger
>
>
>

Top