tag:blogger.com,1999:blog-6082652835152798567.post6946183466566172706..comments2024-03-28T00:58:12.736-07:00Comments on Sql server, .net and c# video tutorial: Part 15 - Disconnected data access in asp.netUnknownnoreply@blogger.comBlogger11125tag:blogger.com,1999:blog-6082652835152798567.post-82055573919099074932019-12-25T13:55:11.949-08:002019-12-25T13:55:11.949-08:00I have this error at the time of updating and dele...I have this error at the time of updating and deleting please give me solution<br /><br />Object reference not set to an instance of an object. <br />Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. <br /><br />Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.<br /><br />Source Error: <br /><br /><br />Line 81: {<br />Line 82: DataSet ds = (DataSet)Cache["DATASET"];<br />Line 83: ds.Tables["Student"].Rows.Find(e.Keys["ID"]).Delete();<br />Line 84: // DataRow dr = ds.Tables["Student"].Rows.Find(e.Keys["ID"]);<br />Line 85: // dr.Delete();<br /><br /><br />Anonymoushttps://www.blogger.com/profile/16173842383262139776noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-25761157710625789122018-02-12T04:20:56.086-08:002018-02-12T04:20:56.086-08:00Visual Studio Problem
you re-install your vsVisual Studio Problem <br />you re-install your vsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-29172332388597760852017-05-26T22:38:04.558-07:002017-05-26T22:38:04.558-07:00Venket sir, How can i insert a new record using th...Venket sir, How can i insert a new record using the above example also, if i give new record and give update, it shows an error. i could not insert a new record. pls do one video for insert data using the above example.Antony Judes.Shttps://www.blogger.com/profile/00586092685661248261noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-50426827941774979722016-08-06T03:55:02.617-07:002016-08-06T03:55:02.617-07:00Dear Venkat, really your tutorials helped me a lot... Dear Venkat, really your tutorials helped me a lot. kindly help me in inserting new row with identity. i am able to add new row but unable how to get identity for inserting. Moreover, what if i load a subset of data (e.g only male in this example) from underlying database table then want to insert new records. here also i am unable to generate identity.<br /><br /><br />if (e.CommandName == "InsertRow")<br /> {<br /> string name = ((TextBox)GridView1.FooterRow.FindControl("NameInsertTextBox")).Text;<br /> string gender = ((DropDownList)GridView1.FooterRow.FindControl("GenderInsertDropDownList")).SelectedValue;<br /> int totalMarks =Int32.Parse(((TextBox)GridView1.FooterRow.FindControl("TotalMakrsInsertTextBox")).Text);<br /><br /> DataSet dataSet = (DataSet)Cache["DATASET"];<br /> DataRow dataRow = dataSet.Tables["Students"].NewRow();<br /> // Update datarow values<br /> dataRow["ID"] = //i need identity here please help<br /> dataRow["Name"] = name;<br /> dataRow["Gender"] = gender;<br /> dataRow["TotalMarks"] = totalMarks;<br /> dataSet.Tables["Students"].Rows.Add(dataRow);<br /> // Overwrite the dataset in cache<br /> Cache.Insert("DATASET", dataSet, null, DateTime.Now.AddHours(24), System.Web.Caching.Cache.NoSlidingExpiration);<br /> // Remove the row from edit mode<br /> GridView1.EditIndex = -1;<br /> // Reload data to gridview from cache<br /> GetDataFromCache();<br /><br /> }Ibrahim Janhttps://www.blogger.com/profile/10074423638600679988noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-57085241569776256872016-07-28T11:44:47.043-07:002016-07-28T11:44:47.043-07:00help me with this.....An exception of type 'Sy...help me with this.....An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user codeAnonymoushttps://www.blogger.com/profile/07361924105238311141noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-89241225652482856282016-06-21T21:02:00.920-07:002016-06-21T21:02:00.920-07:00
Dataset is the disconnected environment. suppose ...<br />Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?<br /><br />Anonymoushttps://www.blogger.com/profile/05393727942952952656noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-26211161530264318512015-10-08T05:46:51.536-07:002015-10-08T05:46:51.536-07:00Hello Venkat!
Is it possible to do this with a st...Hello Venkat!<br /><br />Is it possible to do this with a strongly typed dataset? How would you do it? How would the code for Row Updating look like and Update Database etc?<br /><br />Thanks!Hans-Erik Hamid Alshamaa Lydeckerhttps://www.blogger.com/profile/04422852098509949191noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-6380250055211897432014-11-05T07:08:09.428-08:002014-11-05T07:08:09.428-08:00Hi Sir I need ur help ............
I m trying...Hi Sir I need ur help ............<br /><br /><br /><br /><br /> I m trying to generate auto generated CRUD in my Asp.net code using Visual studio<br /><br />Problem:<br />In lecture video tutorial these check boxes are enabled But they are disabled as i cannot tick these boxes <br />Please tell my How can i get rid of this problem??????????????<br /><br />Regards......Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-76760712288416966212014-06-18T11:22:24.250-07:002014-06-18T11:22:24.250-07:00e.keys , e.NewValue , e.OldValues all are showing ...e.keys , e.NewValue , e.OldValues all are showing empty . Please helpwwwhttps://www.blogger.com/profile/06906951186419643663noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-9253263725897288662014-05-19T13:02:51.857-07:002014-05-19T13:02:51.857-07:00Hello Venkat Sir
Good Tutorial indeed, but when i ...Hello Venkat Sir<br />Good Tutorial indeed, but when i am updating in the dataset , it is throwing an error as object ref not set to the instance of the object, what could be the possible mistake i am doing.Vikas Salvehttps://www.blogger.com/profile/11997009886674772174noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-38776195973640597582014-01-15T11:21:50.026-08:002014-01-15T11:21:50.026-08:00Hello Venkat,
Thank you for providing these wonder...Hello Venkat,<br />Thank you for providing these wonderful tutorials. They have helped me a lot. I was wondering if you had any plans to include some tutorials regarding subjects such as JavaScript, JQuery, and XML. These topics seem to be very essential to Web Application development, and the hiring managers always ask about them.<br /><br />If you are not planning on making video tutorials about these topics yourself, can you recommend a good source for such video tutorials?<br /><br />Thanks for creating this site, and for all your hard work. It is very much appreciated! You are an excellent instructor.Anonymoushttps://www.blogger.com/profile/06155755657040666430noreply@blogger.com