i am using gridview where it fetches datas from sqldatasource, i want to made some calculations wit some fields from tables and then need to show in gridview. How to fetch single column values from sqldatasource. I only know this code which are used after displayed in gridview
Gridview1.Row.Cells[0].text.toString()
[code]....
I am having Table called Interest and has only one column named Answer...
i want the checked values to insert in database..If i select Family, News and Fashion... The inserted data should be in Three rows of answer field..
i use this to select one checkbox to isselected column how i convert this to multi checkboxlist to single column i use many ways more than 3 days without success
private void BindCheckBoxList()
{
DataTable dt = new DataTable();
SqlConnection connection = new SqlConnection(GetConnectionString());
try
{
connection.Open();
string sqlStatement = "SELECT * FROM boby";
SqlCommand sqlCmd = new SqlCommand(sqlStatement, connection);
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
sqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
CheckBoxList1.RepeatColumns = 4; // set the number of columns in the CheckBoxList
CheckBoxList1.DataSource = dt;
CheckBoxList1.DataTextField = "Name"; // the items to be displayed in the list items
CheckBoxList1.DataValueField = "Name"; // the id of the items displayed
CheckBoxList1.DataBind();
//Setting the Selected Items in the ChecBoxList based from the value in the database
//to do this, lets iterate to each items in the list
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(dt.Rows[i]["IsSelected"].ToString()))
{
CheckBoxList1.Items[i].Selected = Convert.ToBoolean(dt.Rows[i]["IsSelected"]);
}
}
}
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Fetch Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
connection.Close();
}
}
private void Update(string name, bool isSelected)
{
SqlConnection connection = new SqlConnection(GetConnectionString());
SqlCommand cmd;
string sqlStatement = string.Empty;
try
{
connection.Open();
sqlStatement = "UPDATE handymen SET IsSelected = @IsSelected WHERE Name = @BizName";
cmd = new SqlCommand(sqlStatement, connection);
cmd.Parameters.AddWithValue("@Name", name);
cmd.Parameters.AddWithValue("@IsSelected", isSelected);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Insert/Update error";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
connection.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindCheckBoxList();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string str = string.Empty;
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
str = CheckBoxList1.Items[i].Text;
Update(str, CheckBoxList1.Items[i].Selected);
}
}
//ReBind the List to retain the selected items on postbacks
BindCheckBoxList();
}
I have a stored procedure that returns 3 tables within the single recordset it returns. If I set a SqlDataSource to get data from this procedure, it works, but it only returns the first table. I want to have a GridView display the data from the 2nd or 3rd table using a SqlDataSource, but I can't figure out how to specify a particular table.
While there are some posts discussing this out there, I can't get a definitive answer about whether or not this is even possible (?). In a worst-case scenario, I can create another SP that only returns the 3rd table - but that creates a little maintenance headache that I would prefer to avoid.
i have a form with several checkboxes....i want to insert the selected checkbox values in to a single column in the sql database..
View 4 RepliesSo I found an example on how to search gridview using filterexpressions on this site (Filter GridView with TextBox using FilterExpression in SqlDataSource in ASP.Net), but now if I try to search with an apostrophe in the textbox, the code fails.
Here's the link to the the article/source - [URL] .....
How do I bind data from an Excel file named Book1.xlsx in Column A to a dropdownlist? I've tried like this:
Code:
connExcel.Open()
cmdExcel.CommandText = "SELECT distinct BCName From [Sheet1$] where BCName <> '' and ProjectName like 'Total%';"
oda.SelectCommand = cmdExcel
oda.Fill(dt2)
connExcel.Close()
dropdown1.DataSource = dt2
dropdown1.DataBind()
But the dropdown is filled with "System.Data.DataRowView" for all the 5 lines in the dropdown. How do I get the values shown instead of this? It must be some formatting of dt2 I think.
I am trying to populate the values of multiple rows in single row in gridview using c sharp in rowdatabound section of code behind page like:
Col1 Col6
a 1
a 2
a 3
a 4
I have changed this to
Col1 Col6
a 1
2
3
4
Now I want to achieve this?
Col1 Col6
a 1 2 3 4
What wrong with the code below?
if (e.Row.Cells[0].Text == "" && e.Row.Cells[5].Text != "")
{
for (int a = 0; a<GridView1.Rows.Count; a++)
{
string s = GridView1.Rows[a].Cells[5].Text;
GridView1.Rows[e.Row.RowIndex - 1].Cells[5].Text += s;
}
}
What mistake I am making?
Cell[0] is Col1
Cell[5] is Col6
I have a GridView and a linqdatasource. The GridView is editable and when the user clicks to edit a row I want to concatenate two of the fields in the linqdatasource and place it in a single textbox.
I tried something like:
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Field1") %> - <%# Bind("Field2") %>'></asp:TextBox>
I am creating a Data Tabel in code behind and binding it to Gridview. I am trying to format by creating new line in a single column. Here is the code:
row("Employee Name") = empName + ("<br/>" + empTitle
GridView1.DataSource = myDataTable
GridView1.DataBind()
in a data table contains columns such as id,firstname,lastname.then i will bind into grid view.
now i want to design the gridview like this,
<asp:BoundField HeaderText="Employee Code" DataField="id" />
<asp:BoundField HeaderText="Employee Name" DataField="FirstName"+""++ "MiddleName" />
how can i achieve it?
I have a requirement to create multiple hyperlinks dynamically in a single GridView Column. The number of hyperlinks are not not known in advance and will depend on the results brought up by a query. How do I create the same?
View 4 RepliesSelect tbl_name.name,tbl_midname.midname,tbl_last.lastname As name
From tbl_name
inner join tbl_midname on tbl_midname.id=tbl_name.id
inner join tbl_last on tbl_last.id=tbl_name.id
where tbl_name.id='1'
name mid name last name
Pavan Kumar Roy
How to bind all 3 column data in on column.
I need this result
Pavan Kumar Roy
I have a gridview with textbox and that textbox is for searching. My question is do you know how to search with all fields in gridview.For example: I have a gridview contains, FIRST NAME, MIDDLE NAME, and LAST NAME, and if I type in the textbox the gridview will automatically get what I've inout in textbox.
View 1 RepliesI placed an Excel image in a header column on a Gridview. I want to allow the user the ability to click the icon and export the content of the Gridview to an Excel spreadsheet. How do I make the image an active link, so it will fire an event to access my code for the export.
Code:
<Columns>
<asp:TemplateField ItemStyle-Width="85" ItemStyle-Wrap="False" HeaderImageUrl="~/Images/excel.png" HeaderText="Export" >
I would like to transform the data in the column into hyper link. Let's say if i have "apple" in my column , when clicked on it i wud like it to go to "microsoft.com/apple".
My current gridview code looks like this ....
<asp:TemplateField HeaderText="Status">
<EditItemTemplate>
<asp:TextBox ID="txtStatus" runat="server" Text='<%# Bind("Status") %>' Width="60" Font-Size="8" Font-Names="tahoma" ></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label12" runat="server" Text='<%# Bind("Status") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
On update the dropdown value shows NULL in database : here's structure for my gridview
<asp:TemplateField HeaderText="Construction Phase" SortExpression="Phase_Name">
<EditItemTemplate>
<asp:DropDownList ID="EditedDropDownInGrid" runat="server" CssClass="form-control" DataSourceID="PhaseSQLDataSource" DataTextField="pp_name" DataValueField="pp_id">
</asp:DropDownList>
</EditItemTemplate>
[Code] ....
It updates other controls in gridview but does not update my selected dropdowns item value in Integer format which is inside gridview...
Currently I have a grid view with few rows of data & edit and update for each row but I want it to be done on a single click with w external edit & save button how can the functionality be performed.
View 1 RepliesI have one filed that is encrypted using Rajindal algorithm and stored in MSSQL db.When I retrieve that column in gridview it's displayed in encrypted. I have the code that decrypts it but the problem is:How can I all loop throw this column values in the gridview and decrypt them all and display it in the gridview decrypted.See my code below:
[Code]....
I need to get one record from rows. For example:
DB:
id, name, age, nick, gender , etc...
1, John, 18, gobb, M, ....
2, Andrew, 22 , AND, M, .....
3, Simon, 35, Lucky, M, ......
How to Get name (For example Simon) from DB and enter it into label? Or perhaps this is impossible?
[Code]....
View 2 Repliesdisplay comma separated database values in a gridview? I'm not sure if I should handle this in a stored procedure or VB.net. I have a bunch of values stored in a checkbox list and the following database design: Each column datatype is a bit.
Val1 Val2 Val3 Val4
a b c d
I need something like this to be displayed in the gridview: a,b,c - depending on what values are set to 1 in the database.
I read some articles before posting to try and solve my issue but i didn't get anywhere,
Here is what i'm trying to do:
1) I have an excel sheet with 1 EntrantID column and the rest are numbers (these numbers refer to answer codes for certain questions),
So for example, my excel sheet looks something like:
ID --- a1 --- a2 --- a3 --- a4 --- a5 --- etc...
1 ---- 32 --- 55 --- 12 --- 121 -- 50---etc...
The goal is to traverse thru every row, and every column and according to a checking condition for the values of answers, i will add the number to one of two columns in another table, so for example, i will start traversing a1, i will check it's value which is 32, if 32 > 0 and 32 < 60, then i will add 32 to columnA in another table, else, i will add it to column B in that table, then i will move on to the next value, a2 which is 55, it's < 60 so i will 'add' it to that same columnA in that table..
At the end, my other table, the one with results should look like this:
PersonID --- columnA --- columnB
1 ------------ 32, 55, 12 --- 121, 50
Hope i didn't confuse things, i'm trying to explain as best as i can lol.
So what i did, i imported the excel sheet to sql server, and i looked up SQL language to see if i can do that thru SQL itself, and i couldn't find a way to traverse columns, so next, i started an ASP.NET project, connected to the DB and i drag/dropped the table in my page as a GridView, where i'm trying to traverse it so i can get the values, check them against the range, and insert them in relative column.
I tried something like this:
DataTable dt = new DataTable();
dt = (DataTable)GridView1.DataSource;
DataTable temp = new DataTable("MyTable");
for (int i=0; i < dt.Rows.Count-1; i++)
for (int k = 0; k < dt.Columns.Count-1; k++)
if ((int)dt.Rows[i][k] > 0 && (int)dt.Rows[i][k] < 50)
temp.Rows[i][k] = dt.Rows[i][k];
That is not working, and i'm unable to do it. basically, i don't know how to fetch the value inside each [row][column], and overall i don't know how i can do the required task.
I have a parts table (ID, PartName, Category). I have an Engine table that has 10 columns to specify the 10 main parts that comprise the engine (EngineID, PartA_ID, PartB_ID, PartC_ID...).
I want to make only one trip to the DB to pull all the rows, then filter by category for each PartA, PartB, etc ddl. how to do this?
I'm attempting to hook up multiple DropDownLists to a single SQLDataSource, but I want the SQLDataSource to return different rows depending on which DropDownList it is populating.
Say I have a table full of names (we'll call it TABLE_NAMES):
[code]....
....and I have two dropdown lists, one with a list of person names and one with a list of dog names.
Is there a way to link up each of these dropdown lists to a single SQLDataSource and use the SelectParameter to differentiate between which records I want returned for each dropdown list?
To make matters worse, these dropdown lists will appear within a GridView control....so there will be multiple instances of each dropdown list depending on how many rows there are in the GridView.
