Hi, I have a dotnet 2.0 application, that uses the connection pool to connect to a sql server. That works pretty good. Which kind of authentication is used between the application server and the sql server when persistent connections are used? When I use my sniffer to look into the pack...more >>

Hi, I'm currently moving (slowly) to use Linq to Sql to replace my custom data access layer. Fortunately, my DAL worked very similar to L2S as far as the use of classes goes; each table is decorated with attributes that tell my DAL how to do what it needs. At first glance, it seemed all I ...more >>

How can the .dbml be created programmatically? If I don't want to use the full GUI designer and instead want to automatically build associated data classes when the DB schema changes, how can I do that? Thanks. ...more >>

A data-bound DataGridView is wonderfully simple to include with a Windows Form. Now that all the data is there, how do I go about adding a new record? When I tried, Visual Studio 2005 Pro gave me an InvalidOperationException, saying, "Rows cannot be programmatically added to the DataGridView'...more >>

Hello everyone, I am designing an application around a dance school. The school is open for 10 months - September-June. The students pay a monthly tuition. Anyone have any suggestions on how to track the payments? I'm trying to design the table layout and am hitting a mental block. Any sugg...more >>

I have one TableAdapter that has 2 custom updating functions, 1 insert, and the default Fill. In my 2 custome updating functions, one function updates some fields, whereas the other function updates the other fields (we do not always want to update all records). The problem is, when I ca...more >>

I am using SQL Server 2005. I have a form with a grid on it. I have this code in place: String strFilter = String.Format("Line={0} AND Time='{1:D2}/{2:D2}/{3:D4} {4:D2}:{5:D2}'", m_cd.m_iLine, m_cd.m_dt.Mont...more >>

Hello, What's new in ADO.NET framework 3.5 about new features, changes, improvements ? Regards, ...more >>

is it possible to get the size of the datatype of a datacolumn in a datatable? i want to show the datatype with the size of a table. first i got the table in a dataset. then i try to catch the datatype. all are working fine? but my question is "is it possible to get the datasize ie. like varch...more >>

I am a newbie to the ES namespace and have heard peple talking about using it in conjunction with ADO .NET in aiding in the creation of connections. So far, what I can find out is that ES is related to ADO .NET in transactional processing. Does ES provide any benefit to ADO .NET if I'm not ...more >>

Hello, in SQL scripts I can use GO to force query analyzer to finalize the batch above. Before continuing with execution of code. This is needed i.e. when i add a new column before i can fill it. Is there an equivalent statement that can be used when hte script is loaded from file and exec...more >>

I am using TableAdapters the same way in the code below. The first works, and the second does not. Names shortened here for simplicity, and values hardcoded. In both cases I can stop in the debugger and see the correct connection string in the TableAdapter, which they both get from web.config...more >>

In the docs this is used all over the place: new Uri("somefile.txt") but that throws an exception "Bad Uri Format". It works if you specify: new Uri("somefile.txt", UriKind.Relative) Is this a bug or how it is supposed to work? I thought Uri's were relative by default (though I have ...more >>

Hi, I have a Typed DataSet named MyDataSet and a Component (System.ComponentModel.Component based) and It last have a property from MyDataSet typed. But when use my component and set the proporty, raise the message "MyDataSet can't convert to "MyDataSet", ¿ How do it ? Alvaro....more >>

I am having a problem putting all of the pieces together on this one and would appreciate some help. I need to find a row based on certain criteria, retrieve its Item Number or position in the table, then update a field in the row. In other words, locate the row where Field1 = x, update Fi...more >>

Hi, I'm running a .NET 1.1 application and I'd like to use a .NET 2.0 Web service which uses .NET 2.0 Datasets. I would like to write a proxy class that talks to the Web service on one side and on the other to the .NET 1.1 app. Is it possible to create .NET 1.1 Datasets in the .NET 2.0 e...more >>

Hi I have a strongly typed dataset generated by vs 2008. I am trying to fill in one of the datatables in the dataset and then cerate a dataview from the datatable. I have used the below code but it does not work. Public ds As MyDS Public dv As DataView Public daMyTbl As MyDST...more >>