SQL怎么把多表查到的数据添加到一个表里 insert into C表select A表,B表数据类似上面的语句就可以啊,列对应好就可以 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 通过查询2个表的联合查询(加上查询条件where, select a.a1,b.b1 from a,b where a.id=b.id string connectionString = "Data Source=192.168.1.3;Initial Catalog=data;User ID=sa;password=sa;Integrated Security=False"; string queryString = "select a.a1,b.b1 from a,b where a.id=b.id"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); try { while (reader.Read()) { i++; string s0 = reader[0].ToString().Trim(); string s1 = reader[1].ToString().Trim(); //入库 insertdata(s0, s1,); } } finally { command.Dispose(); connection.Close(); //写入数据插入入函数public void insertdata(string s1, string s2)//插入数据库 { SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand(string.Format("select Count(*) from newtable where a= '{0}'", s1), con); if ((int)cmd.ExecuteScalar() > 0) { listBox1.Items.Add(s1 + " 数据已经存在"); } else { string sql = "insert into newtable(v1,v2) values('" + s1 + "','" + s2 +"')"; cmd.CommandText = sql; cmd.ExecuteNonQuery(); listBox1.Items.Add(s1 + " 成功添加"); } cmd.Dispose(); con.Close(); } } 【求助】C#写的程序有什么办法能在安桌系统的手机上运行 请问,btye数组里存的什么东西? winform DataGridView 导出到Excel问题 string to DateTime的问题 说一说关于c#的开发项目的经验,交流一下, c#小菜鸟紧急求助! 控件数组 如何使DATAGRID在任何情况下都只选中当前行 WMEncoder 9 Series SDK问题,急!! rose 能否 生成 。net 代码吗 ? 关于模式窗口this.Close()后窗体是释放了吗? C# DEV GridControl 绑定List, 数据项用接口, 怎么可以绑定子类?
string connectionString = "Data Source=192.168.1.3;Initial Catalog=data;User ID=sa;password=sa;Integrated Security=False";
string queryString = "select a.a1,b.b1 from a,b where a.id=b.id";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
i++;
string s0 = reader[0].ToString().Trim();
string s1 = reader[1].ToString().Trim();
//入库
insertdata(s0, s1,);
}
}
finally
{
command.Dispose();
connection.Close();
//写入数据插入入函数
public void insertdata(string s1, string s2)//插入数据库
{
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd = new SqlCommand(string.Format("select Count(*) from newtable where a= '{0}'", s1), con);
if ((int)cmd.ExecuteScalar() > 0)
{
listBox1.Items.Add(s1 + " 数据已经存在");
}
else
{
string sql = "insert into newtable(v1,v2) values('" + s1 + "','" + s2 +"')";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
listBox1.Items.Add(s1 + " 成功添加");
}
cmd.Dispose();
con.Close();
}
}