I've got an ADO.NET application which I would like to debug by inserting a breakpoint in a statement of the code. When I pressed F11 to start debugging, VS.NET always displayed a JScript. I had to step through every statement in it until the webpage showed up. Actually, I wanted to see the ...more >>

As I got to know that name parameters are used in sql server and oledb data provider uses question mark (?) literal. Could you please give me detailed information regarding these? How they work, when they are used and why we use them. ...more >>

Hi, I posted a post earlier but for some reasons it didn't show up. AW, I want to grab the rowid(Primary key) of last row inserted. I tried but it gives me error regarding cast.The column is int and I tried datareadter.getint32(0) but it didn't work. Also can I execute two queries withi...more >>

Can I execute two queries with in a single Command.text. Like in first query I want to insert a row and in second query I want to get the RowId last inserted. or do I have to execute two queries? Thnx...more >>

I'm trying to get the id of last row entered. The column is INT, but it errors out saying 'Specified cast is not valid.'... command.text = "SELECT @@IDENTITY FROM tablName"; SqlDataReader oRD = command.ExecuteReader(); while (oRD.Read()) { Response.Write ("<BR> identiti is " + oReader.GetI...more >>

im getting the dreaded: Object reference not set to an instance of an object. on the code below. pretty new to C# but i know im missing something basic here. any help is appreciated thanks rik public void GetEEs() { SqlConnection myConnection = new SqlConnection("Data Source=(L...more >>

I have a strange behaviour. Perhaps someone can look through if there is anything obvious wrong. The field ProjAdmin is a tinyint SqlConnection con = CreateConnection(); con.Open(); string sql =" UPDATE tblEmployee " + " SET ProjAdmin = @param WHERE (EmployerID = 1002)"; SqlCommand cmd...more >>

1. When ever an object of datareader is created ex:--> dim rdr as oledbdatareader why we are not using the new operator? 2. Could you please give me detailed overview of datareader ie.how it works,the different member functions of this class etc. ...more >>

Could you please suggest me some small projects that i can make using ADO.NET. I want to use msaccess as the database. Currently i want to work on datareader. Thanks in advance ...more >>

Hi Folks, I'm a total ADO.NET newb! I've done some Visual C++.NET and some windows forms programming but have not done any ADO.NET coding yet. I am writing to ask what is the best way to get started with a simple Windows Forms ADO.NET project? Is it possible to build a Windows Form project ...more >>

Application: When a user selects a name in the listbox complete information(phone-no,E-mail,et=ADc..) regarding the person should be displayed. Problem: I have populated the list-box with names using datareader.The database comprise of id with respect to each name.Now since the id's are uni...more >>

Dear sir/madam iam working with an application in c#. in which we have to handle with webpages with our appication i have a small problem. we have to screenshot a particular webpage through code, ithere any way todo this, Thank you for helping me with regards saish ...more >>

