To insert data in database with using storeprocedure and code c# we must instal sqlserver 2008.has we instal sqlserver 2008 we must make database,table and storeprocedure.you can see this below.
we must make table.example i make table name is TStoreProcedure with design below:
[idNama] [int] IDENTITY(1,1) NOT NULL,
[Nama] [nvarchar](50) NULL,
[Alamat] [nvarchar](50) NULL,
[Hobby] [nvarchar](50) NULL,
and now we open programmability=>storeprocedure and we make storeprocedure with names=storeproceduretest and content this below:
CREATE PROCEDURE [dbo].[storeproceduretest]
(
@Nama AS nvarchar(50),
@Alamat AS nvarchar(50),
@Hobby AS nvarchar(50)
)
AS
begin
Insert into [TStoreProcedure]
(Nama,Alamat,Hobby)values(@Nama,@Alamat,@Hobby)
end
go
and to coding in visual studio we must open visual studio 2008 =>new project=>asp.net webaplication
you can see this below:
we coding in default.ascx this below
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="default.ascx.cs" Inherits="Module.StoreProcedure._default" %>
<asp:Panel ID="pnl1" runat="server">
<table>
<tr>
<td>
Nama
</td>
<td>
:
</td>
<td>
<asp:TextBox ID="txtNAMA" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Alamat
</td>
<td>
:
</td>
<td>
<asp:TextBox ID="txtalamat" runat="server" TextMode="MultiLine"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Hobby
</td>
<td>
:
</td>
<td>
<asp:TextBox ID="txthoby" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Button ID="btnsimpan" runat="server" OnClick="btnsimpan_click" Text="SIMPAN" />
</td>
</tr>
</table>
<asp:Label ID="lbltest" runat="server" Visible="false"></asp:Label>
</asp:Panel>
and coding default.ascx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DotNetNuke.Entities.Modules;
using System.Data.SqlClient;
using System.Data;
namespace Module.StoreProcedure
{
public partial class _default : PortalModuleBase
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnsimpan_click(object sender, EventArgs e)
{
try
{
string strsql = "storeproceduretest";
SqlConnection mycon = new SqlConnection(@"Data Source=MSI\MSSQL2008R2;Initial Catalog=DB;User ID=RDO3;Password=1234567");
SqlCommand mycomand = new SqlCommand(strsql, mycon);
mycomand.CommandType = CommandType.StoredProcedure;
mycomand.Parameters.Add("@Nama",SqlDbType.NVarChar,50).Value = txtNAMA.Text.ToString();
mycomand.Parameters.Add("@Alamat",SqlDbType.NVarChar,50).Value= txtalamat.Text.ToString();
mycomand.Parameters.Add("@Hobby",SqlDbType.NVarChar,50).Value= txthoby.Text.ToString();
mycon.Open();
int response = -1;
response = mycomand.ExecuteNonQuery();
if (response >= 1)
{
lbltest.Text = "data berhasil disimpan";
}
else
{
lbltest.Text = "data gagal";
}
}
catch (Exception ex)
{
}
}
}
}
finaly result programing above you see this screenshoot below:
---oke Thank you ,I hope can be usefull---
