ASP.NET

mylogics10-Jul-09 0:08

10-Jul-09 0:08

m doin this in a function n then calling this function on button click event....

padmanabhan N10-Jul-09 0:11

10-Jul-09 0:11

function or method.... Because this is a simple and working code which is sent by our experts.... it sounds odd when it is not working for you.... kindly send your function and where you are calling that fucntion.....

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

mylogics10-Jul-09 0:14

10-Jul-09 0:14

ok this is the full code:
private void InsertInfo()
{
SqlConnection conn = new SqlConnection(GetConnectionString());
string sql = "INSERT INTO PurchaseProduct(ProductCategoryId,ProductID,ProductName,BrandName,Price,Quantity,TotalPrice)values(@Val1,@Val2,@Val3,@Val4,@Val5,@Val6,@Val7)";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Val1",Txtcatid.Text);
cmd.Parameters.AddWithValue("@Val2",Txtproductid.Text);
cmd.Parameters.AddWithValue("@Val3",Txtproductname.Text);
cmd.Parameters.AddWithValue("@Val4",Txtbrandname.Text);
cmd.Parameters.AddWithValue("@Val5",Txtproductprice.Text);
cmd.Parameters.AddWithValue("@Val6",Txtproductquantity.Text);
int Total = int.Parse(Txtproductprice.Text) * int.Parse(Txtproductquantity.Text);// (Convert.ToInt32(Txtproductprice.Text) * Convert.ToInt32(Txtproductquantity.Text));
string total = Convert.ToString(Total);
Txttotalprice.Text = Total.ToString();
cmd.Parameters.AddWithValue("@Val7",Total);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Insert Error:";
msg += ex.Message;
throw new Exception(msg);

}
finally
{
conn.Close();
Txtcatid.Text = "";
Txtproductid.Text = "";
Txtproductname.Text = "";
Txtbrandname.Text = "";
Txtproductprice.Text = "";
Txtproductquantity.Text = "";
Txttotalprice.Text = "";

}
}
protected void Button1_Click(object sender, EventArgs e)
{
InsertInfo();
}

DoctorMick10-Jul-09 0:17

10-Jul-09 0:17

My money is on either Txtproductprice or Txtproductquantity not containing a valid integer.

Blue_Boy10-Jul-09 0:18

10-Jul-09 0:18

pariofshona wrote:
...TotalPrice)values...

Should be like this ...TotalPrice) values...

pariofshona wrote:
int Total = int.Parse(Txtproductprice.Text) * int.Parse(Txtproductquantity.Text);// (Convert.ToInt32(Txtproductprice.Text) * Convert.ToInt32(Txtproductquantity.Text));
string total = Convert.ToString(Total);
Txttotalprice.Text = Total.ToString();
cmd.Parameters.AddWithValue("@Val7",Total);

replace with

int Total = int.Parse(Txtproductprice.Text) * int.Parse(Txtproductquantity.Text);
string total = Convert.ToString(Total);
Txttotalprice.Text = total ;
cmd.Parameters.AddWithValue("@Val7",total);

I Love T-SQL www.aktualiteti.com
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

padmanabhan N10-Jul-09 0:23

10-Jul-09 0:23

i dono who voted the above answer to remove.... But who ever it might be the answer is,

pariofshona wrote:
private void InsertInfo()

this is method not a function

pariofshona wrote:
int Total = int.Parse(Txtproductprice.Text) * int.Parse(Txtproductquantity.Text);// (Convert.ToInt32(Txtproductprice.Text) * Convert.ToInt32(Txtproductquantity.Text));
string total = Convert.ToString(Total);
Txttotalprice.Text = Total.ToString();

you can directly assign,
int Total = int.Parse(Txtproductprice.Text) * int.Parse(Txtproductquantity.Text);
Txttotalprice.Text = Total.ToString();

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Blue_Boy10-Jul-09 0:32

10-Jul-09 0:32

