ASP.NET

Re: geting error while accessing webservices..

10-Jul-09 0:03

Wouldn't you try to search on google like first?[^]

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.

vkumar0910-Jul-09 0:13

vkumar09

10-Jul-09 0:13

I tried it on google..I know i have to pass proxy server credential but dont know how to pass..If u know then plz tell me..

Re: geting error while accessing webservices..

Vasudevan Deepak Kumar10-Jul-09 2:35

Vasudevan Deepak Kumar

10-Jul-09 2:35

http://support.microsoft.com/kb/813834[^]

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!

textbox

mylogics9-Jul-09 23:54

mylogics

9-Jul-09 23:54

hiiii
dear its still not workin.
i just want to multiply the two textbox values n show this value
in third textbox during runtime.can u solve the problem.....
thnks...

padmanabhan N9-Jul-09 23:58

9-Jul-09 23:58

Are you writing the code in some button click event or in textbox change event.....

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

Blue_Boy10-Jul-09 0:01

10-Jul-09 0:01

Don't open new threads,continue writting in your previous which you created.

Check this link[^]

I suggest you to buy programming book and to read it.

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.

mylogics10-Jul-09 0:08

mylogics

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

mylogics

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

DoctorMick

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

DoctorMick

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