Hi YOu are assigning string values to byte, thats why its giving error. You can use following code String[] mm = {"A","B","C"}; byte[] by = new byte[3]; for (int i = 0; i < mm.Length; i++) { by[i] = Convert.ToByte(mm[i]); }

one thing which u can do is to get expected result from sp by using distinct keyword and if in yours case that is not possible. then take a string variable and put whenever you add the row in datatable also add that primay key in this string.(this will containf the comma separated primary keys which have added). and before adding the row to datatable check that whether this primary key is already there in string. //declare string as empty before for loop dr = dt.NewRow(); dr[0] = int.Parse(ds.Tables[0].Rows[k]["ID"].ToString()); //check that string contaims this primary key or not if( string does not contain this primary key) { dr[1] = ds.Tables[0].Rows[k]["COL1"].ToString() dr[2] = ds.Tables[0].Rows[k]["COL2"].ToString() dt.Rows.Add(dr); //add this primary key to string }

you have to add code on click of save button in this code ypou will traverse all the rows one by one and will save data of each row one by one. or you can first take data to save in a string for each row data will be comma seperated and rows will be semicolon seperated and at the time of saving you can get sepearate them and then save one row each time.

i am using listbox server control. When i made selectionmode multiple, it works fine. but when i make selectionmode single, i am unable to deselect any selected ite in list box. In this case if once i select any item then i have to select atleast one item from list and my requirement is to make user able to deselect that selected ite. Need it urgent.

that i know but i just want to ignore the exception because rest functnality is working fine.

Hi I was using Response.End() method in .net 1.x successfully. But in .net2.0 its giving exception "Thread is being aborted." Any solutions for it? Please replay fast its urgent.

i think there should not be any problem in this case. Simply get the selected values from list and pass them to get values from database for datagrid.

but for that also you have to take data from somewhere else. ultimately somewhere it ahould be already present. Are you trying to get that data from somewhere else, where it is already maintained?

at least once you have toput all of yhrm in database and then later u can fill urs comboboxes from database.

just put that id in session state or pass it as query string to the edit page.

try it insert into FIELDS_IN_VIEW select 24, field from FIELDS_IN_VIEW where view = 23

for eg. in urs stored procedure use following declare @temp int set @temp = select count(*) from table declare @@count int set @count = 1 while(@temp >0) Begin Insert query set @temp = @temp-1 End

may be in urs connection string u r missing password.

just use cursor or while loop in urs stored procedure.

hi there first use findcontrol function for getting the control combobox then set its value. (controltype)dataGridView1.Rows["RowName"].Cells["ColumnName"].findcontrol("ControlID").value = "1"

use template column in datagrid and in that template column you can use any control like combo or text box or radio button or check box etc.

hi there yes you can use this query but remember to pass @CompanyID as a comma separated string of ids.

you can put the portion of code in div which is to be print and then onclick of the print button call a javascript function which will get the div and will print it.

you can use template column in which you can put a table and in case of header where you want to merge the cells can use colspan and in case of data you can use two diffrent cells.

for javascript on the click of button call a function in javascript there check for value of text box if it is empty then display a alert box with message and return false else pass true without displaying the alert box.