i am trying to insert some records using C#.net to sql server 2005 database...

[mohamed aurif]

it is not inserted ...the code is as follows

try
{
con = new SqlConnection(@"Data Source=.\SQLExpress;Integrated Security=SSPI;AttachDBFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\pmsdb.mdf");
com = new SqlCommand("insert into initialdetails values('" + txtFName.Text + "','" + txtLName.Text + "'," + txtAge.Text + ",con");
             con.Open();
             textBox1.Text= "Successfully added";
            
            }
            catch (Exception ex)
            {
             textBox1.Text = ex.Message;
            }

is there any wrong with this code?...or..any other better coding rather than this

regards
mohamed aurif

[tlhintoq]

TIP: When you are writing your question, there is a button on the tool bar that wraps the [code] tags around your copy/pasted code. It helps a bunch. Its the button with a '#' on it. More on tags. They're cool. Check'em out.

[tlhintoq]

Database How-to parts 1 and 2
Database tutorial Part 1
Database tutorial Part 2

[Curtis Rutland]

The problem is that you never execute your command.

Read through the database articles that tlhintoq posted, and always remember to close your open connections.