how to refresh access 2003 database - ASP.NET Discussion Boards

Member 387988117-Jul-08 23:53

17-Jul-08 23:53

Hi i ma getting datas in dataset like this format:

Name Date

N1 7-21-2008
N1 7-22-2008
N2 7-21-2008
N2 7-25-2008
N2 7-26-2008
N3 7-24-2008

But i want to bind it in my grid like this:

Name Dates

N1 7-21-2008, 7-22-2008
N2 7-21-2008, 7-25-2008, 7-26-2008
N3 7-24-2008

How to do that?,

Thanks & Regards,
Michel,
please don't forget to vote on the post

Re: Binding into grid

varshavmane18-Jul-08 0:16

varshavmane

18-Jul-08 0:16

Do it in Item Data Bound Event of grid...this event is fired when u bind grid...

Re: Binding into grid

Member 387988118-Jul-08 0:19

Member 3879881

18-Jul-08 0:19

Plz if u dont mind give some what more explanation or code...,
It will be help full for me

Thanks & Regards,
NeW OnE,
please don't forget to vote on the post

Re: Binding into grid

varshavmane18-Jul-08 1:45

varshavmane

18-Jul-08 1:45

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...

Re: Binding into grid

Sherin Iranimose18-Jul-08 0:26

Sherin Iranimose

18-Jul-08 0:26

Do it with a PIVOT TABLE

1[^]

2[^]

EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.

How to post a question

Re: Binding into grid

Member 387988118-Jul-08 0:42

Member 3879881

18-Jul-08 0:42

see my table format, its not possible with pivot

Thanks & Regards,
NeW OnE,
please don't forget to vote on the post

Re: Binding into grid

N a v a n e e t h18-Jul-08 1:07

N a v a n e e t h

18-Jul-08 1:07

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.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

how to refresh access 2003 database

sathyan_829417-Jul-08 23:47

sathyan_8294

17-Jul-08 23:47

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.

Re: how to refresh access 2003 database

Ashfield18-Jul-08 1:23

Ashfield

18-Jul-08 1:23

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

Validation control

Tauseef A17-Jul-08 23:45

Tauseef A

17-Jul-08 23:45

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

Re: Validation control

windhopper17-Jul-08 23:50

windhopper

17-Jul-08 23:50

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"

Re: Validation control

J4amieC18-Jul-08 0:39

J4amieC

18-Jul-08 0:39

Display="None" on the Validation Control

WebService : Request failed with HTTP status 401: Unauthorized

AS@1317-Jul-08 23:39

AS@13

17-Jul-08 23:39

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

report generation

n.sa.vivek17-Jul-08 23:16

n.sa.vivek

17-Jul-08 23:16

Is it possible to generate reports in asp.net

Re: report generation

N a v a n e e t h17-Jul-08 23:36

N a v a n e e t h

17-Jul-08 23:36

n.sa.vivek wrote:
Is it possible to generate reports in asp.net

Yes

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: report generation

Sherin Iranimose17-Jul-08 23:59

Sherin Iranimose

17-Jul-08 23:59

Perfect answer. You got my 5.

EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.

How to post a question

Re: report generation

eyeseetee17-Jul-08 23:39

eyeseetee

17-Jul-08 23:39

http://msdn.microsoft.com/en-us/library/aa479018.aspx

Re: report generation

n.sa.vivek21-Jul-08 2:25

n.sa.vivek

21-Jul-08 2:25

hi,thank you

Re: report generation

metallica_rock1018-Jul-08 0:10

metallica_rock10

18-Jul-08 0:10

Yes u can better way is to use Crystal reports.

http://aspdotnetnstuff.blogspot.com

Instead of grid and directory files any other solution for console application?

Member 387988117-Jul-08 23:08

Member 3879881

17-Jul-08 23:08

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

Re: Instead of grid and directory files any other solution for console application?

Sherin Iranimose17-Jul-08 23:57

Sherin Iranimose

17-Jul-08 23:57

http://nishantpant.wordpress.com/2006/11/02/exporting-data-to-excel-from-a-windows-forms-net-application/[^]

EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.

How to post a question

how to insert image at page 1 and retrive at page 3 using database

gaurav mangal17-Jul-08 22:04

gaurav mangal

17-Jul-08 22:04

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

Re: how to insert image at page 1 and retrive at page 3 using database

sumit703417-Jul-08 23:09

sumit7034

17-Jul-08 23:09

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

Retrieve Datagrid Control value

Agweet17-Jul-08 21:39

Agweet

17-Jul-08 21:39

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

Re: Retrieve Datagrid Control value

Herman<T>.Instance17-Jul-08 23:08

Herman<T>.Instance

17-Jul-08 23:08

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; // to know which button was clicked
    (GridViewRow) row = (GridViewRow)btn.NamingContainer; //to get the complete datarow found via it's container
// followed bij
foreach (DataCell cell in row.Cells)
{
   foreach (Control ctrl in cell.Controls)
   {
   }
}
  
}

Good Luck

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.