hi, thank you.i got it. sivamyneni

Try this: If Your procedure is like following: ALTER PROCEDURE myProcedure @Param1 int = 0, @Param2 int = 0, @Param3 int, @Param4 int = 0, @Param5 int = 0, @Param6 int, @Param7 int AS -- Procedure code In order to call it (say, from another sp): exec myProcedure @Param3 = @PassedParam1, @Param6 = @PassedParam2, @Param7 = @PassedParam3 Note: Initialize parameters in the original procedure if you are not sure, the procedure will get those parameters passed to it. (In the case above, if you will not pass one of the @Param3, @Param6, or @Param7) the error will happen. Hope that helps. Sincerely, Elina Life is great!!! Enjoy every moment of it! :-O

Siva Myneni wrote: please try this. Ok, I tried it, now what? First, as this is related to ASP.NET you might get a better response by posting it to that forum. Second, try using a template in the the aspx rather creating it in the code-behind only two letters away from being an asset

Dear Sivamyneni, Currently i don't know the problem with DataSource, i think at a time we can add only one datasource. I also couldn't find the listbox.DataBind() and listbox.DataTextField. What version of .NET u r using. By the Way an alternate way i am giving here and try it.. //Connection to database OdbcConnection con = new OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};server=localhost;database=mysql;uid=root;pwd=mysql"); con.Open(); //Get data from user table OdbcDataAdapter ad = new OdbcDataAdapter("select * from user", con); DataSet set = new DataSet(); ad.Fill(set); //Here is the code to add all the items of the first column of the user table. foreach (DataRow row in set.Tables[0].Rows) { listBox1.Items.Add(row[set.Tables[0].Columns[0]]); } ////ON OTHER EVENT LIKE CHECKBOX OR BUTTON CLICK REPEAT THIS. OdbcDataAdapter ad = new OdbcDataAdapter("select * from BILL", con); DataSet set = new DataSet(); ad.Fill(set); //Here is the code to add all the items of the first column of the bill table. foreach (DataRow row in set.Tables[0].Rows) { listBox1.Items.Add(row[set.Tables[0].Columns[0]]); }