写LINQ时遇到的类型转换问题

王祖康 2009-10-25 12:49:31

public partial class _Default : System.Web.UI.Page
{

private void bind()
{
DataClassesDataContext db = new DataClassesDataContext();//实例化LINQ to SQL数据映射

//查询dog表中的所有数据
var query = from em in db.dogs
select new
{
em.dog_id,
em.dog_name,
em.dog_sex,
em.dog_price,
em.dog_type,
em.dog_content,
};
//数值绑定
GridView1.DataSource = query;
GridView1.DataBind();

}

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
this.Panel1.Visible = false;//Panel不可见
}
}
protected void Button2_Click(object sender, EventArgs e)
{
this.Panel1.Visible = true;
}
protected void Button3_Click(object sender, EventArgs e)
{
//获得用户要输入的数据
string strdog_id = TextBox1.Text.Trim().ToString(); ;
string strdog_name = TextBox2.Text.Trim().ToString();
string strdog_sex = TextBox3.Text.Trim().ToString();
string strdog_price = TextBox4.Text.Trim().ToString();
string strdog_type = TextBox5.Text.Trim().ToString();
string strdog_content = TextBox6.Text.Trim().ToString();
//实例化LINQ to SQL数据映射
DataClassesDataContext db = new DataClassesDataContext();
//实例化数据库中dogs表
dogs dg = new dogs();

dg.dog_id = strdog_id; //填充对象成员系统提示无法将string类型转换成int类型 dg.dog_name = strdog_name;
dg.dog_sex = strdog_sex;
dg.dog_price = strdog_price;
dg.dog_type = strdog_type;
dg.dog_content = strdog_content;

db.dogs.InsertAllOnSubmit(dg);
db.SubmitChanges();
this.bind();
this.Panel1.Visible = false;

}
protected void Button4_Click(object sender, EventArgs e)
{
this.Panel1.Visible = false;
}
}

怎样转换？

...全文