|
Hi,
I have to show some data in gridview group wise. I an having 2 sql tables with some data as shown below.
Table 1
--------
Empid Empname
01 abc
02 xyz
03 pqr
Table 2
--------
Assign1 Empid Assignment
01 01 Assign1
02 01 Assign2
03 01 Assign3
04 02 Assign1
05 03 Assign1
above is the table structure.
Now i want to display it in gridview employee name wise as shown below.
Name Assignment
abc Assign1
Assign2
Assign3
xyz Assign1
pqr Assign1
i want to display it in grid view name wise i.e i want to group assignments by employee name and show it in gridview.
i an sql server 2005 as database.
Any suggestion or code snippet or useful link representing above will be useful.
Thanks and regards,
Pranav Dave
|
|
|
|
|
|
|
hello everyone
I would like your assistance please, I would like to fill a dropdowlist according to another in asp.net / c #, of course respecting the n-tier architecture, if somebody who can help me with ideas, some examples or advice of course, thank you
|
|
|
|
|
|
thank you very much for your help, but the tutorial explains it by working with the wizard, I would like to know at coding
|
|
|
|
|
You have to start from somewhere, then we can help. If you're thinking of using n-tier, then consider having a data access layer, a business logic layer and of cos your presentation layer.
Again, you have to start something, then if you run into problems we will help 
|
|
|
|
|
You are talking of cascading dropdownlist, just google 'cascading dropdown' and you will get lots of article on the same with *code* that you want!
P.S.: Even code project is enough for it, if you don't prefer google. 
|
|
|
|
|
What matters the most when binding data to a control(dropdown in this case) is your datasource,
this will determin how you retrieve data from your datasource to your control, can be a List<>, database, collection.
For instance, i will bind simple data to my dropdown from a ArrayList.
public void FillCustomerNames()
{
ArrayList customerNames = new ArrayList();
customerName.Add("Member123");
customerName.Add("Member1234");
customerName.Add("Member12345");
dropdownlist.DataSource = customerName;
dropdownlist.DataBind();
}
That's it, whenever you call this method from anywhere it will fill your dropdownlist with those values(items)
|
|
|
|
|
thank you for your reply, and if I want to show the result of choice in the dropdownlist in a html table creates at run time of this application
here is the code of creating a htmltable to display data from DB SQL by selecting a dropdownlist:
string chaineCnx = ConfigurationManager.ConnectionStrings["ConnectionString_operateur"].ToString();
HtmlTable tbTableName = new HtmlTable();
HtmlTableRow tbRow = null;
HtmlTableCell tbCelle = null;
tbTableName.ID = "TableName";
tbTableName.Border = 1;
tbTableName.CellSpacing = 1;
using (SqlConnection cnx = new SqlConnection(chaineCnx))
{
cnx.Open();
SqlCommand cmTable = new SqlCommand("select * from operateur, cnx);
SqlDataReader drTable = cmTable.ExecuteReader();
while (drTable.Read())
{
tbRow = new HtmlTableRow();
for (int i = 0; i < drTable.FieldCount; i++)
{
tbCelle = new HtmlTableCell();
tbCelle.Width = "80";
if (drTable[i] != DBNull.Value)
tbCelle.InnerText = drTable[i].ToString();
tbRow.Cells.Add(tbCelle);
}
tbTableName.Rows.Add(tbRow);
}
this.form1.Controls.Add(tbTableName);
}
|
|
|
|
|
Hi All
I Have a problem.I want to search record from database and fill in a grid simultaneously when a user typing in TextBox
means when i type 'A' in TextBox it fill gridview from database like 'Adam', 'Ashmit' ,'Anirudh' ,'Adnan'
bt when he type another letter like 'Ad' then only 'Adam','Adnan' will remain in grid.
this is the result without click over any button
Thanks in Advance
|
|
|
|
|
|
Tell me without use of AJAX i Think it can be possible by adding one more attribute i.e. onTextChange event bt i dont know how i do this.
Guide me if u know the solution
|
|
|
|
|
if you wont use AJAX on every textchanged a postback will happen which at all not good
|
|
|
|
|
Use Ajax and in Sql Query use Like stmt
|
|
|
|
|
Could u tell me how mean in form of Code
|
|
|
|
|
gautamamit8 wrote: Could u tell me how mean in form of Code
Try out! You have been given head start...use Google with key words if needed... people here won't provde you direct code. Put some effort and if you get stuck, all will help.
|
|
|
|
|
Yeah, the way out is to use the ajax AutoCompleteExtender alongside a web method to get the data
|
|
|
|
|
Hey guys,
In my ASP.NET(.aspx) pages am referencing an external css file,
When I run my pages in a website, firefox 'cannot' interpret
anything in my css file but Internet Explorer can...
Does anyone know what i can do to help firefox read my css?
Please help 
Thanks,
Morg
|
|
|
|
|
How are you referencing the css file?
Wout Louwers
|
|
|
|
|
I tried both of this type, both work for IE and none work for firefox,
but when i paste the second line in the firefox address bar, the file can
open and show my css coding but the 1st line will not show in firefox:
1. <link href="C:/Documents and Settings/Morgan/Desktop/Morgan Documents/PlanetFitness/App_Themes/StyleSheet.css" type="text/css" rel="stylesheet" />
2.<link href="file:///C:/Documents and Settings/Morgan/Desktop/Morgan Documents/PlanetFitness/App_Themes/StyleSheet.css" type="text/css" rel="stylesheet" />
Don't worry with my full file path coz thats what Visual studio wants
|
|
|
|
|
I don't know if you are plannimg to use your webpage on a webserver in the future, but I would worry about the full path.Don't mind what Visual studio want, try to fix it.
Wout Louwers
|
|
|
|
|
How can a clever guy like me struggle like this?
You know what? I just changed the whole full path to:
<link href="App_Themes/jtip.css" type="text/css" rel="stylesheet" />
and both firefox and IE can read my css code...
mistakes...
And thanks for being helpful man
|
|
|
|
|
I seem to remember that Firefox has a security feature, on by default, to prevent it from reading local files referenced by the link tag. If you avoid calling something a local file you avoid the roadblock, as you found out.
|
|
|
|
|
Hi All
I have a problem.I am using a datalist on which 2 controls are there. 1st is Label which have date 2nd is buttonshow. when buttonshow is pressing the popup panel will come n all details of that particular date(label) filled in Popup Panel's text Box.I am unable to cougt that label value on the panel.
Thanks in Advance
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
