|
Try this:
private void dgGrid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
IDataReader dr;
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
ID = Int32.Parse(e.Item.Cells[0].Text); //get ID
string Dispalydate= "";
dr = //Get those records
while(dr.Read())
{
if(Dispalydate.Length > 0)
{
Dispalydate += ", " + dr[1].ToString();
}
else
{
Dispalydate = dr[1].ToString();
}
}
dr.Close();
e.Item.Cells[1].Text = Dispalydate;
}
}
Hope this helps u...
|
|
|
|
|
Do it with a PIVOT TABLE
1[^]
2[^]
|
|
|
|
|
see my table format, its not possible with pivot
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
DataTable has a Select method. Use that to select name, iterate through the data row array and assign to another datatable in the desired format.
|
|
|
|
|
i am using .net 2005.i do my project in asp.net.
how to refresh access 2003 database when insert new record and delete a record during runtime.
my problem is when i insert new record then concurrently not saved in database but if i close and open the database means new inserted data is there.
so i want to store datas when database is concurrently opened.
|
|
|
|
|
sathyan_8294 wrote: when i insert new record then concurrently not saved in database
I think you will find the record is in the database. You will not see it on the screen until you refresh your data.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi guys
i have four text boxes and four custom validation controls ,
upon failure of a validation i am showing the erros on a summary validator control, but each of my
custom validator also shows the error message , why ?
i want just summary validator control to show the message , how to do that ?
thanks in advance
hello
|
|
|
|
|
In the design view of your page you can adjust the validation controls to show nothing or just leave the error message section blank.
"Sex is not the answer, it's the question and the answer is yes"
|
|
|
|
|
Display="None" on the Validation Control
|
|
|
|
|
Hell EveryBody,
I have a webservice in a server.And in another server I have a webApplication. When i use the webmethod of the webservice in my webApplication I got the following error.
I had already used this code, but no result.
webservLeave.PreAuthenticate = false;
webservLeave.Credentials = System.Net.CredentialCache.DefaultCredentials;
or
webservLeave.Credentials = System.Net.CredentialCache.DefaultCredentials;
The request failed with HTTP status 401: Unauthorized
plz help me out.
A key to every Solution
|
|
|
|
|
Is it possible to generate reports in asp.net
|
|
|
|
|
n.sa.vivek wrote: Is it possible to generate reports in asp.net
Yes 
|
|
|
|
|
Perfect answer. You got my 5.
|
|
|
|
|
http://msdn.microsoft.com/en-us/library/aa479018.aspx
|
|
|
|
|
|
Yes u can better way is to use Crystal reports.
http://aspdotnetnstuff.blogspot.com
|
|
|
|
|
Hi guys, actually in my aspx page, i created runtime excel files using dynamic grid control...,
The code looks like this......,
System.Web.UI.WebControls.DataGrid grid = new System.Web.UI.WebControls.DataGrid();
grid.DataSource = DS.Tables[i];
grid.DataBind();
foreach (DataRow dr1 in DS.Tables[i].Rows)
{
foreach (DataRow dr2 in DS.Tables[i+1].Rows)
{
if (dr1["MID"].ToString() == dr2["MID"].ToString())
{
if (!Directory.Exists(_path + "\\" + dr1["MID"].ToString() + @"\"))
{
Directory.CreateDirectory(_path + "\\" + dr1["MID"].ToString() + @"\");
string _XLSPATH = _path + "\\" + dr1["MID"].ToString() + "\\" + DS.Tables[i].TableName + ".xls";
using (StreamWriter sw = new StreamWriter(_XLSPATH))
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
grid.RenderControl(hw);
}
}
}
for this i have implemented, using web.ui,htmlcontrols and webcontrols...,
Now same functions i am trying to do in console application........,
Here UI interface i wont get...,
So how i can create grid and directory files for console application?
To solve this probs Any other way is there?
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
|
actually i want to insert two pictues at page 1 .using two seperate file upload control.images should be inserted at one click when i click submit button .and save the path at database and at page3 want to retrive the images by using the path of the images which comes from the data base .
i want only save path at database .
if anybody knows plz send me the code
thanks .....gaurav
|
|
|
|
|
try this code........
Dim filename As String = //name of ur file
If filename <> "" Then
Dim path As String = //path of file from database
Dim file As FileInfo = New System.IO.FileInfo(Path)
If (File.Exists) Then
Response.Clear()
Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name)
Response.AddHeader("Content-Length", file.Length.ToString())
Response.ContentType = "application/octet-stream"
Response.WriteFile(file.FullName)
Response.End()
End If
End If
|
|
|
|
|
Hi all...can anyone help me...im trying to retrieve a controls value from a datagrid in asp.net...can anyone assist me with this issue?
living life on the flip side
|
|
|
|
|
In which event you need to know this?
In RowDataBound?
In that case you have e.Row has help
foreach (DataCell cell in e.Row.Cells)
{
foreach (Control ctrl in cell.Controls)
{
}
}
In the second control you can check each control used in a cell of the gridview row
Is it after pressing Update or Delete in the gridview? You need something likt this
protected void Grid_OnCommand(Object sender, EventArgs e)
{
Button btn = (Button)sender;
(GridViewRow) row = (GridViewRow)btn.NamingContainer;
foreach (DataCell cell in row.Cells)
{
foreach (Control ctrl in cell.Controls)
{
}
}
}
Good Luck
|
|
|
|
|
Hi Digimanus...im actually looking to do this in html...if there is a way?
living life on the flip side
|
|
|
|
|
in html?
I do not understand this.
|
|
|
|
|
im trying to get a click event in html to call a javascript function that accesses the value of the control inthe datagrid...
living life on the flip side
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
