Then do as for as its Info, you can able to login. let me know if error comes after that

perhaps application pool is supported on iis 6.0 while i am using iis 5.1. i have done one more thing start -> programs -> visual studion 2005 -> visual studion tools than type the command aspnet_regiis -i for reparing iis

This code useful for u.. firstly add tag in web config After then Pro = ConfigurationManager.AppSettings["ConnectionStrings"].ToString(); MyPath = ConfigurationManager.AppSettings["dbfile"].ToString(); Conns = String.Format(Pro, HttpContext.Current.Server.MapPath(MyPath)); con = new OleDbConnection(Conns); con.Open(); string st = "Madhaya Pradesh"; string qql = "INSERT into Registration(UniqueID,Name,FName,DOB,TMarks,OMarks,PMarks,PClass,PLine,Board,District,Division,Category,Sex,PChallange,Address,Pin,RDistrict,State,Phone,SchoolAddress,SchoolPincode,SchoolDistrict) values('" + lbluniquid.Text + "','" + txtname.Text + "','" + txtfathername.Text + "','" + tbMyDate.Text + "'," + txttotalmarks.Text + "," + txtobtainmarks.Text + "," + p + ",'" + rdpresent.SelectedItem.Text + "','" + rdpovertyline.SelectedItem.Text + "','" + rdboard.SelectedItem.Text + "','" + ddldistrict.SelectedItem.Text + "','" + lbldivision.Text + "','" + rdcategory.SelectedItem.Text + "','" + rdsex.SelectedItem.Text + "','" + rdphysically.SelectedItem.Text + "','" + txtaddress.Text + "','" + txtpincode.Text + "','" + ddldistrict1.SelectedItem.Text + "','" + st + "','" + txtcontact.Text + "','"+ txtschooladdress.Text +"','"+ txtschoolpincode.Text +"','"+ ddldistrict2.SelectedItem.Text +"')"; cmd = new OleDbCommand(qql, con); int res; res = cmd.ExecuteNonQuery(); res = 1; con.Close();

you posted your question again. Please post some more detailed error with Stack trace. Repeating the same question wont help. Education is not a way to escape poverty — it is a way of fighting it.

no i m not using session. i have post the code it was working till morning now its giving error

This is hard to understand. You should perhaps post some sample data to make sure we understand you. Are you asking how the UI should look, asking about the SQL, or what ? Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

prateekfgiet wrote: but it will give error how i'll do if prod2 contain null or 0 value then label28.visible=false; Don't call the ToString() before doing a NULL check. Do something like if (dr["prod2"] != null) { string prod2 = dr["prod2"].ToString(); Label28.Visible = !(prod2 == "0"); Label28.Text = prod2; } :) Navaneeth How to use google | Ask smart questions

You might wanna go through these videos... learn from videos[^]

You have to check your input data. I think if you read a design pattern you can do this on better way. Say! your code is really horrible to understand. You have to try to use classes and generic collections if you want to manage your code. But if you check your input data, you can find the wrong input data type or data length. Good luck!!!

ok thanks a lot for the help

plz post your code with your server controls !

Name of parameter should be "pname" not a "ProductName". <asp:Parameter Type="string" Name="ProductName"></asp:Parameter> <asp:Parameter Type="string" Name="pname"></asp:Parameter> A DATAPOST COMPUTER CENTRE (K.V Prajapati)

Post you server code also

Environment.NewLine Change your code like this msg.Body = "Status is : '" + DropDownList3.SelectedValue.ToString + "<br>', for the Request of RMA No:'" + DropDownList1.SelectedValue.ToString() + "'";

ok thanks now its working

Check out this post http://social.msdn.microsoft.com/forums/en-US/netfxnetcom/thread/26745216-962b-47db-bf13-4f2b159731ba/[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips The woods are lovely, dark and deep, But I have promises to keep, And miles to go before I sleep, And miles to go before I sleep!

hey i have a solution!!!!!!!! Just save the values in Temporary datatable and after that run that temporary datatable in a loop and write the insert in it..... private void SaveGridDataInTempTable() { DataTable dtTemp = new DataTable(); if (dtTemp == null || dtTemp.Columns.Count <= 0) { dtTemp.Columns.Add("sino"); dtTemp.Columns.Add("name", typeof(String)); dtTemp.Columns.Add("gender", typeof(String)); dtTemp.Columns.Add("qualification", typeof(String)); dtTemp.PrimaryKey = new DataColumn[] { dtTemp.Columns["sino"] }; } foreach (GridViewRow gvRow in GridView1.Rows) { DataRow drTemp = dtTemp.NewRow(); drTemp["sino"] = int.Parse(GridView1.DataKeys[gvRow.RowIndex]["sino"].ToString()); drTemp["name"] = ((TextBox)gvRow.FindControl("TextBox1")).Text.Trim(); drTemp["gender"] = ((RadioButtonList)gvRow.FindControl("RadioButtonList1")).SelectedValue.ToString(); drTemp["qualification"] = ((DropDownList)gvRow.FindControl("DropDownList1")).SelectedValue.ToString(); dtTemp.Rows.Add(drTemp); } Temp = dtTemp; } //Property to maintain the Datatable public DataTable Temp { get { object o = ViewState["Temp"]; if (o == null) { DataTable dt = new DataTable(); return dt; } else return (DataTable)o; } set { ViewState["Temp"] = value; } } After this your normal insert code, for(int i=0;i

Hi, What i think the problem is in the place where you refer to your control using Cells[index].Controls[1] and there would have been only one control and that too at position [0] not [1]. So try using the code like this as you do know the name of the control which you want to fetch using the code for updation purpose. protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { //fetch datakey/primarykey for identifyning the row string materialrecipt_no = Convert.ToString(GridView1.DataKeys[e.RowIndex].Value); TextBox materialrecip_date = (TextBox)GridView1.Rows[e.RowIndex].FindControl("ControlName"); TextBox pqty = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("ControlName")); TextBox enterby = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("ControlName")); TextBox ptype = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("ControlName")); TextBox remark = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("ControlName")); SqlCommand com = new SqlCommand("update material_incoming set materialrecip_date='" + materialrecip_date.Text + "',pqty='" + pqty.Text + "',enterby='" + enterby.Text + "',ptype='" + ptype.Text + "',remark='" + remark.Text + "' where materialrecipt_no=" + materialrecipt_no + "", conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); GridView1.EditIndex = -1; //to go back to the previous position // fetch and rebind the data. BindGrid(); } Please mark as answer if problem gets resolved. Regards, Kaushal Arora