Please help! I am trying to create a custom paging datagrid without success. I have set the VirtualItemCount(Actual Number of records), AllowPaging(true), AllowCustomPaging(true), and OnPageIndexChanged(changePage function). All have been set successfully, the changePage function is public ...more >>

Hello, I am working on a school project and I decided that I should try to create a stored procedure for this project. I was very successful in creating a simple query which returned a bunch of rows. I changed the query to count the number of rows being returned in addition to what I was re...more >>

Hi there, I need help I wrote the code below to find a record specified by the user. It only works if the fields being searched match the sort criteria used to retreive the records from the database. My problem is the users of the application would like to to ability to perform searc...more >>

What is the purpose of the Server Explorer, Table, Design Table, highlight column, Default Value field at the bottom of the screen? I thought it was to automatically place a value in the DataSource when a new row is added from a DataSet that does not have a value for that column. Thus, you cou...more >>

Guys, I'm populating a dataset and displaying the data in a datagrid. Then, when the procedure ends the data disappears. Obviously, this isn't very useful. Any ideas why this is happening? Thanks, Simon. (code below) private void Page_Load(object sender, System.EventArgs e)...more >>

Hi Guys, I have an account created on SQL Server as "Guest" with password as "guest". Now when I test this account from Server Explorer in Visual Studio.NET under Data connections, it gives me Connection failed: SQL State: 42000 SQL Error: 18456 Even though I have an account create...more >>

I'm getting this "Object reference not set to an instance of an object" error when trying to post updates to a Dataset back to the database. Would really appreciate any help from those of you who know what you're doing. The error pops up in the Button1_Click SUB when the SqlDataAdapter1.Updat...more >>

Why does below fail? I understand how to re-write the code to avoid the failure, but it should not fail to begin with. Cannot DBNull be passed as an object? ' holds extension number or DBNull if non exist Dim Extension As String = Nothing ' get extension number or DBNull if non exist Ext...more >>

Hello All, How do I change SqlServer Table's Field length from 50 to 250 through the script . As I don't want to change the table through design view because my table is on the web and design view takes 5 hrs to open a table. Regards, Ather Ali Shaikh Software Engineer eIntelligence (Pvt...more >>

Hi, just wondering when is a connection really closed when I called the Close() method on the SqlConnection object. The code below runs without problem even though the SqlConnection is supposedly "closed!" The DumpTable routine dumps the correct values. String strConn = "SERVER=lo...more >>

Hi, I working on an application that connects to an access database. When I set the OledbConnection and OledbDataAdapter locally I have no problems. Now I want to add an UltraWebGrid to the page and I want to set a DataAdapter on the page (by dragging a OledbDataAdapter and OledbConnection ont...more >>

Hi All, Question #1: I am attempting to write a connection pool on an SQL Server that doesn't seem to work, according to Profiler and Performance Monitor using 'User Connections' counter(not the buggy '.NET CLR Data' counter). I would like for there to be 10 connections established at the...more >>

Hi, I have a Stored Procedure that retrieves a series of records in a parent child hierarchy. That is it retrieves the parent record and it's children. I would also like to retrieve information on the relationships between the parent and the children (ie. primary key, secondary key, relations...more >>

Is there a way to turn off optimistic concurrency in ASP.NET when updating a record via the oleDBdataAdapter/oleDBcommandBuilder? If you use the Microsoft ASP.NET tools you can turn it off and thus modify the SQL statement so that it doesn't include the WHERE portion, but I'm not sure how to d...more >>

Hi Is there an ADO.NET limit on the amount of data that can be impacted in a single batch ? I know that ADO had an 8K limit Thanks, Venkatesh...more >>

Hi, I need some help. I have a on button click event that goes through a survey and reads the items they choose and then updates the current record. The problem I'm having is that nothing actually is written back to the database even though it runs the command. An append query works just fine. ...more >>

Hi, I have a table IV00108wc which contains several thousand records in whcih ITEMNMBR is the primary key. I have a com+ object returning recordset which has ITEMNMBR and another details related. [I do not have direct query to get the list] I want to query another table based on Com+ obje...more >>

Hi, I'm writing an application which, when the users clicks a button in FormA(MDI form), FormB is loaded. I'm using Dim FormB as New FormX (FormB is then set as a child of FormA) My problem is that, if the user clicks on that same button again, a second copy of FormB is loaded. Is there a wa...more >>

I want to use the single connection and command object, Can anybody tell me the best practice for the follwoing code....I get an error "There is already an open DataReader associated with this Connection which must be closed first. " IDataReader result = myCommand.ExecuteReader(); myCommand.P...more >>

Hi All, What reason make the datagrid halt?? How to resume it to normal if it = happens?? is there any way to avoid it?? =20 Thanks All, Ivan...more >>

I have the following code: SqlConnection cn = new SqlConnection(stdConnectStr ) cn.Open(); SqlTransaction tx = cn.BeginTransaction(); try { db.Update( obj ); tx.Commit(); } catch( Exception ex ) { tx.Rollback(); throw ex; } finally { cn.Close(); } db.Update creates a...more >>

Hi, the browser in Vis.Studio .NET indicates that SqlDataReader inherits from IEnumerator, but intellisense doesn't show any member (GetEnumerator) of an SqlDataReader object. Nor does the following compile : SqlCommand cmd = new SqlCommand("SELECT firstname, lastname, city FROM employee...more >>

Hello, ASP gives me an unspecified error with the following code: -------------------------------- <%Option Explicit %> <HTML> <HEAD> <TITLE>Testing connection to the database</TITLE> </HEAD> <BODY> <% Dim strConnect strConnect= "Provider=Microsoft.Jet.OLEDB.4.0;...more >>

Does somebody know how does the cancel command work? Because i'm getting the following error: When I execute a Cancel method on a command sometimes this cancel request cancels another command on the same connection (or in another connection when I use connection pooling) that appears after the f...more >>

I am having trouble using an oracle parameter in a simple sql statement. I am able to get this sort of thing to work in SQL Server with no problem... Here is my code for oracle: OracleConnection conn = new OracleConnection(strConnection); conn.Open(); ...more >>

I have a data set with a number of added columns having calculation expressions based on other columns in the same table and child tables. Some textboxes are bound to these calculated columns. When the DataSet loads, the calculated columns are evaluated correctly. But when I update oth...more >>

I am developing an application in VB .NET and Oracle 8i. I am exactly not sure about what provider should I use for my database. Which one would give the best performance and also will not have any conflicts from moving from Oracle 8i to oracle 9i in the near future. Any help would ...more >>

HI How do I get the SQL batch size in ado.net ? SQL Server has an upper limit on the batch size of (65,536 * Network Packet Size). If I have a batch that may exceed this value, I want to check the value, and break the batch into multiple batches. Thanks....more >>

In developing a .NET website I've come across an issue with DataViews that provoked some head scratching before ultimately finding a way around it - but I'm curious as to the reason for the issue. Using C# & Framework 1.1 1) Table in database (containing country codes & descriptions) 2) F...more >>

In classic ASP application I was storing database connection information in global.asa file. What are the pros and cons of storing database connection (string) either in global.asax or web.config file ? Which is the recommended way ? Thanks for your thoughts. Gish Smith ...more >>