tag:blogger.com,1999:blog-6082652835152798567.post1299777048878157339..comments2024-03-28T00:58:12.736-07:00Comments on Sql server, .net and c# video tutorial: Part 1 - How to retrieve data from different databases in asp.netUnknownnoreply@blogger.comBlogger8125tag:blogger.com,1999:blog-6082652835152798567.post-43510275597957914442017-09-30T07:41:04.142-07:002017-09-30T07:41:04.142-07:00Keep up the good work.Thanks for the awesome tutor...Keep up the good work.Thanks for the awesome tutorials Anonymoushttps://www.blogger.com/profile/07598644682301054646noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-73660369389318971212017-07-01T05:44:13.679-07:002017-07-01T05:44:13.679-07:00SqlConnection con = new SqlConnection(Configuratio... SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["UKDBCS"].ConnectionString);<br /> SqlDataAdapter da = new SqlDataAdapter("select * from Dept", con);<br /> <br /> DataSet ds1 = new DataSet();<br /> da.Fill(ds1);<br /> <br /> <br /> da = new SqlDataAdapter("select * from Employees", con);<br /><br /> DataSet ds2 = new DataSet();<br /> da.Fill(ds2);<br /><br /> ds1.Merge(ds2);<br /><br /> GridView1.DataSource = ds1;<br /> GridView1.DataBind();Anonymoushttps://www.blogger.com/profile/17256873810033901305noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-44462956857334004092017-06-10T14:37:25.071-07:002017-06-10T14:37:25.071-07:00when table name id different what i use on this ...when table name id different what i use on this coda ( da.SelectCommand.Connection = con;)NO ONEhttps://www.blogger.com/profile/06745214124192381232noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-60256663996709321922017-02-23T12:26:53.712-08:002017-02-23T12:26:53.712-08:00Hi, thanks, it's perfect, now a question, how ...Hi, thanks, it's perfect, now a question, how would I do if I want to compare two columns of two identical tables but in different databases? for example:<br /><br />Values DB1 - Values DB2<br /><br />-------------------------------------<br />Table1 Table2<br />ID | VALUE ID | VALUE <br />1 | 24 1 | 100<br /> <br /><br />And with the JOIN <br /><br />----------------------------------------<br />ID | VALUEDB1 | VALUEDB2<br />1 | 24 | 100 Gle Camberohttps://www.blogger.com/profile/13288510826664255254noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-37852282780337995202016-02-12T22:45:43.970-08:002016-02-12T22:45:43.970-08:00Data set is client side in memory representation. ...Data set is client side in memory representation. you can store more than one table inside the dataset. it is work like as database relationship (primary key etc). so same relationship you can store inside dataset.<br />if you dont want to store more than one table then datatable is good option for single table record.Anonymoushttps://www.blogger.com/profile/08881756759248108161noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-16648798673441864922016-02-11T22:09:51.096-08:002016-02-11T22:09:51.096-08:00Sir Can i Store Multiple Table on one Dataset?Sir Can i Store Multiple Table on one Dataset?Anonymoushttps://www.blogger.com/profile/17850222573684936201noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-36748461305042671612014-08-13T02:15:52.648-07:002014-08-13T02:15:52.648-07:00Hii Mr Venkat ; Really interesting Topics about Da...Hii Mr Venkat ; Really interesting Topics about Data Integration .. I was wondering if this code and approach works if we want retrieve data from heterogeneous models databases (ex: DS1 Oracle or MySQL Database, D2:MS SQL Server ) ??<br />Thank U a lot for All Ur Videos Tutorial in all categories and specially for this one related to Data Integration and Meta data ..Please Continue (-_^).. Samir SELLAMIhttps://www.blogger.com/profile/12250411449147265726noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-85421438808951719782014-06-05T14:54:14.798-07:002014-06-05T14:54:14.798-07:00Hi Venkat, you are doing a great job by helping th...Hi Venkat, you are doing a great job by helping the developers/students to learns ,NET very easily. Great working. keep it up.<br /><br />Pawan Kumardotnetbloghttps://www.blogger.com/profile/10376643445683550817noreply@blogger.com