datagrid command buttons

CyberW · November 23rd, 2008, 12:41 PM

thank you.
what is the ="<%$ ConnectionStrings:MyConnectionString %>" ?

Is that a claas defined somewhere in C# code?

I'm using vb, how do i connect my connection string with sqldatasource?

thank you

Lee Dumond · November 23rd, 2008, 01:47 PM

Quote:

quote:Originally posted by CyberW
thank you.
what is the ="<%$ ConnectionStrings:MyConnectionString %>" ?

It's not a language-specific thing. It's just a shortcut way of specifying a connection string you've defined in the <connectionStrings /> section of web.config. Doesn't matter if you're using VB or C#.

If you want, you can actually type your raw connection string into an SqlDataSource, like:

ConnectionString="Data Source=\sqlexpress;Initial Catalog=MyDatabase;Integrated Security=True"

But it is much easier to do it the first way.

_________________________________

Visit my blog at http://leedumond.com

CyberW · November 23rd, 2008, 02:21 PM

i'm getting errors putting the CS.

I think i'll pass it & write my own delete command with oledbCommand.

But again, how do i get the specific key from the gridview?

thanks

Lee Dumond · November 23rd, 2008, 06:26 PM

Quote:

quote:Originally posted by CyberW
i'm getting errors putting the CS.

You didn't type in exactly what I gave you, right? Did you substitute your own values?

_________________________________

Visit my blog at http://leedumond.com

CyberW · November 24th, 2008, 05:54 AM

I copy\paste it...

Lee Dumond · November 24th, 2008, 10:34 AM

Quote:

quote:Originally posted by CyberW
I copy\paste it...

Copy / paste won't do it. You have to substitute your own connection string in there. If you can't connect to your own database, then none of this is going to help you at all. There's no way I can guess what that is.

Once you are able to specify the right connection string to YOUR database in the SqlDataSource, the rest of this should be pretty straightforward.

_________________________________

Visit my blog at http://leedumond.com

CyberW · November 24th, 2008, 10:41 AM

I trirf to put the access driver ( jet) but it gave me errors ..

Isn't it possible?

also, if i want to write my own handler i cannot get the field values in a specific row of the gridview??

thank u

Lee Dumond · November 24th, 2008, 11:03 AM

I did not know you were using Access, sorry about that. In that case, you'd want to use AccessDataSource, not SqlDataSource.

You can write your own handler, though I don't know what advantage that would provide.

_________________________________

Visit my blog at http://leedumond.com

CyberW · November 27th, 2008, 03:02 PM

Ikinda lost you..

Can you please write how to put a gridview with a working delete button? ( access db)

thank you

Lee Dumond · November 27th, 2008, 05:36 PM

Code:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
   <title></title>
</head>
<body>
   <form id="form1" runat="server">
      <div>
         <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="True" DataSourceID="AccessDataSource1"
            AutoGenerateDeleteButton="True" DataKeyNames="MyPrimaryKey">
         </asp:GridView>
         <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/MyDatabase.mdb"
            SelectCommand="SELECT * FROM [MyTable]" 
            DeleteCommand="DELETE FROM [MyTable] WHERE [MyPrimaryKey] = ?">
            <DeleteParameters>
               <asp:Parameter Name="MyPrimaryKey" Type="Int32" />
            </DeleteParameters>
         </asp:AccessDataSource>
      </div>
   </form>
</body>
</html>

Don't forget to substitute your OWN values for MyPrimaryKey, MyDatabase, and MyTable.

_________________________________

Visit my blog at http://leedumond.com