数据插入操作类的问题

Question

用2.0写的
dbsql.cs类
执行代码如下:
public void sqlexe(string exesql)
    {
        SqlConnection conn = db.createConnection();
        conn.Open();
        SqlCommand cmd = new SqlCommand(exesql, conn);       
        cmd.ExecuteNonQuery();
        conn.Close();
        
    }点击按钮时调用类:
 protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = db.createConnection();        string exesql = "insert into news (Title,Big_name,Big_id,Small_name,Small_id,I_price,I_num,K_time,J_time,I_type,U_name,I_img,I_info) values ('" + this.title.Text.Trim().Replace("'", "''") + "',";
        exesql += "'" + this.big_name.SelectedItem.Text + "',";
        exesql += "'" + this.big_name.SelectedItem.Value + "',";
        exesql += "'" + this.small_name.SelectedItem.Text + "',";
        exesql += "'" + this.small_name.SelectedItem.Value + "',";
        exesql += "'" + this.price.Text + "',";
        exesql += "'" + this.num.Text + "',";
     
        exesql += "'" + this.K_time.Text.ToString() + "',";
        exesql += "'" + this.J_time.Text.ToString() + "',";
        exesql += "2,";
        exesql += "'" + Session["lk_name_admin"].ToString() + "',";
        exesql += "'" + this.lblimgurl.Text.ToString() + "',";
        exesql += "'" + this.I_info.Text.ToString().Replace("'", "''") + "')";
        dbsql.sqlexe(exesql);
        
           }出现以下
错误 19 非静态的字段、方法或属性“dbsql.sqlexe(string)”要求对象引用 E:\usre_reg\news.aspx.cs 89 9 E:\usre_reg\请问问题出在哪儿呀.>>>

Answer 1

最后一句:
  dbsql.sqlexe(exesql);改成
dbsql d=new dbsql();
d.sqlexe(exesql);

Answer 2

或者你可以把第一句:
public void sqlexe(string exesql)改成:public static void sqlexe(string exesql)//将方法改成静态方法,然后就可以直接调用