ASP.NET

Sonia Gupta5-Jul-07 21:05

5-Jul-07 21:05

if u provide ur data binding function.it wil be easy to rectify it.

$h@ma!|@5-Jul-07 21:09

$h@ma!|@

5-Jul-07 21:09

OleDbDataAdapter da = new OleDbDataAdapter(strQuery, conn);

conn.Close();
DataSet ds = new DataSet();
da.Fill(ds, "table name");
searchgrid.DataSource = ds.DefaultViewManager;

$h@ma!|@

Sonia Gupta5-Jul-07 21:18

5-Jul-07 21:18

try this one
OleDbDataAdapter da = new OleDbDataAdapter(strQuery, conn);

conn.Close();
DataSet ds = new DataSet();
da.Fill(ds, "table name");
searchgrid.DataSource = ds;
searchgrid.databind();

N a v a n e e t h5-Jul-07 21:33

N a v a n e e t h

5-Jul-07 21:33

Sonia Gupta wrote:
conn.Close();
DataSet ds = new DataSet();
da.Fill(ds, "table name");

Is it possible to fill DS when connection is closed ?

My Website | Ask smart questions

mohantfor.net5-Jul-07 21:10

mohantfor.net

5-Jul-07 21:10

u shd decleare the namespace System.Data.OleDb.OleDbConnection

N a v a n e e t h5-Jul-07 21:32

N a v a n e e t h

5-Jul-07 21:32

$h@ma!|@ wrote:
OleDbDataAdapter da = new OleDbDataAdapter(strQuery, conn);

What is the type of conn ? OledbDataAdapter is having 4 overloaded methods.

1. public OleDbDataAdapter ( System.String selectCommandText , System.Data.OleDb.OleDbConnection selectConnection )

In this you need to pass the select query and OledbConnection object as parameters

2. public OleDbDataAdapter ( System.String selectCommandText , System.String selectConnectionString )

In this pass Query and connection string

3. public OleDbDataAdapter ( System.Data.OleDb.OleDbCommand selectCommand )

This accepts OledbCommand object

and last one is with no parameters. Check your call matches with these methods ?

My Website | Ask smart questions

Still i didnt get proper answer, help plz..........,

$h@ma!|@5-Jul-07 22:45

$h@ma!|@

5-Jul-07 22:45

ok fine i'll try thx

$h@ma!|@

Member 38798815-Jul-07 20:36

Member 3879881

5-Jul-07 20:36

Hi i posted this msg already...,
Our members also said some answers...,
But still i didn t get proper answer...,
So,I am post one more time...,
Plz give me some solution for this probs...,

I am trying to display my grid cell value in grid textbox...,
So i used this following code...,
For Each fillgrdregtextbox As DataGridItem In dgrdmain1.Items
Dim AppRgHrs As TextBox = CType(fillgrdregtextbox.FindControl("txtAppRgHrs"), TextBox)
Dim AppOtHrs As TextBox = CType(fillgrdregtextbox.FindControl("txtAppOtHrs"), TextBox)
If fillgrdregtextbox.Cells(25).Text <> "" Then
AppRgHrs.Text = Val(fillgrdregtextbox.Cells(25).Text)
AppOtHrs.Text = Val(fillgrdregtextbox.Cells(26).Text)
ElseIf fillgrdregtextbox.Cells(27).Text <> "" Then
AppRgHrs.Text = Val(fillgrdregtextbox.Cells(27).Text)
AppOtHrs.Text = Val(fillgrdregtextbox.Cells(28).Text)Else
AppRgHrs.Text = 0
AppOtHrs.Text = 0
End If
Next

In this that first if condition is working...,
But that elseif is not working...,(Mentioned in bold)
Instead of that i am getting 0 on there...,
how to solve it...,
Plz tell me...,
Advance thanks...,

Regards,
Magi

Re: Still i didnt get proper answer, help plz..........,

Venkatesh Mookkan5-Jul-07 20:42

Venkatesh Mookkan

5-Jul-07 20:42

Is the 27th column is BoundColumn or template column? The Text property would be always empty in the TemplateColumn.

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group | Blog Spot

Re: Still i didnt get proper answer, help plz..........,

Member 38798815-Jul-07 20:54

Member 3879881

5-Jul-07 20:54

27th is the bound column...,

Regards,
Magi

To pop a value to a cascading Dropdown list

codingrocks5-Jul-07 20:34

codingrocks

5-Jul-07 20:34

I am in the middle of an application where i am using ASp.net with Ajax controls..

I want to pop a value from the gridview, when i click it and to be displayed in the cascading drop down list..

there are two dropdown lists, first one works fine always... the second one gets enabled only when i select values in first..

the gridview value i click pops in to the first dropdown but not to second one...
The code i used is

DropDownList1.SelectedIndex = DropDownList1.Items.IndexOf(DropDownList1.Items.FindByText(ds_rec.Tables[0].Rows[0]["Column1"].ToString()));

i need help

thanks in advance....

SAJAN A PILLAI

C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE

Master pages

Sonia Gupta5-Jul-07 20:24

5-Jul-07 20:24

What's the use of Master page in asp.net 2.0
Is it related to like MDI parent form in window application.

$h@ma!|@5-Jul-07 20:37

$h@ma!|@

5-Jul-07 20:37

master page is like paretnt page
the layout in master page will automaticaaly appear to all child pages..the only different thing will be content place holder

$h@ma!|@

Piyush Vardhan Singh5-Jul-07 20:51

Piyush Vardhan Singh

5-Jul-07 20:51

if we want same header footer and and any thingh in ui in deferent page then it help

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379

Sonia Gupta5-Jul-07 20:54

5-Jul-07 20:54

if u please provide a suitable link..?
Thanks..
Sonia Gupta
soniagupta1@yahoo.co.in

Piyush Vardhan Singh5-Jul-07 20:56

Piyush Vardhan Singh

5-Jul-07 20:56

its contain many content place holder where we put our usercontrol(ascx page)

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379

Piyush Vardhan Singh5-Jul-07 21:05

Piyush Vardhan Singh

5-Jul-07 21:05

Its not so hard yaar first u go to-> add new Item and select master page-> mouse right click 0n master page in solution and click(add content page) then default page open ->past ur user control in ContentPlaceHolder and then injoy with master page

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379

Sonia Gupta5-Jul-07 21:08