int num = int.Parse(TGY.DBUtility.DbHelperSQL.GetResult("select count(0) from [test].[dbo].[Loupanzidiantest] where city='" + new Common().GetCity() + "'"));
//Response.Write(num);
DataSet ds = TGY.DBUtility.DbHelperSQL.GetDataSet("select * from [test].[dbo].[Loupanzidiantest] where city='" + new Common().GetCity() + "'");
DataTable dt = null;
if (ds != null)
{
dt = ds.Tables[0];
}
int iNumber = 0; if (dt != null)
{
iNumber = dt.Rows.Count;
} for (int i = 0; i < num; i++)
{ MyLoupanzidian.name = dt.Rows[i]["name"].ToString();
MyLoupanzidian.name2 = dt.Rows[i]["name2"].ToString();
MyLoupanzidian.wuyeyongtu = dt.Rows[i]["wuyeyongtu"].ToString();
MyLoupanzidian.wuyeleixing = dt.Rows[i]["wuyeleixing"].ToString();
MyLoupanzidian.jianchengnianfen = dt.Rows[i]["jianchengnianfen"].ToString();
MyLoupanzidian.city = dt.Rows[i]["city"].ToString();
MyLoupanzidian.area = dt.Rows[i]["area"].ToString();
MyLoupanzidian.subarea = dt.Rows[i]["subarea"].ToString();
MyLoupanzidian.wuyefei = dt.Rows[i]["wuyefei"].ToString();
MyLoupanzidian.address = dt.Rows[i]["address"].ToString();
MyLoupanzidian.lvhualv = dt.Rows[i]["lvhualv"].ToString();
MyLoupanzidian.kaifashang = dt.Rows[i]["kaifashang"].ToString();
MyLoupanzidian.tingchewei = dt.Rows[i]["tingchewei"].ToString();
MyLoupanzidian.wuyegongsi = dt.Rows[i]["wuyegongsi"].ToString();
MyLoupanzidian.rongjilv = dt.Rows[i]["rongjilv"].ToString();
MyLoupanzidian.gongjiaoxianlu = dt.Rows[i]["gongjiaoxianlu"].ToString();
MyLoupanzidian.ditiexianlu = dt.Rows[i]["ditiexianlu"].ToString();
MyLoupanzidian.zhoubianxuexiao = dt.Rows[i]["zhoubianxuexiao"].ToString();
MyLoupanzidian.zhoubiangouwu = dt.Rows[i]["zhoubiangouwu"].ToString();
MyLoupanzidian.zhoubiancanyin = dt.Rows[i]["zhoubiancanyin"].ToString();
MyLoupanzidian.zhoubianyinhang = dt.Rows[i]["zhoubianyinhang"].ToString();
MyLoupanzidian.zhoubianyiyuan = dt.Rows[i]["zhoubianyiyuan"].ToString();
MyLoupanzidian.zhoubianqita = dt.Rows[i]["zhoubianqita"].ToString();
MyLoupanzidian.description = dt.Rows[i]["description"].ToString();
MyLoupanzidian.salenumber = int.Parse(string.IsNullOrEmpty(dt.Rows[i]["salenumber"].ToString()) ? "0" : dt.Rows[i]["salenumber"].ToString());
MyLoupanzidian.rentnumber = int.Parse(string.IsNullOrEmpty(dt.Rows[i]["rentnumber"].ToString()) ? "0" : dt.Rows[i]["rentnumber"].ToString());
MyLoupanzidian.jianzhumianji = dt.Rows[i]["jianzhumianji"].ToString();
MyLoupanzidian.zhandimianji = dt.Rows[i]["zhandimianji"].ToString();
MyLoupanzidian.username = dt.Rows[i]["username"].ToString();
MyLoupanzidian.createtime = Convert.ToDateTime(dt.Rows[i]["createtime"].ToString());
MyLoupanzidian.zhanshitu = dt.Rows[i]["zhanshitu"].ToString();
MyLoupanzidian.fromurl = dt.Rows[i]["fromurl"].ToString();
//MyLoupanzidian.jianpin = dt.Rows[i]["jianpin"].ToString();
MyLoupanzidian.quanpin = dt.Rows[i]["quanpin"].ToString();
MyLoupanzidian.other = dt.Rows[i]["other"].ToString();
MyLoupanzidian.Add();
}
int iNumber1 = MyLoupanzidian.Add(); if (iNumber1 > 0)
{
TGY.Common.MessageBox.ShowAndRedirect("操作成功!", "Loupanzidian_List.aspx");
Response.End();
}
else
{
TGY.Common.MessageBox.ShowAndRedirect("操作失败!", "Loupanzidian_Add.aspx");
Response.End();
} }
上述代码添加数据添加不进去,可是也不报错,打断点也有数据是怎么回事?
//Response.Write(num);
DataSet ds = TGY.DBUtility.DbHelperSQL.GetDataSet("select * from [test].[dbo].[Loupanzidiantest] where city='" + new Common().GetCity() + "'");
DataTable dt = null;
if (ds != null)
{
dt = ds.Tables[0];
}
int iNumber = 0; if (dt != null)
{
iNumber = dt.Rows.Count;
} for (int i = 0; i < num; i++)
{ MyLoupanzidian.name = dt.Rows[i]["name"].ToString();
MyLoupanzidian.name2 = dt.Rows[i]["name2"].ToString();
MyLoupanzidian.wuyeyongtu = dt.Rows[i]["wuyeyongtu"].ToString();
MyLoupanzidian.wuyeleixing = dt.Rows[i]["wuyeleixing"].ToString();
MyLoupanzidian.jianchengnianfen = dt.Rows[i]["jianchengnianfen"].ToString();
MyLoupanzidian.city = dt.Rows[i]["city"].ToString();
MyLoupanzidian.area = dt.Rows[i]["area"].ToString();
MyLoupanzidian.subarea = dt.Rows[i]["subarea"].ToString();
MyLoupanzidian.wuyefei = dt.Rows[i]["wuyefei"].ToString();
MyLoupanzidian.address = dt.Rows[i]["address"].ToString();
MyLoupanzidian.lvhualv = dt.Rows[i]["lvhualv"].ToString();
MyLoupanzidian.kaifashang = dt.Rows[i]["kaifashang"].ToString();
MyLoupanzidian.tingchewei = dt.Rows[i]["tingchewei"].ToString();
MyLoupanzidian.wuyegongsi = dt.Rows[i]["wuyegongsi"].ToString();
MyLoupanzidian.rongjilv = dt.Rows[i]["rongjilv"].ToString();
MyLoupanzidian.gongjiaoxianlu = dt.Rows[i]["gongjiaoxianlu"].ToString();
MyLoupanzidian.ditiexianlu = dt.Rows[i]["ditiexianlu"].ToString();
MyLoupanzidian.zhoubianxuexiao = dt.Rows[i]["zhoubianxuexiao"].ToString();
MyLoupanzidian.zhoubiangouwu = dt.Rows[i]["zhoubiangouwu"].ToString();
MyLoupanzidian.zhoubiancanyin = dt.Rows[i]["zhoubiancanyin"].ToString();
MyLoupanzidian.zhoubianyinhang = dt.Rows[i]["zhoubianyinhang"].ToString();
MyLoupanzidian.zhoubianyiyuan = dt.Rows[i]["zhoubianyiyuan"].ToString();
MyLoupanzidian.zhoubianqita = dt.Rows[i]["zhoubianqita"].ToString();
MyLoupanzidian.description = dt.Rows[i]["description"].ToString();
MyLoupanzidian.salenumber = int.Parse(string.IsNullOrEmpty(dt.Rows[i]["salenumber"].ToString()) ? "0" : dt.Rows[i]["salenumber"].ToString());
MyLoupanzidian.rentnumber = int.Parse(string.IsNullOrEmpty(dt.Rows[i]["rentnumber"].ToString()) ? "0" : dt.Rows[i]["rentnumber"].ToString());
MyLoupanzidian.jianzhumianji = dt.Rows[i]["jianzhumianji"].ToString();
MyLoupanzidian.zhandimianji = dt.Rows[i]["zhandimianji"].ToString();
MyLoupanzidian.username = dt.Rows[i]["username"].ToString();
MyLoupanzidian.createtime = Convert.ToDateTime(dt.Rows[i]["createtime"].ToString());
MyLoupanzidian.zhanshitu = dt.Rows[i]["zhanshitu"].ToString();
MyLoupanzidian.fromurl = dt.Rows[i]["fromurl"].ToString();
//MyLoupanzidian.jianpin = dt.Rows[i]["jianpin"].ToString();
MyLoupanzidian.quanpin = dt.Rows[i]["quanpin"].ToString();
MyLoupanzidian.other = dt.Rows[i]["other"].ToString();
MyLoupanzidian.Add();
}
int iNumber1 = MyLoupanzidian.Add(); if (iNumber1 > 0)
{
TGY.Common.MessageBox.ShowAndRedirect("操作成功!", "Loupanzidian_List.aspx");
Response.End();
}
else
{
TGY.Common.MessageBox.ShowAndRedirect("操作失败!", "Loupanzidian_Add.aspx");
Response.End();
} }
上述代码添加数据添加不进去,可是也不报错,打断点也有数据是怎么回事?
int iNumber1 = MyLoupanzidian.Add(); 这里不是很明白,是不是还有一个update()或save()之类的?
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Loupanzidian] (");
strSql.Append("name,name2,wuyeyongtu,wuyeleixing,jianchengnianfen,city,area,subarea,wuyefei,address,lvhualv,kaifashang,tingchewei,wuyegongsi,rongjilv,gongjiaoxianlu,ditiexianlu,zhoubianxuexiao,zhoubiangouwu,zhoubiancanyin,zhoubianyinhang,zhoubianyiyuan,zhoubianqita,description,salenumber,rentnumber,jianzhumianji,zhandimianji,username,createtime,zhanshitu,fromurl,jianpin,quanpin,other)");
strSql.Append(" values (");
strSql.Append("@name,@name2,@wuyeyongtu,@wuyeleixing,@jianchengnianfen,@city,@area,@subarea,@wuyefei,@address,@lvhualv,@kaifashang,@tingchewei,@wuyegongsi,@rongjilv,@gongjiaoxianlu,@ditiexianlu,@zhoubianxuexiao,@zhoubiangouwu,@zhoubiancanyin,@zhoubianyinhang,@zhoubianyiyuan,@zhoubianqita,@description,@salenumber,@rentnumber,@jianzhumianji,@zhandimianji,@username,@createtime,@zhanshitu,@fromurl,@jianpin,@quanpin,@other)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@name", SqlDbType.VarChar,50),
new SqlParameter("@name2", SqlDbType.VarChar,50),
new SqlParameter("@wuyeyongtu", SqlDbType.VarChar,50),
new SqlParameter("@wuyeleixing", SqlDbType.VarChar,50),
new SqlParameter("@jianchengnianfen", SqlDbType.VarChar,50),
new SqlParameter("@city", SqlDbType.VarChar,50),
new SqlParameter("@area", SqlDbType.VarChar,50),
new SqlParameter("@subarea", SqlDbType.VarChar,50),
new SqlParameter("@wuyefei", SqlDbType.VarChar,50),
new SqlParameter("@address", SqlDbType.VarChar,200),
new SqlParameter("@lvhualv", SqlDbType.VarChar,50),
new SqlParameter("@kaifashang", SqlDbType.VarChar,200),
new SqlParameter("@tingchewei", SqlDbType.VarChar,200),
new SqlParameter("@wuyegongsi", SqlDbType.VarChar,50),
new SqlParameter("@rongjilv", SqlDbType.VarChar,50),
new SqlParameter("@gongjiaoxianlu", SqlDbType.Text),
new SqlParameter("@ditiexianlu", SqlDbType.Text),
new SqlParameter("@zhoubianxuexiao", SqlDbType.Text),
new SqlParameter("@zhoubiangouwu", SqlDbType.Text),
new SqlParameter("@zhoubiancanyin", SqlDbType.Text),
new SqlParameter("@zhoubianyinhang", SqlDbType.Text),
new SqlParameter("@zhoubianyiyuan", SqlDbType.Text),
new SqlParameter("@zhoubianqita", SqlDbType.Text),
new SqlParameter("@description", SqlDbType.Text),
new SqlParameter("@salenumber", SqlDbType.Int,4),
new SqlParameter("@rentnumber", SqlDbType.Int,4),
new SqlParameter("@jianzhumianji", SqlDbType.VarChar,50),
new SqlParameter("@zhandimianji", SqlDbType.VarChar,50),
new SqlParameter("@username", SqlDbType.VarChar,50),
new SqlParameter("@createtime", SqlDbType.DateTime),
new SqlParameter("@zhanshitu", SqlDbType.VarChar,200),
new SqlParameter("@fromurl", SqlDbType.VarChar,500),
new SqlParameter("@jianpin", SqlDbType.VarChar,100),
new SqlParameter("@quanpin", SqlDbType.VarChar,100),
new SqlParameter("@other", SqlDbType.Text)};
parameters[0].Value = name;
parameters[1].Value = name2;
parameters[2].Value = wuyeyongtu;
parameters[3].Value = wuyeleixing;
parameters[4].Value = jianchengnianfen;
parameters[5].Value = city;
parameters[6].Value = area;
parameters[7].Value = subarea;
parameters[8].Value = wuyefei;
parameters[9].Value = address;
parameters[10].Value = lvhualv;
parameters[11].Value = kaifashang;
parameters[12].Value = tingchewei;
parameters[13].Value = wuyegongsi;
parameters[14].Value = rongjilv;
parameters[15].Value = gongjiaoxianlu;
parameters[16].Value = ditiexianlu;
parameters[17].Value = zhoubianxuexiao;
parameters[18].Value = zhoubiangouwu;
parameters[19].Value = zhoubiancanyin;
parameters[20].Value = zhoubianyinhang;
parameters[21].Value = zhoubianyiyuan;
parameters[22].Value = zhoubianqita;
parameters[23].Value = description;
parameters[24].Value = salenumber;
parameters[25].Value = rentnumber;
parameters[26].Value = jianzhumianji;
parameters[27].Value = zhandimianji;
parameters[28].Value = username;
parameters[29].Value = createtime;
parameters[30].Value = zhanshitu;
parameters[31].Value = fromurl;
parameters[32].Value = jianpin;
parameters[33].Value = quanpin;
parameters[34].Value = other; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
obj 是多少?执行完之后 iNumber1 又为多少?
obj 是多少?执行完之后 iNumber1 又为多少?obj为null,大神,这是咋回事??
obj 是多少?执行完之后 iNumber1 又为多少?obj为null,大神,这是咋回事??我不是大神说实话,看到现在我真心不知道你这到底是 ORM 还是传统的 ADO.NET 方式在写了。
obj 是多少?执行完之后 iNumber1 又为多少?obj为null,大神,这是咋回事??我不是大神说实话,看到现在我真心不知道你这到底是 ORM 还是传统的 ADO.NET 方式在写了。
我也不知道啊,因为初学者,所以东拼西凑,只想实现功能啊
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
try
{
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
object obj = cmd.ExecuteScalar();
cmd.Parameters.Clear();
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
connection.Close();
return null;
}
else
{
connection.Close();
return obj;
}
}
catch (System.Data.SqlClient.SqlException e)
{
connection.Close();
//throw e;
return null;
}
}
}
}
从test数据库中的loupanzidiantest把数据传到dball中的loupanzidian
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
。。
}
}
从test数据库中的loupanzidiantest把数据传到dball中的loupanzidian为什么不调用添加的方法?你的 DBHelperSQL 中应该有添加的方法吧?
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
。。
}
}
从test数据库中的loupanzidiantest把数据传到dball中的loupanzidian为什么不调用添加的方法?你的 DBHelperSQL 中应该有添加的方法吧?
这个类都是生成的,只可能是我前面的方法写错了,这里不会有错的应该
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
。。
}
}
从test数据库中的loupanzidiantest把数据传到dball中的loupanzidian为什么不调用添加的方法?你的 DBHelperSQL 中应该有添加的方法吧?
这个类都是生成的,只可能是我前面的方法写错了,这里不会有错的应该其实你的初衷也就是要添加的同时知道他是不是添加成功的吧?如果是,那个你找 ExecuteNonQuery 判断受影响行数就好了,没任何必要用 ExecuteScalar , ExecuteScalar 通常用于查询。
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
。。
}
}
从test数据库中的loupanzidiantest把数据传到dball中的loupanzidian为什么不调用添加的方法?你的 DBHelperSQL 中应该有添加的方法吧?
这个类都是生成的,只可能是我前面的方法写错了,这里不会有错的应该其实你的初衷也就是要添加的同时知道他是不是添加成功的吧?如果是,那个你找 ExecuteNonQuery 判断受影响行数就好了,没任何必要用 ExecuteScalar , ExecuteScalar 通常用于查询。
多谢大神,我解决了,因为链接了多个数据库,有重名的表,去掉链接就好了