How to present a perfect gridview report in asp.net

Question

I am new to asp.net ,i created a registration form using controls like textbox,radiobuttonlist,checkboxlist,dropdownlist ,,fine i sucessfully inserted a record . i want to displa a records in gridview like im inserted a name using textbox ,so i display name in label or text box .now i need while editing a record im creatd a gender using radiobuttonlist while editing a record i want radiobuttonlist with records

siva nathan · Answer

DataSourceID="SqlDataSource1" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating"> '> '> '> '>'> '> '>'> '>'> '> '>'> Single Married '>'> -Select- B.SC M.SC B.E BCA " ProviderName=" " SelectCommand="SELECT * FROM [RegForm]">

siva nathan · Answer

this is my design code while clicking a submit button name,email,phone values are assigning correctly ,but radiobuttonlist,checkboxlist and dropdownlist cannot be assigning why pls make a code as workable --------- DataSourceID="SqlDataSource1" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating"> '> '> '> '>'> '> '>'> '>'> '> '>'> '>'> " ProviderName=" " SelectCommand="SELECT * FROM [RegForm]"> ----------- C# code { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { gvbind(); } } protected void gvbind() { con.Open(); string Query1 = string.Format("Exec LoadEmployye"); SqlDataAdapter da = new SqlDataAdapter(Query1,con); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); if (ds.Tables[0].Rows.Count > 0) { GridView1.DataSourceID = null; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; gvbind(); } } sql----- ALTER Proc [dbo].[LoadEmployye] AS Begin select Id,Name,Email,case when Gender=0 then 'Male'else 'Female' end as Gender,Phone, case when [Status]=0 then 'Single' else 'Married' end as [Status], case when Education=1 then 'B.SC' when Education=2 then 'M.SC' when Education=3 then 'B.E' when Education=4 then 'BCA' end as Education,[Address] from RegForm End

siva nathan · Answer

while edit mode the gridview is not taking the correct value of bind... can u pls come with teamviewer ramesh....

siva nathan · Answer

can u explain this code , protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { DataRowView drv = e.Row.DataItem as DataRowView; if (e.Row.RowType == DataControlRowType.DataRow) { if ((e.Row.RowState & DataControlRowState.Edit) > 0) { DropDownList dp = (DropDownList)e.Row.FindControl("Education"); DataTable dt = load_department(); for (int i = 0; i { ListItem lt = new ListItem(); lt.Text = dt.Rows[i][0].ToString(); dp.Items.Add(lt); } dp.SelectedValue = drv[6].ToString(); RadioButtonList rbtnl = (RadioButtonList)e.Row.FindControl("rbEditGender"); rbtnl.SelectedValue = drv[3].ToString(); CheckBoxList chkb = (CheckBoxList)e.Row.FindControl("CheckBoxList1"); chkb.SelectedValue = drv[5].ToString(); } } }

siva nathan · Answer

ramesh are you there?

siva nathan · Answer

can u come with teamviewer ramesh

siva nathan · Answer

id:674 847 620 pwd:6922

Ramesh Palanivel · Answer

Hi Siva, Share your team viewer details,

Ramesh Palanivel · Answer

Hi Siva, Can you share your code?

siva nathan · Answer

can u connect again same id but pwd:5069

Ramesh Palanivel · Answer

Hi Siva, Is your team viewer is connecting, I am not able to connect

siva nathan · Answer

id:674 847 620 pwd:5847

Ramesh Palanivel · Answer

Hi Siva, Share your team viewer details

siva nathan · Answer

while clicking edit button the value of radio button ,checkbox and dropdownlist's are not assigning correctly why

Ramesh Palanivel · Answer

HI siva, Can you add some screen shots?

siva nathan · Answer

yes,ramesh i need ur help while edit mode the gridview is not taking the correct value of bind

Ramesh Palanivel · Answer

Hi SIvanathan, Is that issue still occuring? or new issue? Kindly share some screen shots

siva nathan · Answer

ramesh,i need your help how to retry values while editing in asp.net grid? while clicking edit button

How to present a perfect gridview report in asp.net

Answers (18)