Hi all, I would like to ask you, how many transactions per second can you achieve on your sql servers? I have simple stored procedure that updates records in small table - and I cannot go over 220 trans per sec using ado .net... Is it ok? I am using generated dataadapter (framework 2.0, be...more >>

I want to convert standard SQL update syntax into calling stored procedure. Normal Coding ------------- Dim constr As String = "server='SQLSVR'; user id='USER'; password='password'; Database='ERP'" Dim sqlcon As System.Data.SqlClient.sqlconnection = New System.Data.SqlClient.sqlconnection(...more >>

Hello I tried it for 2 days and read a lot of messages, but I can't find it out what's wrong with the following code. I want to open a dBase file via Microsoft odbc. The connection goes on without error message, but at the line daDBF.Fill(dsFBF,"TABLE1") the programm crashed with the error m...more >>

Hi, We have written small stored procedure for reading data to dataset. Stored procedure has total three parameters, in one is mandatory and another two has default values. If we use SQL Command object or SQL Data Adapter we need not declare the SQL Parameters for the optional parameters in...more >>

1. In a simple query like str = "select * from emp where empid = '23'" why in the where clause we always use '@@' these quotes. ...more >>

I'm looking for some DB Independence information on web, but I just found information like persistence-oriented. I would some patter, but not persistence, for DB Independence using the old and good SQL. Any tip? ...more >>

Does anyone know why while working with drv (DataRowView) a) if I uses this: -------------------------------------------------------------------- drv.Row.Item("CODE") = 254 -------------------------------------------------------------------- would always make the row state "Modified" b...more >>

Hello, I am having a problem inserting into a dataset that is loaded from a view that does joins with other tables and includes required fields from those tables. For example, I might have a view that is an Orders view which does a join to a Contact table and contains the contact's last nam...more >>

For login screen program username and password are accepted anc check it from oracle database. The valid username and password entered. but I got the error "ORA-12154: TNS could not resolve service name". i am using provider for this connection. But the same oracle database can be connected...more >>

Okay, this is a really simple question. This for xml explicit query --- SELECT 1 as Tag, NULL as Parent, G.GrandParentID as [GrandParent!1!GrandParentID], NULL as [Son!2!SonName] FROM GrandParent G WHERE G.GrandParentID IN (Select GrandParentID from Son...more >>

Hello, recently I have encountered with the strange issue concerning ThreadAbortException that throws DbDataAdapter.Fill (see below the stacktrace [1]). At the first time I suppose that this problem due to Command.Timeout property that was set too small, but to tell the truth it has the m...more >>

Hi I am having a few problems with one of my forms... I have a data grid bound to a dataset using a currencymanager and it's all working fine. However when i edit or change any of the data in the Datagrids columns/rows i need to call update so the changes are saved back to my database, this is...more >>

hey guys, i have a prg that writes a flat text file with specific (spacing) whitespace between the elements. that works fine. but i was curious: when i use streamReader to read that back and say put into a listbox, the spacing (formatting) goes away. does anyone have any insight on how to ke...more >>

hi, I have a dataset with 2 tables(Header and Detail) I am using 10 adapters to fill the dataset(5 for Header and 5 for detail). All the adapters are having same columns(schema) as the tables in the dataset. While filling the dataset using the adapters one by one, i am not getting the expec...more >>

I always used XmlDocument to load a xml file into memory and to access it. But if the xml is very huge (Say over 500MB) How can I access it? ...more >>

I have a xml files, there are many record in it. Can I insert these record into database at once, or I need to insert it record by record? ...more >>

Hi Folks, I have a typical situation here. My application is a sequence of windows jobs (all are coded in C#). Now one of my jobs when run is supposed to fetch around 100,000 records from the SQLDataReader, the SP returns 100,000 records. So, this SP call from C# and then reading the data using...more >>

Hi all, with the sample below, if the query returns huge amount of data, will database returns the portion required by program or returns all data, then Fill methods filter unnecessary ones? int currentIndex = 0; int pageSize = 5; string orderSQL = "SELECT * FROM Orders ORDER BY OrderID";...more >>

I am trying to find out why my return from my ASP.Net page is always 0. I have the following code: **************************************************** Dim objCmd as New SqlCommand("AddNewResumeCoverTemplate",objConn) objCmd.CommandType = CommandType.StoredProcedure objCmd.parameters.ad...more >>

Is there any way to backup/restore an SQL Server database from .NET, using the System::Data::SQLClient namespace? Thanks...more >>

I have a need in my application to add a dummy row to a dataset object after I have filled it with a call to the database. Trying to find a solution I thought that doing a dataset merge might work, however its doesn't seem to be. Following examples I found in some MSDN articles I came up with ...more >>

I want to develop an app that requires database management. I was initially planning on using an mdb and the Jet driver. However, MSDE offers more robust features. For some reason I always thought you could develop apps with MSDE and freely redistribute. However, I recently read that MSDE "is ...more >>

it looks like i'm in a C# world here in houston,Texas and i'm gonna have to make the plunge after doing and really enjoying VB.NET with winforms and web forms for the last couple of years. yes, even picked up some javascript along the way. my question is (since there's no classes being held in thi...more >>

I am trying to read a CSV file using Jet OLEDB provider. The file (badimport.csv) looks like this: Name,Description,DefaultPrice_$_per_m3 S6,Structural sawlog MSG6,65 S8,Structural sawlog MSG8,75 S10,Structural sawlog MSG10,90 S12,Structural sawlog MSG12,120 Using an O...more >>

I have run out of ways to determine the reason for a timeout error. The timeout is occuring on the line indicated with ==>. After completing the statement before, the status of the connection object(cn) is Open. After the timeout occurs and execution is transferred to the Catch block, the connect...more >>

Hello All Thank you for any help you can provide! I have a long list of links with decscriptions titles etc in a SQL Server 2000 database. The basic problem is that I am attempting to use a data base cursor to to the proper starting point in a sorted view, get the next 10-or 20 records and...more >>

Hi; I am trying to do a simple operation of inserting a row into a database. I have set a data adapter to get data from the database to check for duplication. That works fine. When I try to use this data adapter to INSERT the data into the database, if there are no duplicate records, I get...more >>

in asp.net application I bulk insert records using OPENXML, into table "myTable". which has the following field: column name : myCol dataType : bit ..... ... .. myCommand.CommandText = "select myCol from myTable " adapter.SelectCommand = myCommand adapter.TableMappings.Add("Table", "m...more >>

If I create a child relationship between 2 tables, but the parent table has a value which is not found in the child table, then this will cause an exception....right? So how to I indicate that the parent/child relationship may or may not exists so that no exception is generated when that occu...more >>

Repost using registered alias: I have an existing .xsd file with typed dataset information in it. I need the ability to update this existing schema information when a column is removed from one of the underlying data adapters. Currently I read the existing schema info into a temp dataset o...more >>

I'm confused on calling ExecuteDataset with on a stored procedure with a single parameter. The following code gets an error stating there is no Stored Procedure with the name of '4' (probably the value of the CommandType.StoredProcedure enumeration). Dim parm() = New SqlParameter(0) {}...more >>

I had something like the following working: !!!!!!!!!! !!!!!!!!!! Start of Code snipet!!!!!!!!!! !!!!!!!!!! <asp:DataGrid id="FormListDataGrid" runat="server" AutoGenerateColumns="False" ShowHeader="true" HeaderStyle-CssClass="header" AllowSorting="true" OnSortCommand="SortCurrentMonth_OnClic...more >>

I have data from two different databases which I want to join together. If I create one Datatable with the results of one query and another Datatable with the results of the second query, can I somehow join the 2 Datatables to produce a result which will look like I had executed a single que...more >>

I have a DataGrid that support sorting in ASP.NET 1.1 as defined at the end of this post. The issue is that regardless of what "style" attributes I put in the <asp:DataGrid/> tag or the <asp:HyperLinkColumn /> tags, I don't seem to be able to change the actual CSS class for the generated <a/>...more >>

How do I convert this ASP 3.0 to VB.Net coding? ASP 3.0 Coding ----------------- Set rs = Server.CreateObject("ADODB.Recordset") rsstatm = "SELECT * FROM F4111" rs.Open rsstatm, ConnSQL rs.movefirst do while not rs.eof rsAdd = "INSERT INTO F4111A (ILITM,ILLITM,ILAITM) VALUES" ...more >>

I have one dataset. Filled one DataTable from dbase. Filled another DataTable using ReadXml() and Merge(). So now I have to DataTables that I want to Join on that exist in memory but are from disparate data sources. Can I Join on them with ADO.NET? Thanks. ...more >>

Hi Is there any way to export to XL thru Dataset , or DataTable or Grid or any other controls , than manually writing to each cell in XL Renjith...more >>

(Type your message here) -------------------------------- From: vallabh naidu Hi everyone, I have a typical problem, I dont weather what i am writing is= correct or not but I just want to filter the dataview and here= goes the code but that code below is not filtering according to= t...more >>