Handling Multiple Tables in Typed Dataset

Question

Hi, How will i create and fill data in Typed Dataset containing more then one table?..How will i populate the respective table involved in the SQL Query? For example in my Typed Dataset i have 2 tables Employee and Department table. I'm fetching the data from both the tables in the sql query. How will i use DataAdapter to fill both the tables in the Typed DataSet? regards, Manpreet

Answer 1

now sure if this is what you are looking for...

ButtonAddOrder_Click(...) 

{ 

THIS IS THE CODE I HAVE: StreamWriter myWriter new StreamWriter("customer.txt"); MyWriter.WriteLine(txtName.Text); MyWriter.Close(); 

If(addOrder == DialogResult.yes) 

{ why dont you call a function here...like myfunc() } 

}

Myfunc()

{

 DO COMMON TASK HERE

}

Answer 2

great that it worked for you, also you are not stupid ; any question big or small is legit.

Answer 3

I think I know what you mean... I Create a Function or Procedure then call it in both the button and if statement!!! Thanx man!!! Lol, I'm stupid....

Answer 4

Hi Dillion,

you question is not clear, may be you can elaborate more or give us some examples. For what i understand is you want to write a common routine and you want to call that on any event, like button click, etc. So I am not sure if you just create a Sub/Function and pass the object as the parameter and run your routine based on the object's decision.