Someone voted as Bad Answer to mine answers too Frown | :(

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

padmanabhan N10-Jul-09 0:43

10-Jul-09 0:43

ya, this is one of the bad thing to hide thier names and vote.....if they are ready to prove that the answer is bad they can give the correct answer and prove their talents in front of our experts.....

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

DoctorMick10-Jul-09 0:52

10-Jul-09 0:52

It comes to something when someone who can't even manage to add the values of two numbers in textboxes is voting everyones answers as cold because they can't figure out the simplest of tasks!

Blue_Boy10-Jul-09 0:55

10-Jul-09 0:55

Some kind of people are like 'chicken', but this is foum in which we all trying to help each-other.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Abhijit Jana10-Jul-09 5:31

Abhijit Jana

10-Jul-09 5:31

Blue_Boy wrote:
but this is foum in which we all trying to help each-other.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

padmanabhan N10-Jul-09 0:09

10-Jul-09 0:09

please dont post your question again and again that too with a change of name......

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Vasudevan Deepak Kumar10-Jul-09 2:30

Vasudevan Deepak Kumar

10-Jul-09 2:30

Pl. avoid spinning a new thread for the same post messing up the forums.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

value in textbox

mylogics9-Jul-09 23:45

9-Jul-09 23:45

hiii
i hav written the code but still it is not showin the value
in the textbox when i run the program.I want that it calculates the value of two textbox n shows the result in third textbox.
the code is:
int result = int.Parse(TextBox1.Text) * int.Parse(TextBox2.Text);
TextBox3.Text = result.ToString();

Blue_Boy9-Jul-09 23:48

9-Jul-09 23:48

TextBox3.Text =Convert.ToString(int.Parse(TextBox1.Text) * int.Parse(TextBox2.Text));

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

padmanabhan N9-Jul-09 23:57

9-Jul-09 23:57

Blue_Boy wrote:
TextBox3.Text =Convert.ToString(int.Parse(TextBox1.Text) * int.Parse(TextBox2.Text));

this is same as,
int result = int.Parse(TextBox1.Text) * int.Parse(TextBox2.Text);
TextBox3.Text = result.ToString();

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

DoctorMick10-Jul-09 0:15

10-Jul-09 0:15

So what is happening? Is an exception being thrown?

Brij10-Jul-09 2:15

Brij

10-Jul-09 2:15

Did you try to debug it.Is it value is properly assigned to the textbox.Any error or exception?

Cheers!!
Brij

Check My Latest Article

Abhijit Jana10-Jul-09 3:14

Abhijit Jana

10-Jul-09 3:14

There is nothing wrong with this code. Problem seems with your execution ? Where are you executing these ? Any thing here is runtime created ?

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

error

mylogics9-Jul-09 23:26

9-Jul-09 23:26

I want to assign a integer value to a textbox during runtime.
plz help m new to asp.net.the code i have written does not shows
the value in textbox during runtime....:
int Total = (Convert.ToInt32(Txtproductprice.Text) * Convert.ToInt32(Txtproductquantity.Text));
//string total = Convert.ToString(Total);
Txttotalprice.Text = Total.ToString();

thank's

Re: error

padmanabhan N9-Jul-09 23:33

9-Jul-09 23:33

pariksht wrote:
nt Total = (Convert.ToInt32(Txtproductprice.Text) * Convert.ToInt32(Txtproductquantity.Text));
//string total = Convert.ToString(Total);
Txttotalprice.Text = Total.ToString();

int result = int.Parse(TextBox1.Text) * int.Parse(TextBox2.Text);
TextBox3.Text = result.ToString();

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Re: error

DoctorMick9-Jul-09 23:44

9-Jul-09 23:44

It may also be worth while looking at TryParse to make sure the text boxes contain valid numbers.

Re: error

Blue_Boy9-Jul-09 23:45

get primary key value [modified]

9-Jul-09 23:45

Do you reset control values before assign value to TextBox?

Txttotalprice.Text =Convert.ToString(Convert.ToInt32(Txtproductprice.Text) *Convert.ToInt32(Txtproductquantity.Text));

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

vikas shukla9-Jul-09 23:06

vikas shukla

9-Jul-09 23:06

hi sir
please help me
i want the primary key column value on gridview_rowcommand()
please send me code if possible
thanx

hi sir
i am using following code:

<asp:templatefield headertext="Status">
<itemtemplate>
<asp:linkbutton id="lb1" runat="server" onclick="lb1_Click" commandname="lock_user" commandargument="<%# Container.DataItemIndex %>">Lock

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if ((e.CommandName).ToString() == "lock_user")
{

int index = Convert.ToInt32(e.CommandArgument);

string userid = GridView1.Rows[index].FindControl("UserIdName").ToString();

WebMsgBox.Show(userid);

}
}

but it gives blank messagebox and i want that userid.

modified on Friday, July 10, 2009 6:35 AM

Re: get primary key value

padmanabhan N9-Jul-09 23:24