ช่วยดูให้หน่อยครับ ทำไมมันบันทึกลง Database ไม่ได้ ในหน้า ปัญหาเกี่ยวกับข้อมูลโปรดตรวจสอบ" End Try End Sub End Class
ในหน้าDefault1.aspxCode (VB.NET) <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default1.aspx.vb" Inherits="Default1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td style="width: 100px">
</td>
<td style="width: 100px">
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 100px">
</td>
<td style="width: 100px">
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 100px">
</td>
<td style="width: 100px">
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td>
</tr>
</table>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</div>
<asp:Button ID="Button1" runat="server" Text="Button" />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id"
DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True" SortExpression="id" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
<asp:BoundField DataField="tel" HeaderText="tel" SortExpression="tel" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
DeleteCommand="DELETE FROM [user] WHERE [id] = @id" InsertCommand="INSERT INTO [user] ([id], [name], [tel]) VALUES (@id, @name, @tel)"
ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
SelectCommand="SELECT [id], [name], [tel] FROM [user]" UpdateCommand="UPDATE [user] SET [name] = @name, [tel] = @tel WHERE [id] = @id">
<InsertParameters>
<asp:Parameter Name="id" Type="String" />
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="tel" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="tel" Type="String" />
<asp:Parameter Name="id" Type="String" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="id" Type="String" />
</DeleteParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
Code (VB.NET) Imports System.IO
Imports System.Data.SqlClient
Imports System.Data
Partial Class Default1
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Label1.Text = ""
Dim connection As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"
Dim conn As New SqlConnection(connection)
conn.Open()
Try
Dim comm As String = "INSERT INTO user (id,name,tel) "
comm &= " VALUES ('" & TextBox1.Text & "',"
comm &= "'" & TextBox2.Text & "',"
comm &= "'" & TextBox3.Text & "')"
Dim command As New SqlCommand(comm, conn)
command.ExecuteNonQuery()
conn.Close()
Response.Redirect("Default1.aspx")
Catch ex As Exception
Label1.Text = "พบปัญหาเกี่ยวกับข้อมูลโปรดตรวจสอบ"
End Try
End Sub
End Class
Tag
Date :
2009-12-07 03:41:37By :
nunghangbeerView :
1372Reply :
5
ลองเพิ่ม conn = Nothing ต่อจาก conn.Close()
Date :
2009-12-07 04:13:39By :
OHNO
ลองดูแล้วครับไม่ได้ แต่ขอบคุณมากครับ
Date :
2009-12-07 13:26:20By :
nunghangbeer
Debug ที่ ex.Message ไม่มี Error เลยเหรอครับ
Date :
2009-12-07 13:40:24By :
webmaster
ทำได้แล้วครับ ขอบคุณมากครับ
Date :
2009-12-08 03:27:37By :
nunghangbeer
คุณ nung แก้อย่างไรค่ะ
Date :
2009-12-10 20:16:14By :
kik
Server 00
Load balance : Server 00
