tag:blogger.com,1999:blog-7805972021499203804.post7322160275044386189..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: Asp.Net MVC Get (Display) Data from Database using ADO.NETSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7805972021499203804.post-11607588022881285902019-07-06T21:26:11.224-07:002019-07-06T21:26:11.224-07:00ME GETTING ERROR IN da.fill(ds)ME GETTING ERROR IN da.fill(ds)Anonymoushttps://www.blogger.com/profile/10236843279916060581noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-26427724937513763452019-02-07T03:01:26.839-08:002019-02-07T03:01:26.839-08:00still get error on this line
da.Fill(ds);
pleas...still get error on this line<br /><br />da.Fill(ds); <br /><br />please helpAnonymoushttps://www.blogger.com/profile/01209899807412774732noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-74522060641916358852018-06-15T04:08:22.445-07:002018-06-15T04:08:22.445-07:00ypanchal10@gmail.comypanchal10@gmail.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-70424720693996756442017-08-30T05:45:33.356-07:002017-08-30T05:45:33.356-07:00Make changes in below procedure like this
Create ...Make changes in below procedure like this<br /><br />Create Procedure usercrudoperations<br />(<br />@name varchar(50)=null,<br />@education varchar(50)=null,<br />@location varchar(50)=null,<br />@status varchar(10)<br />)<br />As<br />BEGIN<br />-- Insert User Details<br />if @status ='INSERT'<br />BEGIN<br />INSERT INTO userdetails(username,education,location)<br />VALUES(@name,@Vishal Yadavhttps://www.blogger.com/profile/16743815450241273624noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-60548429940471259652017-02-25T01:12:36.138-08:002017-02-25T01:12:36.138-08:00here is code :
// GET data from stored procedure... here is code : <br /> // GET data from stored procedure<br /> public ActionResult InsertUserDetails()<br /> {<br /> UserDetails objuser = new UserDetails();<br /> DataSet ds = new DataSet();<br /> using (SqlConnection con = new SqlConnection())<br /> {<br /> using (SqlCommand cmd = new SqlCommand("usercrudoperation&Anonymoushttps://www.blogger.com/profile/02489926766230330437noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-20140553627336015612017-02-25T01:11:00.501-08:002017-02-25T01:11:00.501-08:00Sir , i got a error : An exception of type 'Sy...Sir , i got a error : An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code<br /><br />Additional information: Procedure or function 'usercrudoperation' expects parameter '@username', which was not supplied.<br /><br /><br />in that line : da.Fill(ds);<br /><br />Can you please help me ...!!!Anonymoushttps://www.blogger.com/profile/02489926766230330437noreply@blogger.com