visual studio2005问题

LikMin · 发表于 5-6-2006 03:24 PM

我在用着visual studio2005
请问如何在一个html的text box 的value store去mysql database 啊....

connectionstring 我已经set好。。。

<input name="fname" onblur="fnameChk()" id="Text1" />

如这个fname如何store去database的firstname啊。。。在onlick submit button之后

小妞儿 · 发表于 6-6-2006 08:07 PM

<%@ Page Language="VB" %>
<%@ import Namespace="system.data.oledb" %>
<script runat="server">

sub btnSubmit_Click(s as object, e as eventargs)
      dim strConn as string = "your connection string"
      dim strSql as string = "insert into [blog] (Title) values (@Title)"
      dim MyConn as new oledbconnection(strConn)
      dim cmd as new oledbcommand(strSql, MyConn)
         cmd.parameters.add(new oledbparameter ("@Title", txtFirstName.value))
      MyConn.Open()
      cmd.executenonquery()
      MyConn.Close()
end sub

</script>
<html>
<head>
</head>
<body>
<form runat="server">
      <p>
         First name:<input id="txtFirstName" type="text" runat="server" />
      </p>
      <p>
         <asp:Button id="btnSubmit" onclick="btnSubmit_Click" runat="server" Text="Submit"></asp:Button>
      </p>
</form>
</body>
</html>

LikMin · 发表于 8-6-2006 04:34 PM

解决了，谢谢

		自动登录	找回密码
密码			注册

visual studio2005问题

所属分类: 电脑手机