tag:blogger.com,1999:blog-7805972021499203804.post8556195423072902944..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: Asp.net insert, Edit, update, delete data in gridviewSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger252125tag:blogger.com,1999:blog-7805972021499203804.post-18671169515582900142018-05-30T03:00:18.338-07:002018-05-30T03:00:18.338-07:00......Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-6812801752371257332017-09-11T03:56:08.756-07:002017-09-11T03:56:08.756-07:00public partial class _Default : System.Web.UI.Page...public partial class _Default : System.Web.UI.Page<br />{<br /> clsBusinessLayer obj;<br /> UserBO bo = new UserBO();<br /> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> <br /> obj = new clsBusinessLayer();<br /> // if (!IsPostBack)<br /> // {<br /> GridView1.DataSource = obj.LoadCustomer();<br /> GridView1.DataBind();<br Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-38807796550011850612017-08-04T00:02:43.963-07:002017-08-04T00:02:43.963-07:00protected void GridView1_RowEditing(object sender,...protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)<br /> {<br /> GridView1.EditIndex = e.NewEditIndex;<br /> GridView1.DataBind();<br /> }<br /> protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)<br /> {<br /> GridView1.PageIndex = e.NewPageIndex;<br /> //GridView1.DataSource = dt;<br /> Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-22112844436300823662017-08-04T00:00:11.602-07:002017-08-04T00:00:11.602-07:00protected void GridView1_RowDeleting(object sender...protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)<br /> {<br /> obj = new clsBusinessLayer();<br /> Label custid = GridView1.Rows[e.RowIndex].FindControl("Label1") as Label;<br /> //int index = Convert.ToInt32(e.RowIndex);<br /> //int custid = Convert.ToInt16(gvcustomerdetails.Rows[index].Cells[2].Text);<br /> //int Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-91599657306397322482017-08-03T23:56:18.654-07:002017-08-03T23:56:18.654-07:00protected void BindDepartmentdropdown()
{
...protected void BindDepartmentdropdown()<br /> {<br /> //conenction path for database<br /> SqlConnection con = new SqlConnection(@"Data Source=MAYANK-PC\MANKU;Initial Catalog=Career;Integrated Security=True");<br /> con.Open();<br /> SqlCommand cmd = new SqlCommand("select Deptid,Deptname from Department", con);<br /> SqlDataAdapter da = Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-55725307841420340362017-08-03T23:53:15.602-07:002017-08-03T23:53:15.602-07:00protected void Button1_Click(object sender, EventA...protected void Button1_Click(object sender, EventArgs e)<br /> {<br /> //Add<br /> bo.empname = TextBox1.Text;<br /> bo.empdesig = ddldesig.SelectedValue;<br /> bo.empdept = ddlemployee.SelectedValue;<br /> bo.empsalary = TextBox4.Text;<br /> if (HiddenField1.Value == "")<br /> {<br /> obj.AddNewCustomer(bo);<br /> }<Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-54797917118544798502017-08-03T23:49:02.679-07:002017-08-03T23:49:02.679-07:00using System;
using System.Collections.Generic;
us...using System;<br />using System.Collections.Generic;<br />using System.Linq;<br />using System.Web;<br /><br />/// <br />/// Summary description for clsBusinessLayer<br />/// <br />public class clsBusinessLayer<br />{<br /> public clsDataLayer objDataLayer = new clsDataLayer();<br /> public object LoadCustomer()<br /> {<br /> return objDataLayer.LoadCustomerDB();<br /> }<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-84660325796943631592017-08-03T23:35:41.374-07:002017-08-03T23:35:41.374-07:00using System;
using System.Collections.Generic;
us...using System;<br />using System.Collections.Generic;<br />using System.Linq;<br />using System.Web;<br />using System.Data;<br />using System.Data.SqlClient;<br />using System.Configuration;<br /><br />/// <br />/// Summary description for clsDataLayer<br />/// <br />public class clsDataLayer<br />{<br /> private string conn = ConfigurationManager.ConnectionStrings["mythreetier"].Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-21226238475747782582017-03-04T22:16:15.039-08:002017-03-04T22:16:15.039-08:00Sir this tutorial is very helpful for me. Can I ha...Sir this tutorial is very helpful for me. Can I have questionbank database for online examAnonymoushttps://www.blogger.com/profile/06449934688500245015noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-44578474187907188262017-03-04T22:13:20.785-08:002017-03-04T22:13:20.785-08:00Sir this tutorial is very helpful.Sir can you help...Sir this tutorial is very helpful.Sir can you help me to create database for online exam.I need questionbank database.Please help meAnonymoushttps://www.blogger.com/profile/06449934688500245015noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-35104972862548099262016-04-06T03:42:43.895-07:002016-04-06T03:42:43.895-07:00Hello sir,really its very easy to learn through yo...Hello sir,really its very easy to learn through your code Thank youAnonymoushttps://www.blogger.com/profile/07239377822177357100noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-36897217050951487262016-02-20T04:01:16.806-08:002016-02-20T04:01:16.806-08:00from the multiple textboxes(name, city, state) i l...from the multiple textboxes(name, city, state) i like to search the data from the same row...<br />in my code it gives the data from the other rows as well in the gridview..<br />please helpAnonymoushttps://www.blogger.com/profile/15594315091211166311noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-58179402689605041202016-02-20T04:01:15.494-08:002016-02-20T04:01:15.494-08:00from the multiple textboxes(name, city, state) i l...from the multiple textboxes(name, city, state) i like to search the data from the same row...<br />in my code it gives the data from the other rows as well in the gridview..<br />please helpAnonymoushttps://www.blogger.com/profile/15594315091211166311noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-75880426404682548882015-12-12T20:22:09.407-08:002015-12-12T20:22:09.407-08:00try this..
string username=Convert.ToString(gvDeta...try this..<br />string username=Convert.ToString(gvDetails.DataKeys[e.RowIndex].Values["UserName"]);Chetan_Winterhttps://www.blogger.com/profile/18143283314411723836noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-9672061949988491552015-12-08T11:47:52.109-08:002015-12-08T11:47:52.109-08:00hello sir getting an exceptional error while delet...hello sir getting an exceptional error while delete or update any row "input string was not in correct format" in line string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString();<br /><br /><br />is it because of i didnt declare any primary key in table and all defined allow null?<br /><br />please specify !!<br />Anonymoushttps://www.blogger.com/profile/16164439312555189962noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-16194951240283645922015-11-28T23:56:34.466-08:002015-11-28T23:56:34.466-08:00hey guys..try the above code for insertion...hey guys..try the above code for insertion...Chetan_Winterhttps://www.blogger.com/profile/18143283314411723836noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-70518167779851461672015-11-28T23:52:47.660-08:002015-11-28T23:52:47.660-08:00else
{
con.Ope...else<br /> {<br /> con.Open();<br /><br /> SqlCommand cmd = new SqlCommand("insert into book_details(Book_Name,Author,Published_Date,Type,Cover_Picture,Kind,Rating)values(@Book_Name,@Author,@Published_Date,@Type,@Cover_Picture,@Kind,@Rating)", con);<br /> cmd.Parameters.AddWithValue("@Book_Name", TextBox2.Chetan_Winterhttps://www.blogger.com/profile/18143283314411723836noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-63031221441419365292015-11-28T23:47:17.954-08:002015-11-28T23:47:17.954-08:00else if (RadioButtonList1.Text == "K2" &... else if (RadioButtonList1.Text == "K2" && CheckBoxList1.Text == "R2")<br /> {<br /> con.Open();<br /><br /> SqlCommand cmd = new SqlCommand("insert into book_details(Book_Name,Author,Published_Date,Type,Cover_Picture,Kind,Rating)values(@Book_Name,@Author,@Published_Date,@Type,@Cover_Picture,@KindChetan_Winterhttps://www.blogger.com/profile/18143283314411723836noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-16766981174457477362015-11-28T23:38:02.609-08:002015-11-28T23:38:02.609-08:00if (FileUpload1.HasFile)
{
str...if (FileUpload1.HasFile)<br /> {<br /> string Extension = Path.GetExtension(FileUpload1.FileName);<br /> if (Extension.ToLower() != ".gif" && Extension.ToLower() != ".png" && Extension.ToLower() != ".jpg" && Extension.ToLower() != ".jpeg")<br /> {<br /> Chetan_Winterhttps://www.blogger.com/profile/18143283314411723836noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-18353214601938171922015-11-28T23:38:00.651-08:002015-11-28T23:38:00.651-08:00if (FileUpload1.HasFile)
{
str...if (FileUpload1.HasFile)<br /> {<br /> string Extension = Path.GetExtension(FileUpload1.FileName);<br /> if (Extension.ToLower() != ".gif" && Extension.ToLower() != ".png" && Extension.ToLower() != ".jpg" && Extension.ToLower() != ".jpeg")<br /> {<br /> Chetan_Winterhttps://www.blogger.com/profile/18143283314411723836noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-48854952290335989332015-11-28T23:29:34.365-08:002015-11-28T23:29:34.365-08:00hi..hi..Chetan_Winterhttps://www.blogger.com/profile/18143283314411723836noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-72250355720450995022015-11-05T00:57:52.386-08:002015-11-05T00:57:52.386-08:00Thanx for your code...it helped..!!!Thanx for your code...it helped..!!!Radhikanoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-79063385218404841762015-10-16T20:59:05.694-07:002015-10-16T20:59:05.694-07:00in your program in the row updating coding what is...in your program in the row updating coding what is the "txtcity"? where can set that property in gridview..Technologies for Web Developmenthttps://www.blogger.com/profile/04236228690967803632noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-4693393675130152112015-10-16T20:59:03.732-07:002015-10-16T20:59:03.732-07:00in your program in the row updating coding what is...in your program in the row updating coding what is the "txtcity"? where can set that property in gridview..Technologies for Web Developmenthttps://www.blogger.com/profile/04236228690967803632noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-67615378912168950302015-08-02T23:10:52.457-07:002015-08-02T23:10:52.457-07:00Dear Suresh
Whenever i create the database ,i got ...Dear Suresh<br />Whenever i create the database ,i got a error like that incorrect syntax near the keyword 'set'<br />create table Employee_Details<br />(<br />UserId Int(set identity property=true),<br />Username varchar(100),<br />City varchar(50),<br />Designation varchar(100)<br />)<br />Please solve this and mail me -rajesh.sahoo14@gmail.comRAJESH KUMAR SAHOOhttps://www.blogger.com/profile/14371293180997733572noreply@blogger.com