I Cant I Store My Data In Database In C# Sql Server

Question

1.00/5 (1 vote)

See more:

otected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=demo1;Integrated Security=True");
con.Open();

Hide Expand Copy Code
int a = Convert.ToInt32(TextBox1.Text);
int b = Convert.ToInt32(TextBox2.Text);

if (DropDownList1.Text == "add")
{
int sum = (a + b);
Label1.Text = Convert.ToString(sum);
dat.Text = DateTime.Now.ToString();

}
if

(DropDownList1.Text == "sub")
{
int sub = (a - b);
Label1.Text = Convert.ToString(sub);
dat.Text = DateTime.Now.ToString();
}
if
(DropDownList1.Text == "mul")
{
int mul = a * b;
Label1.Text = Convert.ToString(mul);
dat.Text = DateTime.Now.ToString();
}
if
(DropDownList1.Text == "div")
{
decimal div = a / b;
Label1.Text = Convert.ToString(div);
dat.Text = DateTime.Now.ToString();
}

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "p";

cmd.Parameters.AddWithValue("@firsttno", TextBox1.Text);
cmd.Parameters.AddWithValue("@secondno", TextBox2.Text);
cmd.Parameters.AddWithValue("@operation", DropDownList1.Text);
cmd.Parameters.AddWithValue("@result", Label1.Text);
cmd.Parameters.AddWithValue("@optime", dat.Text);
cmd.Connection = con;
cmd.ExecuteNonQuery();

con.Close();

}
}
}

Posted 26-May-15 19:50pm

Member 11507028

Updated 26-May-15 20:01pm

Sergey Alexandrovich Kryukov

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 27-May-15 1:59am

Aha, the post starting from "otected" :-)
And this is not the main problem. The problem is that this is a code dump, not even formatted. Not a question.
—SA

willington.d 27-May-15 2:00am

Are you getting any error???

3 solutions

Solution 1

Bro this is because you are not getting any value to save.
The if Condition you gave is wrong..
It should be
if (DropDownList1.SelectedValue== "add")
{
}

Posted 26-May-15 20:15pm

Manoj Sawant

Comments

Member 11507028 27-May-15 2:33am

the result showing in lebel but it is not storing in databasee

Manoj Sawant 27-May-15 4:31am

can you show me what procedure you have written

Solution 2

create procedure p
(
@firsttno int,
@secondno int,
@operation varchar(max),
@result int,
@optime datetime
)
as begin
select firstno,secondno,operation,result,optime from table1 where firstno=@firsttno and secondno=@secondno and operation=@operation and result=@result and optime=@optime
end

Posted 26-May-15 23:45pm

Member 11507028

Comments

Manoj Sawant 27-May-15 6:17am

Bro you have select query in the procedure whereas you must have a insert query instead of select query

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)

Manoj Sawant · Accepted Answer · 2015-05-27T00:21:00

create procedure p
(
@firsttno int,
@secondno int,
@operation varchar(max),
@result int,
@optime datetime
)
as begin
Insert into table1(firstno,secondno,operation,result,optime) Values(@firsttno,@secondno,@operation,@result,@optime)
end

In C# code

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "p";

cmd.Parameters.AddWithValue("@firsttno", TextBox1.Text);
cmd.Parameters.AddWithValue("@secondno", TextBox2.Text);
cmd.Parameters.AddWithValue("@operation", DropDownList1.SelectedValue);
cmd.Parameters.AddWithValue("@result", Label1.Text);
cmd.Parameters.AddWithValue("@optime", dat.Text);
cmd.Connection = con;
cmd.ExecuteNonQuery();

I Cant I Store My Data In Database In C# Sql Server

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us