tag:blogger.com,1999:blog-6082652835152798567.post4536503245166646639..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: Caching dataset in asp.net - Part 12Unknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6082652835152798567.post-36787998203065109492014-07-20T23:53:18.669-07:002014-07-20T23:53:18.669-07:00rinku u can write code in class like this---
publ...rinku u can write code in class like this---<br /><br />public personal_dal()<br /> {<br /> //<br /> // TODO: Add constructor logic here<br /> //<br /> }<br /> string connec = @"data source=DELL-PC\DELL; initial catalog=school_crm; integrated security=true;";<br /> <br /> public int creatdata(string p)<br /> {<br /> SqlConnection con = new SqlConnection(connec);<br /> con.Open();<br /> SqlCommand cmd = new SqlCommand(p, con);<br /> return cmd.ExecuteNonQuery();<br /><br /><br /> }<br /><br /> public System.Data.DataTable getdata(string p)<br /> {<br /> try<br /> {<br /> SqlConnection con = new SqlConnection(connec);<br /> con.Open();<br /> SqlDataAdapter da = new SqlDataAdapter(p, con);<br /> DataTable dt = new DataTable();<br /> da.Fill(dt);<br /> return dt;<br /> }<br /> catch { DataTable dt = new DataTable(); return dt; }<br /><br /> }Anonymoushttps://www.blogger.com/profile/05446682829478106538noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-7423382516244613042013-06-18T13:05:30.131-07:002013-06-18T13:05:30.131-07:00Dear Venkat,
The videos are thoughtful, fully pr...Dear Venkat, <br /><br />The videos are thoughtful, fully professional and helpful. I am looking forward to see how Data Access Classes are written for large projects. Kindly suggest me if you have updated any video on 3-Tier and writing DAC. <br /><br />Thank you,<br />Rinku.Anonymoushttps://www.blogger.com/profile/05580827764237965952noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-29752507257336381052012-12-24T22:50:41.406-08:002012-12-24T22:50:41.406-08:00hi venkat your blog is simply superb...plz provide...hi venkat your blog is simply superb...plz provide realtime Examples related to database using cache in asp.net...ThanksSURYAhttps://www.blogger.com/profile/09549191013921462639noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-62913664979274165042012-11-03T00:30:47.419-07:002012-11-03T00:30:47.419-07:00Hi Maran, I have updated with the correct video. T...Hi Maran, I have updated with the correct video. Thank you very much for bringing it to my attention. Really appreciate it. Thanks againVenkathttps://www.blogger.com/profile/11295753737388828672noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-85741624130848441022012-11-02T12:19:49.560-07:002012-11-02T12:19:49.560-07:00venkat the video you have attached to this topic i...venkat the video you have attached to this topic is Asp.net part 16. Please correct it. Thanksmaranhttps://www.blogger.com/profile/05545355470650323198noreply@blogger.com