Dear All,
I have a table in oracle database having 4 fields- ID,code,name,password.
I have a web form in which I am accepting a value for code from the user and want to display the entire record in a gridview.
For doing this I having a label,textbox, button and gridview in a web page.
I have written the following code for the button which searches the record and populates the gridview.
using
{
GridView1.DataSource = ds1;
GridView1.DataBind();
}
I have a DAL which has a method called getRecord(),that actually connects to the database, fetches the record and then returns the record as a Dataset to
button event handler mentioned above. The method is as follows:
objConnection.ConnectionString = str;
objConnection.Open();
objConnection.Close();
The problem is that this was working fine.But it stopped working after I dropped the table users and recreated it with same name but one more column which I made primary key, Identity. The insert operation is still working with the old code and new table.
Can't really figure out as to what went wrong.
Any help that solves this issue will be gratefully accepted.
Thanks.