INSERT INTO AddressBook () 括号里加上所有字段试试,
好久没碰asp了
好久没碰asp了
解决方案 »
- 小弟刚学ADO.NET,进来问个问题
- 求教。类型转换的问题
- 鱼与熊撑如何兼得?(含有AJAX Control的页面中如何下载文件)(180分)
- using System.Transactions;
- 使用System.Net.Mail;发送邮件,对方邮箱名如果包含小数点,比如[email protected]会报错,如何解决呢?
- 问一个关于音乐播放的问题
- 强烈求助:网站打开后是空白页!
- 求助:怎样在WebForm中取得鼠标的坐标? 用VB~!谢谢先!
- 深圳、广州的请进来!?
- 请问Brinkster里为什么显示中文是乱码?这里真能用ASPX吗??请高手指点!!
- ■■谁知道一个WIN2000-professor下的PWS安装下载的网址,给出立即加分!!■■
- 在赋值时如何让DropDownList的值跳到相应的Items项???
conn = "Provider=SQLOLEDB; Integrated Security=SSPI; Initial Catalog=AddressDB;"
有什么问题
为什么不用dsn呢?
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "dsn=yourdsn;uid=yourname;pwd=youropass
"多简单!
Conn.Open "dsn=yourdsn;uid=yourname;pwd=youropass"
Set Rs=Server.CreateObject("adodb.recordset")
Rs.open "select * from yourtable"
下面就可以操作了
Rs.open "select * from yourtable" ,conn,1,3
至于什么是dsn,不是一两句能说情的,你看看书吧
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>贴段代码给你
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="C#" runat="server"> SqlConnection myConnection; protected void Page_Load(Object Src, EventArgs E)
{
myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Trusted_Connection=yes"); if (!IsPostBack)
BindGrid();
} public void AddAuthor_Click(Object sender, EventArgs E)
{
Message.InnerHtml = ""; if (Page.IsValid)
{ String insertCmd = "insert into Authors (au_id, au_lname, au_fname, phone, address, city, state, zip, contract) values (@Id, @LName, @FName, @Phone, @Address, @City, @State, @Zip, @Contract)"; SqlCommand myCommand = new SqlCommand(insertCmd, myConnection); myCommand.Parameters.Add(new SqlParameter("@Id", SqlDbType.NVarChar, 11));
myCommand.Parameters["@Id"].Value = Server.HtmlEncode(au_id.Value); myCommand.Parameters.Add(new SqlParameter("@LName", SqlDbType.NVarChar, 40));
myCommand.Parameters["@LName"].Value = Server.HtmlEncode(au_lname.Value); myCommand.Parameters.Add(new SqlParameter("@FName", SqlDbType.NVarChar, 20));
myCommand.Parameters["@FName"].Value = Server.HtmlEncode(au_fname.Value); myCommand.Parameters.Add(new SqlParameter("@Phone", SqlDbType.NChar, 12));
myCommand.Parameters["@Phone"].Value = Server.HtmlEncode(phone.Value); myCommand.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 40));
myCommand.Parameters["@Address"].Value = Server.HtmlEncode(address.Value); myCommand.Parameters.Add(new SqlParameter("@City", SqlDbType.NVarChar, 20));
myCommand.Parameters["@City"].Value = Server.HtmlEncode(city.Value); myCommand.Parameters.Add(new SqlParameter("@State", SqlDbType.NChar, 2));
myCommand.Parameters["@State"].Value = state.Value; myCommand.Parameters.Add(new SqlParameter("@Zip", SqlDbType.NChar, 5));
myCommand.Parameters["@Zip"].Value = Server.HtmlEncode(zip.Value); myCommand.Parameters.Add(new SqlParameter("@Contract", SqlDbType.NVarChar,1));
myCommand.Parameters["@Contract"].Value = contract.Value; myCommand.Connection.Open(); try
{
myCommand.ExecuteNonQuery();
Message.InnerHtml = "<b>Record Added</b><br>" + insertCmd + "<p>";
}
catch (SqlException e)
{
if (e.Number == 2627)
Message.InnerHtml = "ERROR: A record already exists with the same primary key<p>";
else
Message.InnerHtml = "ERROR: Could not add record, please ensure the fields are correctly filled out<p>";
Message.Style["color"] = "red";
} myCommand.Connection.Close();
} BindGrid();
} public void BindGrid()
{
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Authors", myConnection); DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors"); MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
}</script>
……
myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;Trusted_Connection=yes");中的server改为sql server的机器名字就可以了