Table Adapter Configuration in DATASET Designer

Question

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 -------

rad v · Answer

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 ------

ashleyturnier · Answer

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();