Comments by Member 10724668

Member 10724668 18-May-14 7:20am View

thanx. i haven't set AutoPostBack property. It worked now

Member 10724668 18-May-14 6:16am View

okay. Thanx for the link. and not working means nothing is changed after selecting item from drop down list.My page remains as it is.No error and No exception

Member 10724668 10-May-14 5:43am View

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
con.Open();
string cmdr = "select arts.Name,arts.OriginalPrice,artdetails.artDescription,artdetails.artValidity from artdetails INNER JOIN arts ON artdetails.artsId=arts.artsId";
SqlCommand cmd = new SqlCommand(cmdr, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);

}

Member 10724668 9-May-14 12:23pm View

its by mistake. My table name is artdetails only

Member 10724668 29-Apr-14 4:31am View

ok.But there is one problem. when I try to insert decimal value like 4.5 or 3.2.It gives error as Procedure or function 'spInsertArts' expects parameter '@Price', which was not supplied.

Member 10724668 29-Apr-14 2:19am View

thanx a lot.it worked :)

Member 10724668 29-Apr-14 1:35am View

i have tried this but i am getting error as Input string was not in a correct format.

Member 10724668 29-Apr-14 1:32am View

decimal value = Convert.ToDecimal(txtprice.Text);<br><br>
cmd.Parameters.AddWithValue("@Price",value);<br><br>

Member 10724668 29-Apr-14 0:21am View

thanx for the link.I have modified my code but I am getting exception as An SqlParameter with ParameterName 'Price' is not contained by this SqlParameterCollection.

Member 10724668 28-Apr-14 12:01pm View

web application

Member 10724668 28-Apr-14 11:13am View

It is giving error as the name artistId does not exist in the current context

Member 10724668 28-Apr-14 11:00am View

it is giving error as artistId can not be null

Member 10724668 23-Apr-14 11:23am View

yes i have removed it.But I am getting Same error

Member 10724668 23-Apr-14 11:17am View

I have removed @artistId from parameter list but still I am getting error

Member 10724668 23-Apr-14 11:15am View

@artistId is a foreign key. And i want it to get value of latest artistId of artist table.

Member 10724668 23-Apr-14 10:50am View

cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", TextBox1.Text);
cmd.Parameters.AddWithValue("@category", DropDownList1.SelectedValue);
SqlParameter output = new SqlParameter();
output.ParameterName = "@artsId";
output.SqlDbType = System.Data.SqlDbType.Int;
output.Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(output);
con.Open();
cmd.ExecuteNonQuery();

Member 10724668 19-Apr-14 0:09am View

yes.It is already inserted in employee table.There are many ids.
but how one of them will get assigned to artist?

Comments by Member 10724668 (Top 17 by date)