Button Column Select.

[rcoco]

Hi all,
I have a datagrid with Button column select in form of hyperlink. On
the same page, I have another datagrid that insert data and one
column(Name) has Names of a user that is inserting data(using windows
authentication) .
Now this is how it's supposed to work: When any user want to see data
about a particular user it's a matter of selecting his name and the
data Writen by the selected user should be the only ones to be shown.
I got some examples on Google but they all seem not to be working.
When a user is selected the page remains the same data is not
selected. How would can I solve this problem?
My code looks like this:
HTML part:
<Columns>
<asp:ButtonColu mn HeaderText="Ope rations"
DataTextField=" TeamOperation" ButtonType="Lin kButton"></
asp:ButtonColum n>
</Columns>
and code behind:
private void dgoperation_Ite mCommand(object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
SqlCommand myCommand=new SqlCommand();
myCommand.Conne ction=con;
myCommand.Comma ndText="select * from dbo.DashBoard where Name =
@Billing";
myCommand.Param eters.Add(new SqlParameter("@ Billing",SqlDbT ype.VarChar,
50));
myCommand.Param eters["@Billing"].Value= dgbilling;
SqlDataAdapter myAdapter=new SqlDataAdapter( myCommand);
DataSet ds = new DataSet();
myAdapter.Fill( ds);
dgis.DataSource =ds;
dgis.EditItemIn dex = -1;
dgis.DataBind() ;
}

dgis: this is the datagrid that where user inserts data.
dgbilling: this is the datagrid with the name list.
Thanks.

[rcoco]

I have corrected my statement and this time I'm getting this error:
"Object reference not set to an instance of an object."
And the error source:
Line 219: myCommand.Comma ndText="select * from dbo.DashBoard where
Name Like @Billing";
Line 220: myCommand.Param eters.Add(new
SqlParameter("@ Billing",SqlDbT ype.VarChar,50) );
Line 221: myCommand.Param eters["@Billing"].Value= bc.Text;
Line 222: SqlDataAdapter myAdapter=new SqlDataAdapter( myCommand);
Line 223: DataSet ds = new DataSet();
This is my code:
<Columns>
<asp:ButtonColu mn HeaderText="Ope rations"
DataTextField=" TeamOperation" ButtonType="Lin kButton"
CommandName="Se lect"></asp:ButtonColum n>
</Columns>
My code behind:
private void dgoperation_Ite mCommand(object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)
{
System.Web.UI.W ebControls.Link Button bc=new
System.Web.UI.W ebControls.Link Button();
bc=(System.Web. UI.WebControls. LinkButton)e.It em.Cells[0].FindControl("T eamBilling");
SqlCommand myCommand=new SqlCommand();
myCommand.Conne ction=con;
myCommand.Comma ndText="select * from dbo.DashBoard where Name Like
@Billing";
myCommand.Param eters.Add(new SqlParameter("@ Billing",SqlDbT ype.VarChar,
50));
myCommand.Param eters["@Billing"].Value= bc.Text;
SqlDataAdapter myAdapter=new SqlDataAdapter( myCommand);
DataSet ds = new DataSet();
myAdapter.Fill( ds);
dgis.DataSource =ds;
dgis.EditItemIn dex = -1;
dgis.DataBind() ;
}
How can I solve this?
Thanks

[Alexey Smirnov]

On May 18, 3:14 pm, rcoco <nclau...@yahoo .cawrote:

myCommand.Conne ction=con;

What is 'con'? Did you created a SqlConnection reference already?

For example,

SqlConnection con = new SqlConnection(" my_connection_s tring");

[rcoco]

