C# - Populate The Values Of Multiple Rows In Single Row In Gridview?
Mar 28, 2011
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
View 1 Replies
Similar Messages:
Jun 16, 2015
how can we update all rows without click on update link button,
or can we update all rows of gridview on click single "update" button instead of mutiple for everey row
View 1 Replies
Dec 23, 2015
Is there any chance to add more than one grid row in single grid row like this.
<h1> Question</h1>
<table width="100%">
<tr style="background-color:Gray; color:White;">
<td> Name
</td> <td> Product
[Code] .....
View 1 Replies
May 25, 2012
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 Replies
Mar 4, 2011
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?
View 2 Replies
Mar 8, 2011
I've a table where one person teaches multiple classes. It looks like this.
Table1
Id Name Class Subject
----------------------------------------
2 Sam 12 English
2 Sam 10 Maths
2 Sam 10 English
2 Sam 8 History
2 Sam 12 Economics
Here Sam teaches Class 12 - English & Economics, Class 10 - Maths & English, Class 8 - History
I want to display the result like this -
Id Name Class Subject
---------------------------------------------------------------
2 Sam 12 English, Economics
2 Sam 10 Maths, English
2 Sam 8 History
How to concatenate multiple Rows?
View 6 Replies
Dec 23, 2015
I have a question which is insert multiple rows in a single insert? Is that possible?
For example:
INSERT INTO EMPLOYEE(NAME, AGE)
VALUES
(JAN, 18),
(JEN, 20),
(JIN, 23)
Using C#
I have code, something like I ask but there's an error.
Here's the code
string sql = "INSERT INTO EMPLOYEE(NAME, AGE) VALUES";
for(int i = 0; i < data.length; i++)
{
sql += "(@name" + i.ToString() ", @age" + i.ToString() + "),"
}
sql = sql.Remove(sql.Length - 1);
cmd = SqlCommand(sql, con);
cmd.ExecuteNonQuery;
I got an error of "Fatal error encountered during command execution."
The error goes here
{"Parameter '@name0' must be defined."}
View 1 Replies
May 12, 2010
I'm trying to use ConfigurationManager.AppSettings.GetValues() to retrieve multiple configuration values for a single key, but I'm always receiving an array of only the last value. My appsettings.config looks like
<add key="mykey" value="A"/>
<add key="mykey" value="B"/>
<add key="mykey" value="C"/>
etValues("mykey");
View 4 Replies
Jan 9, 2011
I am trying to retrieve multiple values from the session variable in which I stored the values as List. Here's the code I applied but this gives me only the lst value from the list in the output.
Array k= yourlist.ToArray();
for (Int32 i = 0; i < k.Length; i++)
{
Int32 x = Convert.ToInt32(k.GetValue(i));
SqlCommand cmd2 = new SqlCommand("select id,name from plugins where id =" + x, con);
SqlDataReader dr2 = cmd2.ExecuteReader();
if (dr2.HasRows)
{
while (dr.Read())
{
ListBox2.DataSource = dr2;
ListBox2.DataBind();
}
}
dr2.Close();
cmd2.Dispose();
}
View 2 Replies
Feb 19, 2010
[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..
View 3 Replies
Jan 29, 2014
I have one database in which student enroll no with his sem is stored . I want that if i enter stud enroll no then in dropdown list all the sem related to that stud should come. My database
Stud enroll no sem1 sem2 sem3 sem4
1 July 2013 Jan 2014 July 2014 Jan 2015
2 Feb 2013 Aug 2014 Feb 2014 Aug 2015
3 July 2012 Jan 2013 July 2013 Jan 2014
View 1 Replies
Aug 18, 2015
I have a question in gridview, I want to combine my two or more records into a single cell with two rowsfor Example i have a ID, Name, Year Start, and Year End for Column name in database and i want call it into my gridview that the Year Start and Year End will combine to Year like:
In Database
ID Name Year Start Year End
1 Yourname 2010 2015
In Gridview:
ID Name Year
1 Yourname 2010 2015
in a year column i want it to two row..
View 1 Replies
Aug 18, 2015
I want to bind three column with one row in gridview in asp.net with c#,
i want like this,
Name | Info
----------------------
name | lastname
| phone number
| address
I get this by default
name | last name | phone number | address
View 1 Replies
Aug 4, 2010
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();
}
View 3 Replies
Jun 29, 2010
i have one hidden field and i want to bind it with two values of my data base separated by an coma. some thing like
->asp:HiddenField ID="hfRstidDate" runat="server" Value=<%# DataBinder.Eval(Container.DataItem, "tsk_ID"),DataBinder.Eval(Container.DataItem, "Date_Worked").ToString())%>
View 1 Replies
May 7, 2015
i want to pass multiple arrays variable in query string.for example i have three checkbox list Brand ,Price, Attribute any arrays variable may have more than one value key arrays variable are fixed for checkboxlist
1-checkbox list Brand has Brand []arrays variable
2-checkbox list Price has Price []arrays variable
3-checkbox list Attribute has Attribute []arrays variable
now i have selecting two -two from every checkbox list .than i want to query string something like this
www.defualt.aspx?brand[]=samsung=123&apple=11,Price[]=100=12&200=2,Attribute []=camera=1&display=2
View 1 Replies
Aug 24, 2010
I want to store employee name,designation and department in session variable and retrieve in another page how to do this.
View 2 Replies
Jan 28, 2010
i need to concatenate the gridview rows to a single string if the gridview count is more than 100 then i need to perform the concatenation as 100 comma seperated and the next has to be carried over to the next string say if the count of gridview is 1000 then i need to concatenate the string as string1= 1to 100(Ex: a,b,c....) then string2=101-200 string3= 201-300... and so on. in case if i had to use String builder for this.. tel me how to proceed with this.
View 2 Replies
Aug 18, 2015
I want to orderby the list. Today date is on the top and then next date and all dates but when today date is passed then it comes on the end of the list. Is there any formal query in linq or some other code is used to achieve this?
08/01/2015
09/01/2015
but when today is passed then it automatically go to end and next today date is on the top
View 1 Replies
Jan 20, 2011
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>
View 2 Replies
May 7, 2015
I have uploaded a excelsheet to datatable and that datatable is bound to gridview.there is a save button present,i want to click the save button and all the gridview data will save in database.but that gridview has no boundfield or templatefield.
View 1 Replies
Dec 7, 2010
I am doing a data warehouse project.I have two tables tblA (id, type) and tblB(city, no_crimes, type).I want to create (insert) a number of rows based on the value of no_crimes.For Example, in tblB(Leeds, 2000, murder). SO, I need to insert 2000 rows into tblA by a single INSERT statement (not 2000 statements).
View 3 Replies
Jan 26, 2011
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()
View 15 Replies
Jul 4, 2010
I have a number of controls on a form i.e date pickers text boxes and dropdownlists. Firstly i need to set up some validation rules on the search button click event so if one control is populated then another needs to be and others shouldn't be etc etc
Then based on the values i need to return a dataset to the gridview showing all the records where the criteria meets all the values. I just wondered the best way to do this... i.e should i use validators to test for the rules(they may be too complex though). Should I just create a string and pass it as filter to the full dataset or use a stored proc and pass the string as the where criteria? This would mean a dyanmic proc so I'm not sure if there are any benefits as it won't cache on the server .
View 2 Replies
May 19, 2010
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.
View 4 Replies