Table Adapter Configuration in DATASET Designer

rad v

Hi,

I have Stored procedure with select statement and with In and Out Parameters as with ref cursor as out parameter in oracle

whin I configured table adapter with that stored procedure in data set designer using ORAOLEDB provider.
data table parameters are not configured. In GETdata() also I did'nt get any parameters. I am not able use this adapter in coding also.

I have tried so many times but I didn't get any result. If I run stored procedure individually , It's returning output values correctly.

any one Could you please help on this ?

Thnaks
-------

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

rad v13y ago
Hi,

Thank you. But I want configure table adapter in dataset designer. with use existing stored procedure option. but when I configured table adapter in dataset designer I am not getting datatable columns that is the problem could you please help on this one.

Thanks
------
ashleyturnier13y ago
I think this coding is help to you.

con.Open();
DataSet ds = new DataSet();
SqlDataAdapter adap = new SqlDataAdapter("select * from Tbl_Adminlogin where Adminname='" + txtUsername.Text + "' and password='" + txtpassword.Text + "'", con);

adap.Fill(ds);
int count = ds.Tables[0].Rows.Count;

if (count == 0)
{
MessageBox.Show("Enter correct username or password !");
}
else
{
//MessageBox.Show("Welcome " + txtUsername.Text);
this.Hide();
AdminHome objadminhome = new AdminHome();
objadminhome.Show();

}
con.Close();