Is there a way to have a windows form binded to a dataset having textboxes,combos and grids all binded to a different datatable and do search on a dataset, clear dataset and reload or add records from a similar dataset and keep the binding? Victor ...more >>

Hi Kevin, Thanks for getting back to me. I am using C# with asp.net to access the database. Below is the code that I am using to access the two tables. string DataBaseName; string SelectCommand; NameValueCollection coll; coll = Request.ServerVariables; DataBaseName = coll.Get...more >>

Hi. I have a stored procedure that runs a query using full-text. In my code, I create a string variable with the full-text expression ans pass this variable to a paramter in my procedure, in order to avoid dynamic sql in my stored procedure. My variable is created this way: strSearchParam =...more >>

Hi, I am implementing an app that will do massive updating on a DataTable with multiple threads. Typically I first look up the row: DataRow row = mydatatable.Rows.Find(key); and then do some updating: row.BeginEdit(); // here is where I get the exception foreach (string colname in c...more >>

I have a stored procedure that queries a sql server database and returns the multiple data tables ( 7 to be precise) these tables are the results of many joins. When I use the System.Data.SqlClient namespace objects to access this data it is returned intoa dataset, this dataset has the tables a...more >>

Need help with setting up data connection in ADO.NET. Checked message boards but have not found solution. Any help would be appreciated. Here is my situation: BACKGROUND: I'm using Visual Basic.NET Standard 2002 on XP Pro running MSDE (the one that came w/ Visual Studio). Here is the pro...more >>

Hello, I have a data table ,create from a data adapter. Changes are made to the original data source. I obtain a fresh copy of the data table. I need to establish what has changed between the two copies. If I merge the the resulting table shows all rows to be unchanged. If I handle the ...more >>

Hi all, I want to copy or move an existing DataRow wich belongs to a DataTable to another DataTable, but I got the exception "This row already belongs to another table". I tried to use the ImportRow method, but this method inserts the row at the end of the DataTable, and I need to put it at...more >>

Hi Friends, What will be the effects when more number of SQLDataAdapters used in an application. Do they the slow down the application speed? If any other effects pls let me know. Regards, Shakthi ...more >>

Hi, I was just investigating into ADO.Net when I suddenly realized what Microsoft had done ! As long as you are only dealing with one database type and that you are sure that you will keep it for the rest of your application life everything is ok ! Now what about having one odbc database...more >>

i am not getting the output parameter value in vB.net after executing the storedprocedure. CREATE PROCEDURE Search_Assets_By_String @Search varchar(50), @Descriptive bit, @RC int Output AS IF @Descriptive = 1 BEGIN Select * from Assets where (Name LIKE '%' + @Search + '%' OR De...more >>

When I have attempted to use the InsertGroupByInto() method to group by multiple columns, the DataSetHelper class throws a NullReferenceException unless I select the Rollup option (which I don't want). I'm trying to group by 5 columns with only a single aggregate column (count()). When I select ...more >>

In the following piece of code from my control, the Sort doesn't work. The foreach processes the data in the order that it appears in the XML file. protected override void Render(HtmlTextWriter output) { _XmlPath = Page.Request.MapPath( @"content\" + _XmlFileName ); _ds.ReadXml( ...more >>

I've got a whole bunch of dim statements which need to be repeated at various stages. I tried to create a public sub, put the statements in there and then add the sub name into the code where the dim statements are needed, but it still says that the whole bunch of stuff that needs to be dimensio...more >>

I want to add Attributes into CheckBox in .aspx page <html> <asp:CheckBox id=3D"ChapterCheck" runat=3D"server" /> </html> How to add Attributes in <asp:CheckBox> ?...more >>

please excuse my last post on this which was improperly formatted due to a utility(text cleaner) that I had active. My problem is that I read ado.net step by step, including working out all the examples. In the end, I still can't create generic procedures in classes and modules. I'm...more >>

What is the best ado.net book illustrated in vb.net? Thanks, Gary ...more >>

Hi I'm looking for ADO.NET data providers for object database (not via ODBC). I've found only Matisse (www.matisse.com) so far. Does anyone know anything else? Thanks, --Jane...more >>

<asp:HyperLink ID=3D"DeleteLink" = NavigateUrl=3D"ChapterManger.aspx?CourseID=3D" + '<%# = DataBinder.Eval(Container, "DataItem.course_id") %>' = Runat=3Dserver>Delete</asp:HyperLink> I want to connect the strings with blue, but failed, How to do?...more >>

<asp:HyperLink ID=3D"DeleteLink" NavigateUrl=3D'<%# = DataBinder.Eval(Container, "DataItem.course_id") %>' = Runat=3Dserver>Delete</asp:HyperLink> =D2=D4=C9=CF=D5=E2=CC=F5=D3=EF=BE=E4=B5=C4 NavigateUrl = =D6=BB=C4=DC=CF=D6=CA=B5=CB=F9=B0=F3=B6=A8=B5=C4 course_id = =D7=D6=B6=CE=B5=C4=D6=B5=A1=...more >>