网上拍卖系统!!!!!!! 从http://chs.gotdotnet.com/quickstart/default.aspx开始吧 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 连结数据库的部分代码如下: string sql="select * from 表名 where 条件 " string SqlServerconnstring="Data Source= ;UserId= ;Password= ;Initial Catalog=North wind"; SqlServerConnection conn=new SqlServerConnection (SqlServerconnstring); SqlServerDataAdapter oradap=new SqlServerDataAdapter(sql,conn); DataSet ds=new DataSet(); oradap.Fill(ds,"yh"); 我连接数据库的代码大致是这样的: SqlConnection myConnection; SqlCommand MC; myConnection = new SqlConnection ("data source=zjnu;initial catalog=goods;user id=sa"); try { string month=yf.SelectedItem.Text; string day = rq.SelectedItem.Text; string hour= sj.SelectedItem.Text; int month1 = Convert.ToInt32(month); int day1 = Convert.ToInt32(day); int hour1 = Convert.ToInt32(hour); int year1 = 2003; DateTime date = new DateTime(year1,month1,day1); string insertCmd = "insert into goodsmsg(spmc,qpjg,kssj,cxsj,wpms) values (@spmc,@qpjg,@kssj,@cxsj,@wpms)"; MC = new SqlCommand(insertCmd,myConnection); MC.Parameters.Add(new SqlParameter("@spmc",SqlDbType.NVarChar, 30)); MC.Parameters["@spmc"].Value = goodname.Text; MC.Parameters.Add(new SqlParameter("@qpjg",SqlDbType.Int,4)); MC.Parameters["@qpjg"].Value = qpjg.Text; MC.Parameters.Add(new SqlParameter("@kssj",SqlDbType.DateTime,8)); MC.Parameters["@kssj"].Value = date; MC.Parameters.Add(new SqlParameter("@cxsj",SqlDbType.Int,4)); MC.Parameters["@cxsj"].Value = cxsj.Text; MC.Parameters.Add(new SqlParameter("@wpms",SqlDbType.NVarChar,300)); MC.Parameters["@wpms"].Value = wpms.Text; myConnection.Open(); MC.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { myConnection.Close(); } 网页中怎么控制不让同一个账号在不同地方同时登陆? ASP.NET 三成架构 SqlDataReader 问题 请问正则表达式能实现这样的功能吗? 框架间取控件值问题。frameset中A页面取B页面的TextBox值怎么取? 数据绑定控件,字符串截取问题? 按钮不响应该怎么办 好心人请提供试题,谢谢,200分 有关框架网页 最近招 .net 程序员的贴子越来越多,值得庆贺一下。散分了。。。 “/asp.netwebadminfiles”应用程序中的服务器错误。 有哪位喜欢asp.net的朋友是广州的? DataGrid中如何为某列设置链接啊
string sql="select * from 表名 where 条件 "
string SqlServerconnstring="Data Source= ;UserId= ;Password= ;Initial Catalog=North wind";
SqlServerConnection conn=new SqlServerConnection (SqlServerconnstring);
SqlServerDataAdapter oradap=new SqlServerDataAdapter(sql,conn);
DataSet ds=new DataSet();
oradap.Fill(ds,"yh");
SqlConnection myConnection;
SqlCommand MC;
myConnection = new SqlConnection
("data source=zjnu;initial catalog=goods;user id=sa");
try
{
string month=yf.SelectedItem.Text;
string day = rq.SelectedItem.Text;
string hour= sj.SelectedItem.Text;
int month1 = Convert.ToInt32(month);
int day1 = Convert.ToInt32(day);
int hour1 = Convert.ToInt32(hour);
int year1 = 2003;
DateTime date = new DateTime(year1,month1,day1);
string insertCmd = "insert into goodsmsg(spmc,qpjg,kssj,cxsj,wpms) values (@spmc,@qpjg,@kssj,@cxsj,@wpms)";
MC = new SqlCommand(insertCmd,myConnection);
MC.Parameters.Add(new SqlParameter("@spmc",SqlDbType.NVarChar, 30));
MC.Parameters["@spmc"].Value = goodname.Text;
MC.Parameters.Add(new SqlParameter("@qpjg",SqlDbType.Int,4));
MC.Parameters["@qpjg"].Value = qpjg.Text;
MC.Parameters.Add(new SqlParameter("@kssj",SqlDbType.DateTime,8));
MC.Parameters["@kssj"].Value = date;
MC.Parameters.Add(new SqlParameter("@cxsj",SqlDbType.Int,4));
MC.Parameters["@cxsj"].Value = cxsj.Text;
MC.Parameters.Add(new SqlParameter("@wpms",SqlDbType.NVarChar,300));
MC.Parameters["@wpms"].Value = wpms.Text;
myConnection.Open();
MC.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
myConnection.Close();
}