I m beginner for ASP.Net 2005 with C# and SQL Server 2005.

I have created the form which contains many asp standard controls on it like label,textbox,checkbox,dropdownlist,command button.
The command button used are only to execute the different queries on click event.
I have put the GridView control which is used to show the database stored related to that form.
I m using SQL DataSource control for the connection.

Now,my problem is i m not able to write the proper SQL queries which insert,delete,update or select from the GridView and Standard Controls.

In short,I have a command button set up on a form to run a SQL pass-through insert query after several field are filled in standard controls but I can't get .Please anyone could help me to provide the sample source code related to above controls used in the same form.

Thanxs

Please help me with some sample source code i m really in urgent need...
Want to create the project thenafter.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:companymaster %>"
DeleteCommand="DELETE FROM [Categories]
WHERE [CategoryID] = @CategoryID"
InsertCommand="INSERT INTO [Categories]
([CategoryName], [Description])
VALUES (@CategoryName, @Description)"
UpdateCommand="UPDATE [Categories] SET
[CategoryName] = @CategoryName,
[Description] = @Description
WHERE [CategoryID] = @CategoryID">
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server"/>

I have used the above code for the sql queries with sqldatasource control and gridview control.
Is any connection other than this required ??
What should be written in web.config ??

Pls provide proper guideline...

Is the code enough to complete what i needed if it's incomplete then pls help out

Why don't you try it out?

If it works, then it's enough code, otherwise it isn't...

But seriously, it would help if you'd post a bit more detail, like an error message for example.

And yes: with this syntax:

"<%$ ConnectionStrings:companymaster %>"

you need a connection string called companymaster in the connectionStrings element of the web.config.

Take a look at www.connectionstrings.com for some examples.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.