C#Sql Reader问题 [英] C# Sql Reader Problems
本文介绍了C#Sql Reader问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SqlCommand cmd3 = new SqlCommand( SELECT Column FROM TABLE,conn);
SqlDataReader dr3 = cmd3.ExecuteReader();
string [] numb = new string [ 10 ];
int i = 0 ;
numb = new string [dr3.FieldCount];
while (dr3.Read())
{
tpscevrim =(dr3 [ 列])。ToString();
for (i = 0 ; i < ; dr3.FieldCount; i ++)
{
numb [i] = dr3 [i] .ToString();
}
}
conn.Open();
SqlCommand command = new SqlCommand( UPDATE表SET
+ 列,conn);
command.Parameters.AddWithValue( @ Column,Convert.ToDecimal(islemyaz)) ;
command.ExecuteNonQuery();
conn.Close();
如何更新命令列[0],列[1] ,,,, print ??
update tableName set columnName1 = @ Parameter1,columnName2 = @ Parameter2其中columnName3 = @ Parameter3
然后你可以使用参数名设置参数值
command.Parameters.AddWithValue( @ Parameter1,value1);
command.Parameters.AddWithValue( @ Parameter2,value2);
command.Parameters.AddWithValue( @ Parameter3,value3);
您最好阅读MSDN文档并查看给出的示例 [ ^ ]
哦没有参数确定
更新表格设置列
$ b $bİD自动增量
一列更新
SqlCommand cmd3 = new SqlCommand("SELECT Column FROM TABLE", conn);
SqlDataReader dr3 = cmd3.ExecuteReader();
string[] numb=new string[10];
int i=0;
numb = new string[dr3.FieldCount];
while (dr3.Read())
{
tpscevrim = (dr3["Column"]).ToString();
for (i = 0; i < dr3.FieldCount; i++)
{
numb[i] = dr3[i].ToString();
}
}
conn.Open();
SqlCommand command = new SqlCommand("UPDATE TABLE SET "
+ "Column", conn);
command.Parameters.AddWithValue("@Column", Convert.ToDecimal(islemyaz));
command.ExecuteNonQuery();
conn.Close();
How To Update Command Column[0],Column[1],,,, print??
解决方案
you haven't include parameter in your update statement, it should be like
"update tableName set columnName1 =@Parameter1, columnName2 =@Parameter2 where columnName3 =@Parameter3"
then you can set the parameter values using parameter names
command.Parameters.AddWithValue("@Parameter1", value1); command.Parameters.AddWithValue("@Parameter2", value2); command.Parameters.AddWithValue("@Parameter3", value3);
you better read the MSDN documentation and check the examples given [^]
Oh no parameters ok
Update table set column where
İD auto increment
One column update
这篇关于C#Sql Reader问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文