62,046
社区成员
发帖
与我相关
我的任务
分享SQL->access
前台
<head runat="server">
<title>无标题页 </title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="url" runat="server"> </asp:textbox> //播放地址
<asp:linkbutton id="add" runat="server" OnClick="add_Click">上传 </asp:linkbutton> //上传按钮
</div>
</form>
</body>
</html>
后台
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void add_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings[""].ToString());
cn.Open();
string url = this.add.Text.Trim();
string strSQL = "insert into 要插入的表名 地址表名=N'" + url + "";
SqlCommand cm = new SqlCommand(strSQL, cn);
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
da.SelectCommand = cm;
da.Fill(dt);
cn.Close();
}
}
问题是 我不会看SQl2000 我只会 Access 谁能帮我把后台的 写成 access
<head runat="server">
<title>无标题页 </title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="url" runat="server"> </asp:textbox> //播放地址
<asp:linkbutton id="add" runat="server" OnClick="add_Click">上传 </asp:linkbutton> //上传按钮
</div>
</form>
</body>
</html>
后台
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void add_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings[""].ToString());
cn.Open();
string url = this.add.Text.Trim();
string strSQL = "insert into 要插入的表名 地址表名=N'" + url + "";
SqlCommand cm = new SqlCommand(strSQL, cn);
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
da.SelectCommand = cm;
da.Fill(dt);
cn.Close();
}
}
问题是 我不会看SQl2000 我只会 Access 谁能帮我把后台的 写成 access
...全文
请发表友善的回复…
发表回复
