|
i have bind the gridview through the data set
the dataset contans the boolen values so automatical it taks the Checkbox control
now i wnat to retryiving the data from gridviw
if checkbox is checked then i need check box value
here i give the my coding
here on page load
i get the data and
bind the grid view
protected void Page_Load(object sender, EventArgs e)
{
string connString = WebConfigurationManager.ConnectionStrings ["ServerConnectionString1"].ConnectionString;
SqlDataAdapter conadapuser = new SqlDataAdapter("SSTABEG", connString);
DataSet userdateset = new DataSet();
conadapuser.Fill(userdateset);
int rescount = userdateset.Tables[0].Rows.Count;
int colcount = userdateset.Tables[0].Columns.Count;
//trueval = bool.Parse(bool.TrueString);
DataTable dt = new DataTable();
for (int i = 0; i < userdateset.Tables[0].Columns.Count; i++)
{
DataColumn dc = new DataColumn();
if (i > 0)
{
dc.Caption = userdateset.Tables[0].Columns[i].Caption;
dc.DataType = System.Type.GetType("System.Boolean");
dc.ColumnName = userdateset.Tables[0].Columns[i].ColumnName;
}
else
{
dc.Caption = userdateset.Tables[0].Columns[i].Caption;
dc.DataType = userdateset.Tables[0].Columns[i].DataType;
dc.ColumnName = userdateset.Tables[0].Columns[i].ColumnName;
}
dt.Columns.Add(dc);
}
for (int row = 0; row < userdateset.Tables[0].Rows.Count;row++ )
{
DataRow drow=dt.NewRow();
for (int col = 0; col < userdateset.Tables[0].Columns.Count; col++)
{
if (col > 0)
{
if (userdateset.Tables[0].Rows[row][col].ToString() != "1")
{
drow[col] = false;
}
else
{
drow[col] = true;
}
}
else
{
drow[col] = userdateset.Tables[0].Rows[row].ItemArray[col].ToString();
}
}
dt.Rows.Add(drow);
}
GridView1.DataSource = dt; //userdateset;
GridView1.DataBind();
}
HERE I ENABLE THE CHECK BOX CONTROL
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
for (int i = 1; i < e.Row.Cells.Count;i++)
{
if (e.Row.Cells[i].Controls[0].GetType().FullName == "System.Web.UI.WebControls.CheckBox")
((CheckBox)e.Row.Cells[i].Controls[0]).Enabled = true;
}
}
}
IF I CLICK THE BUTTON
I WANT SAVE THE ALL DATA OF GRID
HOW CAN I RETIVE TEH DATA FROM THE GRIIEDVIEW CONTROL
protected void Button1_Click1(object sender, EventArgs e)
{
IN THE EVENT I NEED TO GET THE ALL DATA FROM GRIED VIEW(GRIED VIEW CONTAINS THE ALL CHECKBOX FIELDS
}
mohamad rafi
|
|
|
|
|
Here I had a Dropdnlist and i need to extract the datavaluefield from the list and i have to insert in some other table.My code is...
Dim dt As SqlCommand
dt = New SqlCommand("Select CustomerId,CustName from Customer", dbconn)
sedr2 = dt.ExecuteReader()
ctList.DataSource = sedr2
ctList.DataTextField = "CustName"
ctList.DataValueField = "CustomerId"
ctList.DataBind()
cmdins = "Insert into Dept(CustomerId,Deptname)values(" &dtlist.DataValueField& ",'"& TxtBox1.text&"')
This is not giving any eror,but no CustomerId value is inserting into the Table,where i have to close the datareader,and how to retrive the customerid value for insertion.Help me.Thanks in advance.
kissy
|
|
|
|
|
You can access the value of selected item like this:
DropDownList1.SelectedItem.Value.ToString()
Best Regards,
Apurva Kaushal
|
|
|
|
|
But it is not taking the value.It is taking by defult the first Listitem value,not the selected one.what is the wrong?
Dim dtsl As SqlCommand = New SqlCommand("Select CustomerId from Customer where CustName='" & DtList.SelectedItem.Value.ToString() & "'", dbconn)
Dim custid As Integer = dtsl.ExecuteScalar()
And i am trying to insert this custid in the insert command.whats the wrong,I tried the same before,but not working.It is taknig by defult first listitem value as 1.
kissy
|
|
|
|
|
Check the code where you are binding the dropdownlist, it should be under if(!page.IspostBack) condition.
Best Regards,
Apurva Kaushal
|
|
|
|
|
It is like that only.But still the same problem is occuring.Is there any
Dim ctid As SqlCommand = New SqlCommand("Select CustomerId from Customer where CustName='" & ctList.SelectedItem.Text & "'", dbconn)
Dim custid As Integer = ctsl.ExecuteScalar()
This is also not working.It is taking by default value.Wats the wrong.It is simple but not working.
Am i need to change anywhere??
kissy
|
|
|
|
|
Actually what I have understood is you are binding the dropdownlist control in page load event, am I right? And then in some other event you are trying to catch the selected value of the dropdownlist control. is it so?
You just check the code for is post back because what could be a reason is that you dropdownlist control would be getting bind again prior to get the selected value. 
Best Regards,
Apurva Kaushal
|
|
|
|
|
ya ur gussing is correct,I have given the code as Aldobe given in the pageload event.I am tring to insert values in the other event.All are correct.
I am closeing the datareader in pageload (IF !page is postback).
How to get tthe exact value.Why it is not taking selectedItems's vlaue.
kissy
|
|
|
|
|
Dim dt As SqlCommand<br />
dt = New SqlCommand("Select CustomerId,CustName from Customer", dbconn)<br />
sedr2 = dt.ExecuteReader()<br />
<br />
If(Not Page.IsPostBack) Then<br />
ctList.DataSource = sedr2<br />
ctList.DataTextField = "CustName"<br />
ctList.DataValueField = "CustomerId"<br />
ctList.DataBind()<br />
End If
(sorry if i have any syntax error on vb.net code cuz i'm C# prog.)
|
|
|
|
|
I have given the same code in pageload.
but how to retrieve in my insert query to insert the DataValueField.
THis is my doubt.
kissy
|
|
|
|
|
|
It is giving an error as you should enter a constants,varibles or expressions.It should not take 'Name' ('Name' is customerName)in this context.
So how to use this expression.
kissy
|
|
|
|
|
Dude can u post more ur code ???
|
|
|
|
|
U can see my first Message.That is in my Button event.
And ur first code is in my pageload.
Got my point,Simple but nnot working.
Thanks.
kissy
|
|
|
|
|
Here comes the problem the code what you have given in the first message then that means is you are again binding that drop down list in that event and after that you are trying to get the selected value. How will it happen.  Remove the binding code from there.
Best Regards,
Apurva Kaushal
|
|
|
|
|
This is my code when pageload
Dim dt As SqlCommand
dt = New SqlCommand("Select CustomerId,CustName from Customer", dbconn)
sedr2 = dt.ExecuteReader()
ctList.DataSource = sedr2
ctList.DataTextField = "CustName"
ctList.DataValueField = "CustomerId"
ctList.DataBind()
In Button event ,my code is
issert into Dept(custId,dname)values(" & ctlist.selectedValue&",'"&txtbox1.text&"').
But the value is not coming into the selectedvalue.I have given the code correctly.try to Understand and solve it.whhat exactly i have to give for retrieving the respcted Datavaluefield into my 'cutsid'.
kissy
|
|
|
|
|
Dim dt As SqlCommand<br />
dt = New SqlCommand("Select CustomerId,CustName from Customer", dbconn)<br />
sedr2 = dt.ExecuteReader()<br />
If Not Page.IsPostBack Then<br />
ctList.DataSource = sedr2<br />
ctList.DataTextField = "CustName"<br />
ctList.DataValueField = "CustomerId"<br />
ctList.DataBind()<br />
End If<br />
<br />
insert into Dept(custId,dname)values('" & ctlist.selectedValue&"','"&txtbox1.text&"')
this code doesn't return selected value of ctlist??? (amazing)
or do u bind ctlist in any other event(s)????
|
|
|
|
|
No this is only mycode where i am using Dtlist.All other is not related with this.i am still trying,ok if u get any answer send me please.thank you.
binding is at pageload,and only insertion is at button clik event.
Give me a solution.
kissy
|
|
|
|
|
my problem was solved,thanks for ur cooperation.
kissy
|
|
|
|
|
I'm glad...
Where were problem???
|
|
|
|
|
|
In code which he used to get selectedvalue was good but he said that it returns only first value and i'm curiosity to know how did he solved problem???
|
|
|
|
|
yes exactly I too have the perception that the code was correct. My initial thought was Page.IsPostBack prolem, but as he said it was not. That is why I too am curious to know about the problem.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Apurva Kaushal wrote: My initial thought was Page.IsPostBack
And mine suggest was too
on If Not Page.IsPostBack Then ...
but maybe he refill dropdownlist and called DataBind method in another event and it have returnde first item by default
so waiting it is kassy's turn to answer on our question
|
|
|
|
|
That was only thing which will come in anybody's mind. 
albCode wrote: so waiting it is kassy's turn to answer on our question
Seems he is in party mood after getting the solution.
Best Regards,
Apurva Kaushal
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
