Tilføje data i MSSQL
Hej.Jeg må hellere lige starte med at sige at jeg er nybegynder inden for .Net, så det kan sagtens være at min kode kan komme til at virke på under 3 sekunder hvis man ved hvad man laver ;)
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
}
void Page_Load(object sender, EventArgs e) {
if (!Page.IsPostBack){
*besked = fdig dfgfdg;
}
}
</script>
<html xmlns=" http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="sqladdbesked" runat="server" ConnectionString="<%$ ConnectionStrings:simdkConnectionString2 %>"
InsertCommand="INSERT INTO mobilmsgs([from], message) VALUES ('vb', *besked)" SelectCommand="SELECT [when], message, [from] FROM mobilmsgs">
</asp:SqlDataSource>
</div>
<asp:FormView ID="FormView1" runat="server" DataSourceID="sqladdbesked">
<EditItemTemplate>
from:
<asp:TextBox ID="fromTextBox" runat="server" Text='<%# Bind("from") %>'>
</asp:TextBox><br />
when:
<asp:TextBox ID="whenTextBox" runat="server" Text='<%# Bind("when") %>'>
</asp:TextBox><br />
message:
<asp:TextBox ID="messageTextBox" runat="server" Text='<%# Bind("message") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
from:
<asp:TextBox ID="fromTextBox" runat="server" Text='<%# Bind("from") %>'>
</asp:TextBox><br />
when:
<asp:TextBox ID="whenTextBox" runat="server" Text='<%# Bind("when") %>'>
</asp:TextBox><br />
message:
<asp:TextBox ID="messageTextBox" runat="server" Text='<%# Bind("message") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
from:
<asp:Label ID="fromLabel" runat="server" Text='<%# Bind("from") %>'></asp:Label><br />
when:
<asp:Label ID="whenLabel" runat="server" Text='<%# Bind("when") %>'></asp:Label><br />
message:
<asp:Label ID="messageLabel" runat="server" Text='<%# Bind("message") %>'></asp:Label><br />
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
Text="New">
</asp:LinkButton>
</ItemTemplate>
</asp:FormView>
</form>
</body>
</html>
Og den melder følgende fejl, når jeg prøver at tilføje nye data:
"Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS1002: ; expected
Source Error:
Line 11: void Page_Load(object sender, EventArgs e) {
Line 12: if (!Page.IsPostBack){
Line 13: *besked = fdig dfgfdg;
Line 14: }
Line 15: }
Source File: d:\simdkaspx\mobilbeskeder\test.aspx Line: 13 "
Jeg har også prøvet at udskifte
*besked = fdig dfgfdg;
med
*besked = 'fdig dfgfdg';
Men så giver den bare en anden fejlmeddelse,
"Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS1012: Too many characters in character literal
Source Error:
Line 11: void Page_Load(object sender, EventArgs e) {
Line 12: if (!Page.IsPostBack){
Line 13: *besked = 'fdig dfgfdg';
Line 14: }
Line 15: }
Source File: d:\simdkaspx\mobilbeskeder\test.aspx Line: 13 "
Jeg håber der er nogen der kan hjælpe :)
