mccom
asked on
ASP.NET - easiest way to insert records
Hi all.
What is the easiest way to insert record to database from asp.net web form ?
My form looks like this:
As you see, all fields are required except the last one (IEmailTXT).
Validation is working as it should, but now I need to do the inserting part.
What is the best way to do it ? I am using access database.
This is my insert command:
"INSERT INTO KuDo (KuDoID,KuDoNaziv,WebSiteU sername,We bSitePassw ord,KuDoPI B,KuDoTele fonMobilni ,KuDoTelef onFiksni,K uDoAdresa, KuDoEmail) VALUES (@KuDoID,@KuDoNaziv,@WebSi teUsername ,@WebSiteP assword,@K uDoPIB,@Ku DoTelefonM obilni,@Ku DoTelefonF iksni,@KuD oAdresa,@K uDoEmail)"
What is the easiest way to insert record to database from asp.net web form ?
My form looks like this:
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:MultiView ID="MultiView12" runat="server">
<asp:View ID="Registracija1" runat="server">
<div class="center_title_bar">
Otvaranje novog naloga
</div>
<div class='forma_edit'>
<asp:ValidationSummary ID="ValidationSummary1" runat="server" CssClass="forma_edit_error_summary" />
<div class='forma_edit_tekst'>
Molimo Vas da unesete Vaše podatke. Polja oznacena sa * (zvjezdicom) je obavezno
unjeti.
</div>
<div class='forma_edit_name'>
Ime i Prezime*
</div>
<div class='forma_edit_field'>
<asp:TextBox ID='IKuDonameTXT' ClientIDMode="Static" runat='server' Width='420px'></asp:TextBox>
<asp:RequiredFieldValidator ErrorMessage="Morate upisati Ime i prezime" ControlToValidate="IKuDonameTXT"
CssClass="forma_edit_error" runat="server" />
</div>
<div class='forma_edit_name'>
Korisnicko ime*
</div>
<div class='forma_edit_field'>
<asp:TextBox ID='IWebSiteUsernameTXT' runat='server' Width='420px' />
<asp:RequiredFieldValidator ErrorMessage="Morate upisati korisnicko ime" ControlToValidate="IWebSiteUsernameTXT"
CssClass="forma_edit_error" runat="server" />
</div>
<div class='forma_edit_descr'>
Ime koje cete koristiti kada se budete prijavljivali na sajt
</div>
<div class='forma_edit_name'>
Lozinka*
</div>
<div class='forma_edit_field'>
<asp:TextBox ID='IWebSitePasswordTXT' runat='server' Width='420px' />
<asp:RequiredFieldValidator ErrorMessage="Morate upisati lozinku" ControlToValidate="IWebSitePasswordTXT"
CssClass="forma_edit_error" runat="server" />
</div>
<div class='forma_edit_name'>
JMBG*
</div>
<div class='forma_edit_field'>
<asp:TextBox ID='IKuDoPIBTXT' runat='server' Width='420px' />
<asp:RequiredFieldValidator ErrorMessage="Morate upisati JMBG" ControlToValidate="IKuDoPIBTXT"
CssClass="forma_edit_error" runat="server" Display="Dynamic" />
</div>
<div class='forma_edit_descr'>
Vas jedinstveni maticni broj (sluzi za provjeru Vasih podataka)
</div>
<div class='forma_edit_name'>
Mobilni Telefon*
</div>
<div class='forma_edit_field'>
<asp:TextBox ID='IKuDoTelefonMobilniTXT' runat='server' Width='420px' />
<asp:RequiredFieldValidator ErrorMessage="Morate upisati Mobilni telefon" ControlToValidate="IKuDoTelefonMobilniTXT"
CssClass="forma_edit_error" runat="server" />
</div>
<div class='forma_edit_name'>
Fiksni Telefon*
</div>
<div class='forma_edit_field'>
<asp:TextBox ID='IKuDoTelefonFiksniTXT' runat='server' Width='420px' />
<asp:RequiredFieldValidator ErrorMessage="Morate upisati Fiksni telefon" ControlToValidate="IKuDoTelefonFiksniTXT"
CssClass="forma_edit_error" runat="server" />
</div>
<div class='forma_edit_name'>
Adresa*
</div>
<div class='forma_edit_field'>
<asp:TextBox ID='IKuDoAdresaTXT' runat='server' Width='420px' />
<asp:RequiredFieldValidator ErrorMessage="Morate upisati adresu" ControlToValidate="IKuDoAdresaTXT"
CssClass="forma_edit_error" runat="server" />
</div>
<div class='forma_edit_descr'>
Vasa adresa u formatu Ulica i broj, Grad
</div>
<div class='forma_edit_name'>
Email adresa
</div>
<div class='forma_edit_field'>
<asp:TextBox ID='IEmailTXT' runat='server' Width='420px' />
</div>
<div class="forma_edit_komanda_insert">
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" Text="Sacuvaj" />
</div>
</div>
</asp:View>
<asp:View ID="Zavrseno" runat="server">
Uspjesno ste se registrovali. Molimo Vas da se ulogujete na vrhu stranice.
</asp:View>
</asp:MultiView>
</ContentTemplate>
</asp:UpdatePanel>
As you see, all fields are required except the last one (IEmailTXT).
Validation is working as it should, but now I need to do the inserting part.
What is the best way to do it ? I am using access database.
This is my insert command:
"INSERT INTO KuDo (KuDoID,KuDoNaziv,WebSiteU
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.