Insert values in database table using stored procedure and asp.net?

Question

0.00/5 (No votes)

See more:

Dear All,

insert values in database table using stored procedure and asp.net this means:

i created 2 web pages here one page contain: name, email, password

2nd page contain: education, year

here these two web pages of name, email, password, education, year

these insert single table this is possible or not please reply what about or any examples

Posted 9-Jul-14 21:51pm

member1431

Add a Solution

3 solutions

Solution 1

Means you want to insert values in single table using two web pages. IF like that means you have to call one stored Proceder for both two pages. Below is example link

Insert Data Using Stored Procedure in ASP.NET[^]

Posted 9-Jul-14 22:16pm

mazharkhan123

Updated 9-Jul-14 22:20pm

v2

Comments

member1431 10-Jul-14 4:19am

yes i want two pages of values in single table please reply me mazharkhan123

please reply me

member1431 10-Jul-14 4:20am

yes i want 2 web pages of values in single table please reply me mazharkhan123

please reply me

mazharkhan123 10-Jul-14 4:22am

send me your table fields. Are you fresher or developer?

member1431 10-Jul-14 4:34am

please check and reply me

web page1:
Design:
<form id="form1" runat="server">
<div>

<table class="style1">
<tr>
<td>
Name</td>
<td>
<asp:TextBox ID="TextBox1" runat="server">
</td>
</tr>
<tr>
<td>
Upload File</td>
<td>
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>
</tr>
<tr>
<td>
Password :</td>
<td>
<asp:TextBox ID="TextBox2" runat="server">
</td>
</tr>
<tr>
<td>
ConfirmPassword :</td>
<td>
<asp:TextBox ID="TextBox3" runat="server">
</td>
</tr>

<tr>
<td>
</td>
<td>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
</td>
</tr>

</table>

</div>
</form>

web page2:
Design:
<form id="form1" runat="server">
<div>

<table class="style1">
<tr>
<td>
Education</td>
<td>
<asp:TextBox ID="TextBox1" runat="server">
</td>
</tr>
<tr>
<td>
Job Type</td>
<td>
<asp:TextBox ID="TextBox2" runat="server">
</td>
</tr>
<tr>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click1"
Text="Submit" />
<asp:Label ID="Label1" runat="server" Text="Label">
</td>
</tr>
<tr>
<td>
</td>
<td>
</td>
</tr>
</table>

</div>
</form>

source code:

protected void Button1_Click(object sender, EventArgs e)
{
int userId = 0;

string constr = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;

using(SqlConnection con=new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SPP_uploadfile"))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
Stream fs = FileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(fs);
Byte[] bytes = br.ReadBytes((Int32)fs.Length);

//string strdata = @"~\data\" + FileUpload1.FileName;
//FileUpload1.PostedFile.SaveAs(Server.MapPath(strdata));

cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", TextBox1.Text);
cmd.Parameters.AddWithValue("@Uploadfile", FileUpload1.FileBytes);
cmd.Parameters.AddWithValue("@Password", TextBox2.Text);
cmd.Parameters.AddWithValue("@ConfirmPassword", TextBox3.Text);

cmd.Connection = con;
con.Open();
userId = Convert

Solution 2

Add this code into your web page two, similar add web page1 c sharp code. you will get result.

String ConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
SqlConnection con = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddUser";
cmd.Parameters.Add("@Education",SqlDbType.VarChar).Value = Textbox1.Text.Trim();
cmd.Parameters.Add("@Job_Type", SqlDbType.VarChar).Value = Textbox2.Text.Trim();

cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
lblMessage.Text = "Record inserted successfully";
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}

Write two stored procedure for understanding purpose, otherwise you will confused.

i am writing procedure for web page 2. you write similar two page1.
create procedure AddUser
(
@Location varchar(100),
@Job_type varchar(100)
)
as
begin

insert into user values(@Location,@Job_type)
end.

Posted 9-Jul-14 22:53pm

mazharkhan123

Updated 9-Jul-14 22:54pm

v3

Comments

mazharkhan123 10-Jul-14 5:19am

Mark as solution accept. IF got result

mazharkhan123 10-Jul-14 5:21am

If you not getting check below link but accept solution. Hope you will get from this link. thanks

http://aspdotnetcode.blogspot.in/2010/09/insert-record-in-database-using-stored.html

member1431 10-Jul-14 6:20am

here am already created stored procedure

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

member1431 · Accepted Answer · 2014-07-10T01:27:00

Solution 3

first web page insertion and second page updation of same table

Posted 10-Jul-14 1:27am

member1431