C# ASP.NET的菜鸟问题

本人刚接触,现在想用C#语言在VS2005里写连接SQL2000的语句,可是写不来,我数据库建好了,现在在VS里加了个注册信息的确定按钮,我想点确定的时候,把我填写我资料更新到SQL的数据库存里,不懂咋写,望指教,谢谢!

SQL语句你会写吧，写SQL语句就行了。
//首先引用命名空间
using System;
using System.Data;
using System.Data.SqlClient;

//添加
public void ins()
{
string sqlconn = "server=.;database=dbname;uid=sa;pwd=sa";//连接字串
SqlConnection conn = new SqlConnection(sqlconn);
conn.Open();
string sql = "insert into goods(Id,Name,Descn) values('1233','abcd','cat')"; //查询语句
SqlCommand cmd = new SqlCommand(sql,conn);
int result = cmd.ExecuteNonQuery();
conn.Close();
}

//查询
private DataTable select()
{
string sqlconn = "server=.;database=dbname;uid=sa;pwd=sa";//连接字串
SqlConnection conn = new SqlConnection(sqlconn);
conn.Open();
string sql = "select * from goods";//查询语句
SqlDataAdapter adapter = new SqlDataAdapter(sql,conn);
DataTable dt = new DataTable();
adapter.Fill(dt);
conn.Close();
return dt;