Please solve this problem

Anil Kumar

15y2.8k.NET

Hi, i have create a web form..and i have use Add,view and update data accourding to this,i have done all code in cs file,but i want to do all with the help of store procedure..please solve this accourding Store procedure

ASPX code:-

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

Untitled Page

Name
Mobile No.

CS code

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(@"Data source=TECHID\SQLEXPRESS;initial catalog=test_abdhesh;integrated security=true");

protected void Page_Load(object sender, EventArgs e)

{

}

void clear()

{

txt_mobileNo.Text = "";

txt_name.Text = "";

}

protected void btn_Add_Click(object sender, EventArgs e)

{

try

{

con.Open();

SqlCommand cmd = new SqlCommand("insert into phone_book values('" + txt_name.Text.ToString() + "','" + txt_mobileNo.Text.ToString() + "')", con);

cmd.ExecuteNonQuery();

clear();

}

catch (Exception ex)

{

Response.Write("This Mobile No. alreay Exist");

}

finally

{

con.Close();

}

protected void btn_View_Click(object sender, EventArgs e)

{

try

{

con.Open();

SqlCommand cmd = new SqlCommand("select P_name, P_no from phone_book where P_no='" + txt_mobileNo.Text.ToString() + "'", con);

SqlDataReader dr;

dr = cmd.ExecuteReader();

if (dr.Read())

{

txt_name.Text = dr[0].ToString();

txt_mobileNo.Text = dr[1].ToString();

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

finally

{

con.Close();

}

protected void btn_update_Click(object sender, EventArgs e)

{

try

{

con.Open();

SqlCommand cmd = new SqlCommand("update phone_book set P_name='" + txt_name.Text.ToString() + "' where P_no='" + txt_mobileNo.Text.ToString() + "'", con);

cmd.ExecuteNonQuery();

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

finally

{

con.Close();

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sandeep Shekhawat15y ago
Hi Anil in Below link u will get a rar file for download and database back up file that solve ur whole process
http://www.c-sharpcorner.com/Forums/Thread/126081/n-tier-application-using-C-Sharp.aspx

But u simply use sqlcommand and sql dataadpater for store procedure.
for update use like this
public int ChangePassword(LoginBO objlogin)
{
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "usp_changepassword";
cmd.CommandType = CommandType.StoredProcedure;
try
{
cmd.Parameters.AddWithValue("@id", objlogin.Id);
cmd.Parameters.AddWithValue("@username", objlogin.UserName);
cmd.Parameters.AddWithValue("@password", objlogin.Password);
return cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
cmd.Dispose();
con.Close();
con.Dispose();
}

and for select use like This:
public DataTable LoginName(LoginBO objlogin)
{
// string user = string.Empty;
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand cmd = new SqlCommand("usp_adminlogin", con);
cmd.CommandType = CommandType.StoredProcedure;
try
{

cmd.Parameters.AddWithValue("@username", objlogin.UserName);
cmd.Parameters.AddWithValue("@password", objlogin.Password);
SqlDataAdapter dap = new SqlDataAdapter(cmd);
dap.Fill(ds, "LoginTable");
return ds.Tables["LoginTable"];
//SqlDataReader dr = cmd.ExecuteReader();
//while (dr.Read())
//{
// user = dr["username"].ToString();
//}
//dr.Close();
//return user;
}
catch
{
throw;
}
finally
{
cmd.Dispose();
con.Close();
con.Dispose();
}
}

0
Jaganathan Bantheswaran15y ago
Hi,

Read this http://www.c-sharpcorner.com/UploadFile/gtomar/storedprocedure12052007003126AM/storedprocedure.aspx
0