怎么获取文本框的值插入数据

Question

获取页面文本框的值 插入到数据库中怎么获取时间空间的时间 插入到数据库中？？？

Answer 1

建议不要急，先把基础看好，看看ADO.net吧

Answer 2

不急不行啊  急着用  我有类库 怎么用？using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.Sql;
using System.Data.SqlClient;/// <summary>
/// database 的摘要说明
/// </summary>
/// namespace data
{
    public class database
    {
      //  private static string connstr = ConfigurationSettings.AppSettings["ServerConnection"];
        protected SqlConnection conn = new SqlConnection();
        protected String connstr;
        public database()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //  
            
            connstr = "server=.;database=baoxian;uid=sa;pwd=;";
            
        }
        ~database()
        {
            try
            {
                if (conn != null)
                    conn.Close();
            }
            catch { }
            try
            {
                dispose();
            }
            catch { }
        }
        public void dispose()
        {
            if (conn != null)
            {
                conn.Dispose();
                conn = null;
            }
        }
        protected void open()
        {
            conn.ConnectionString = connstr;
            conn.Open();
        }
        public void close()
        {
            if (conn != null)
                conn.Close();
        }
        public int ExecuteSql(String SqlString)
        {
            int count = -1;
            open();
            try
            {
                SqlCommand cmd = new SqlCommand(SqlString, conn);
                count = cmd.ExecuteNonQuery();
            }
            catch
            {
                count = -1;
            }
            finally
            {
                close();
            }
            return count;
        }
        public DataTable getdatatable(String sqlstring)
        {
            open();
            SqlDataAdapter adapter = new SqlDataAdapter(sqlstring, conn);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            close();
            return dt;
        }
        public SqlDataReader getdatareader(String sqlstring)
        {
            open();
            SqlCommand cmd = new SqlCommand(sqlstring, conn);
            SqlDataReader dr = cmd.ExecuteReader();
            return dr;
        }
        public DataSet getmyds(String sqlstring)
        {
            open();
            SqlDataAdapter da = new SqlDataAdapter(sqlstring, conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            close();
            return ds;
        }
    }
}

Answer 3

这么写对吗？
    protected void Button1_Click(object sender, EventArgs e)
    {
        database db = new database();
            string tb1 = TextBox1.Text;
            string tb2 = TextBox2.Text;
            string tb3 = TextBox3.Text;
            string tb4 = TextBox4.Text;
            string tb5 = TextBox5.Text;
            string tb6 = TextBox6.Text;
            string tb7 = TextBox7.Text;             string insert1="INSERT INTO ZD_AGENT (ID,AGENT_CODE, AGENT_NAME, TELEPHONE, CREATE_DATE, UPDATE_DATE,  DEL_FLAG) VALUES (@tb1,@tb2,@tb3,@tb4,@tb5,@tb6,@tb7)";
             DataTable dt = db.getdatatable(insert1);
           
    }

Answer 4

你的代码是错误的认真看看ado.net的书

Answer 5

 public DataTable getdatatable(String sqlstring)
        {
            open();
            SqlDataAdapter adapter = new SqlDataAdapter(sqlstring, conn);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            close();
            return dt;
        }
这个是获取数据的，你这个是插入不数据，不对了

Answer 6

把你的getdatatable换成ExecuteSql才是执行Sql语句

Answer 7

int i=db.ExecuteSql(insert1);
i是受影响的行数

Answer 8

数据库的操作，在你实例化连接对象之后，指定连接字符串。然后打开连接。在你的这个例子中，你必须在DataTable dt = db.getdatatable(insert1);之前调用db.open()，问题就可以解决了；
因为你实例化了db，但是中的连接字符串没有被指定，连接是要出问题的。