Hi Alexey,
con is:
SqlConnection con = new SqlConnection(" user
id=utldbuser;"+ "password=utldb user;"+"server= utlhq202;"+"dat abase=IS_dashbo ard;");
Thanks

[Alexey Smirnov]

On May 21, 7:11 am, rcoco <nclau...@yahoo .cawrote:

Hi Alexey,
con is:
SqlConnection con = new SqlConnection(" user
id=utldbuser;"+ "password=utldb user;"+"server= utlhq202;"+"dat abase=IS_dashbo *ard;");
Thanks

Well, but where do you create it?

The code above looks correct and I can only guess that possibly your
connection object is not a global available reference.

Is it a code-behind class? If yes, did you compiled it?

[rcoco]

On May 21, 9:51 am, Alexey Smirnov <alexey.smir... @gmail.comwrote :

On May 21, 7:11 am, rcoco <nclau...@yahoo .cawrote:

Hi Alexey,
con is:
SqlConnection con = new SqlConnection(" user
id=utldbuser;"+ "password=utldb user;"+"server= utlhq202;"+"dat abase=IS_dashbo **ard;");
Thanks

Well, but where do you create it?

The code above looks correct and I can only guess that possibly your
connection object is not a global available reference.

Is it a code-behind class? If yes, did you compiled it?

Yes it's a code behind.
I think the problem was
System.Web.UI.W ebControls.Link Button bc=new
System.Web.UI.W ebControls.Link Button();
bc=(System.Web. UI.WebControls. LinkButton)e.It em.Cells[0].FindControl("T eamB*
illing");
So I have now tryed Writing the code like this.
System.Web.UI.W ebControls.Butt onColumn bc=new
System.Web.UI.W ebControls.Butt onColumn();
bc=(System.Web. UI.WebControls. ButtonColumn)e. Item.Cells[0].FindControl("S elect") ;
SqlCommand myCommand=new SqlCommand();
myCommand.Conne ction=con;
myCommand.Comma ndText="select * from dbo.DashBoard where Name =
@operation";
myCommand.Param eters.Add(new
SqlParameter("@ operation",SqlD bType.VarChar,5 0));
myCommand.Param eters["@operation "].Value= bc.DataTextFiel d;
con.Open();
myCommand.Execu teNonQuery();
con.Close();
dgis.EditItemIn dex=-1;
Fill();
Bind();
But when compiling I get this error
C:\Inetpub\wwwr oot\Dash_Board\ DashBoard.aspx. cs(210): Cannot convert
type 'System.Web.UI. Control' to
'System.Web.UI. WebControls.But tonColumn'
I'm not sure if I'm on the right track! What do you think?
Thank you very much.

[Alexey Smirnov]

On May 21, 11:41 am, rcoco <nclau...@yahoo .cawrote:

On May 21, 9:51 am, Alexey Smirnov <alexey.smir... @gmail.comwrote :

On May 21, 7:11 am, rcoco <nclau...@yahoo .cawrote:

Hi Alexey,
con is:
SqlConnection con = new SqlConnection(" user
id=utldbuser;"+ "password=utldb user;"+"server= utlhq202;"+"dat abase=IS_dashbo ***ard;");
Thanks

Well, but where do you create it?

The code above looks correct and I can only guess that possibly your
connection object is not a global available reference.

Is it a code-behind class? If yes, did you compiled it?

Yes it's a code behind.
I think the problem was
System.Web.UI.W ebControls.Link Button bc=new
System.Web.UI.W ebControls.Link Button();
bc=(System.Web. UI.WebControls. LinkButton)e.It em.Cells[0].FindControl("T eamB**
illing");
So I have now tryed Writing the code like this.
System.Web.UI.W ebControls.Butt onColumn bc=new
System.Web.UI.W ebControls.Butt onColumn();
bc=(System.Web. UI.WebControls. ButtonColumn)e. Item.Cells[0].FindControl("S el*ect") ;
SqlCommand myCommand=new SqlCommand();
myCommand.Conne ction=con;
myCommand.Comma ndText="select * from dbo.DashBoard where Name =
@operation";
myCommand.Param eters.Add(new
SqlParameter("@ operation",SqlD bType.VarChar,5 0));
myCommand.Param eters["@operation "].Value= bc.DataTextFiel d;
con.Open();
myCommand.Execu teNonQuery();
con.Close();
dgis.EditItemIn dex=-1;
Fill();
Bind();
But when compiling I get this error
C:\Inetpub\wwwr oot\Dash_Board\ DashBoard.aspx. cs(210): Cannot convert
type 'System.Web.UI. Control' to
'System.Web.UI. WebControls.But tonColumn'
I'm not sure if I'm on the right track! What do you think?
Thank you very much.

First of all, remember, the "code behind" classes must be compiled
into an assembly, which is placed by VS.NET in the \bin directory.
When you get an error during compilation, you cannot run the actual
code, because your classes simply did not compiled and a DLL in the
\bin directory was not updated.

Regarding your LinkButton.

I'm not very well understood why you used this

<asp:ButtonColu mn DataTextField=" TeamOperation" ...

Maybe you can explain, what you did supposed to get there

I suppose, you wanted to have this

<asp:ButtonColu mn CommandName="Te amOperation"... .

which can be simply accessed as

e.CommandName

in your dgoperation_Ite mCommand() function

e.g.

myCommand.Param eters["@operation "].Value= e.CommandName;

without any extra code.

However, in this case I don't see the sense of the

"select * from dbo.DashBoard where Name = @operation";

[rcoco]

On May 21, 1:21 pm, Alexey Smirnov <alexey.smir... @gmail.comwrote :

On May 21, 11:41 am, rcoco <nclau...@yahoo .cawrote:

On May 21, 9:51 am, Alexey Smirnov <alexey.smir... @gmail.comwrote :

On May 21, 7:11 am, rcoco <nclau...@yahoo .cawrote:

Hi Alexey,
con is:
SqlConnection con = new SqlConnection(" user
id=utldbuser;"+ "password=utldb user;"+"server= utlhq202;"+"dat abase=IS_dashbo ****ard;");
Thanks

Well, but where do you create it?

The code above looks correct and I can only guess that possibly your
connection object is not a global available reference.

Is it a code-behind class? If yes, did you compiled it?

Yes it's a code behind.
I think the problem was
System.Web.UI.W ebControls.Link Button bc=new
System.Web.UI.W ebControls.Link Button();
bc=(System.Web. UI.WebControls. LinkButton)e.It em.Cells[0].FindControl("T eamB***
illing");
So I have now tryed Writing the code like this.
System.Web.UI.W ebControls.Butt onColumn bc=new
System.Web.UI.W ebControls.Butt onColumn();
bc=(System.Web. UI.WebControls. ButtonColumn)e. Item.Cells[0].FindControl("S el**ect") ;
SqlCommand myCommand=new SqlCommand();
myCommand.Conne ction=con;
myCommand.Comma ndText="select * from dbo.DashBoard where Name =
@operation";
myCommand.Param eters.Add(new
SqlParameter("@ operation",SqlD bType.VarChar,5 0));
myCommand.Param eters["@operation "].Value= bc.DataTextFiel d;
con.Open();
myCommand.Execu teNonQuery();
con.Close();
dgis.EditItemIn dex=-1;
Fill();
Bind();
But when compiling I get this error
C:\Inetpub\wwwr oot\Dash_Board\ DashBoard.aspx. cs(210): Cannot convert
type 'System.Web.UI. Control' to
'System.Web.UI. WebControls.But tonColumn'
I'm not sure if I'm on the right track! What do you think?
Thank you very much.

First of all, remember, the "code behind" classes must be compiled
into an assembly, which is placed by VS.NET in the \bin directory.
When you get an error during compilation, you cannot run the actual
code, because your classes simply did not compiled and a DLL in the
\bin directory was not updated.

Regarding your LinkButton.

I'm not very well understood why you used this

<asp:ButtonColu mn DataTextField=" TeamOperation" ...

Maybe you can explain, what you did supposed to get there

I suppose, you wanted to have this

<asp:ButtonColu mn CommandName="Te amOperation"... .

which can be simply accessed as

e.CommandName

in your dgoperation_Ite mCommand() function

e.g.

myCommand.Param eters["@operation "].Value= e.CommandName;

without any extra code.

However, in this case I don't see the sense of the

"select * from dbo.DashBoard where Name = @operation";- Hide quoted text -

- Show quoted text -

Thanks
TeamOperation is a columns that has a list of users of the website. So
by
<asp:ButtonColu mn DataTextField=" TeamOperation" ... Im diplaying the
names in datagrid "dgoperatio n".
Thanks

[Alexey Smirnov]

On May 21, 2:26 pm, rcoco <nclau...@yahoo .cawrote:

Thanks
TeamOperation is a columns that has a list of users of the website. So
by
<asp:ButtonColu mn DataTextField=" TeamOperation" ... Im diplaying the
names in datagrid "dgoperatio n".
Thanks- Hide quoted text -

Ok, I think, I got it

Then try

myCommand.Param eters["@Billing"].Value= e.Item.Cells[0].Text;

assuming that "Operations " is the first column of the grid

[rcoco]

On May 21, 3:43 pm, Alexey Smirnov <alexey.smir... @gmail.comwrote :

On May 21, 2:26 pm, rcoco <nclau...@yahoo .cawrote:

Thanks
TeamOperation is a columns that has a list of users of the website. So
by
<asp:ButtonColu mn DataTextField=" TeamOperation" ... Im diplaying the
names in datagrid "dgoperatio n".
Thanks- Hide quoted text -

Ok, I think, I got it

Then try

myCommand.Param eters["@Billing"].Value= e.Item.Cells[0].Text;

assuming that "Operations " is the first column of the grid

Still does not select any data. All it does its like the page is just
being refreshed.
Thanks