|
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();
}
|
|
|
|
|
My money is on either Txtproductprice or Txtproductquantity not containing a valid integer.
|
|
|
|
|
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.
|
|
|
|
|
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();
|
|
|
|
|
Someone voted as Bad Answer to mine answers too 
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.
|
|
|
|
|
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.....
|
|
|
|
|
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!
|
|
|
|
|
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.
|
|
|
|
|
Blue_Boy wrote: but this is foum in which we all trying to help each-other.
|
|
|
|
|
please dont post your question again and again that too with a change of name......
|
|
|
|
|
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!
|
|
|
|
|
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();
|
|
|
|
|
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.
|
|
|
|
|
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();
|
|
|
|
|
So what is happening? Is an exception being thrown?
|
|
|
|
|
Did you try to debug it.Is it value is properly assigned to the textbox.Any error or exception?
|
|
|
|
|
There is nothing wrong with this code. Problem seems with your execution ? Where are you executing these ? Any thing here is runtime created ?
|
|
|
|
|
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
|
|
|
|
|
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();
|
|
|
|
|
It may also be worth while looking at TryParse to make sure the text boxes contain valid numbers.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
|
vikas shukla wrote: please send me code if possible
What have you tried so far? A simple Google search would have gave you a nice idea.
void mygridview_RowCommand(Object sender, GridViewCommandEventArgs e)
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = ContactsGridView.Rows[index];
}
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
<asp:TemplateField>
<ItemTemplate>
<asp:Button runat="server" CommandName="BtnUpdate" CommandArgument='<% Eval("PrimaryKeyField") %>' />
</ItemTemplate>
</asp:TemplateField>
himanshu
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
