Click here to Skip to main content
15,915,328 members
Home / Discussions / C#
   

C#

 
AnswerRe: PROBLEM IN SAVING Pin
Colin Angus Mackay10-Nov-07 0:49
Colin Angus Mackay10-Nov-07 0:49 
GeneralRe: PROBLEM IN SAVING Pin
Sunil Wise10-Nov-07 1:11
professionalSunil Wise10-Nov-07 1:11 
GeneralRe: PROBLEM IN SAVING Pin
Colin Angus Mackay10-Nov-07 1:20
Colin Angus Mackay10-Nov-07 1:20 
GeneralRe: PROBLEM IN SAVING Pin
Paul Conrad10-Nov-07 3:17
professionalPaul Conrad10-Nov-07 3:17 
Questionfilesystem Pin
Sunil Wise9-Nov-07 23:34
professionalSunil Wise9-Nov-07 23:34 
AnswerRe: filesystem Pin
Guffa9-Nov-07 23:54
Guffa9-Nov-07 23:54 
GeneralRe: filesystem Pin
Sunil Wise9-Nov-07 23:59
professionalSunil Wise9-Nov-07 23:59 
QuestionFilling a typed dataset with multiple tables Pin
steve_rm9-Nov-07 22:59
steve_rm9-Nov-07 22:59 
Hello,

I am using MySql as my database. I can fill individual tables, however when I query to select from 2 different tables and do an add watch on the dataset the count for those 2 tables is 0.

Everything runs without errors. However, when I check count property for the table in the add watch it gives an zero.

However, if I write the query like this: "SELECT * FROM Beverage"
and fill using this da.Fill(DS.Beverage); Then the count display the correct number of rows.

Can anyone explain this?

Many thanks,

My code for filling
 try<br />
            {<br />
                this.OpenConnection();<br />
<br />
                RestaurantDataSet ds = new RestaurantDataSet();<br />
                MySqlDataAdapter da = new MySqlDataAdapter();<br />
                MySqlCommand cmd = new MySqlCommand();<br />
<br />
                cmd.Connection = cnn;<br />
                cmd.CommandType = CommandType.Text;<br />
                cmd.CommandText = "SELECT maincourse.MainCourseID, beverage.BeverageID FROM maincourse, beverage";<br />
                                    <br />
                da.SelectCommand = cmd;<br />
                da.Fill(ds);<br />
<br />
                return ds;      <br />
            }<br />
            catch (Exception ex)<br />
            {<br />
                Console.WriteLine(ex.Message);<br />
                return null;<br />
            }

AnswerRe: Filling a typed dataset with multiple tables Pin
Paul Conrad10-Nov-07 4:37
professionalPaul Conrad10-Nov-07 4:37 
QuestionRe: Filling a typed dataset with multiple tables Pin
steve_rm10-Nov-07 6:13
steve_rm10-Nov-07 6:13 
AnswerRe: Filling a typed dataset with multiple tables Pin
Paul Conrad10-Nov-07 6:38
professionalPaul Conrad10-Nov-07 6:38 
QuestionDynamically Printing a bitmap image Pin
sindhutiwari9-Nov-07 22:57
sindhutiwari9-Nov-07 22:57 
AnswerRe: Dynamically Printing a bitmap image Pin
Matthew Butler10-Nov-07 1:37
Matthew Butler10-Nov-07 1:37 
QuestionSqlNotificationRequest Problem. Pin
hdv2129-Nov-07 21:51
hdv2129-Nov-07 21:51 
AnswerRe: SqlNotificationRequest Problem. Pin
sindhutiwari10-Nov-07 0:30
sindhutiwari10-Nov-07 0:30 
QuestionNow it is Official... I need help! Pin
kingletas9-Nov-07 20:22
kingletas9-Nov-07 20:22 
AnswerRe: Now it is Official... I need help! Pin
Christian Graus9-Nov-07 22:01
protectorChristian Graus9-Nov-07 22:01 
GeneralRe: Now it is Official... I need help! Pin
kingletas9-Nov-07 22:14
kingletas9-Nov-07 22:14 
GeneralRe: Now it is Official... I need help! Pin
Christian Graus9-Nov-07 22:20
protectorChristian Graus9-Nov-07 22:20 
GeneralRe: Now it is Official... I need help! Pin
Paul Conrad10-Nov-07 3:18
professionalPaul Conrad10-Nov-07 3:18 
GeneralRe: Now it is Official... I need help! Pin
kingletas10-Nov-07 15:34
kingletas10-Nov-07 15:34 
GeneralRe: Now it is Official... I need help! Pin
Paul Conrad10-Nov-07 16:10
professionalPaul Conrad10-Nov-07 16:10 
GeneralRe: Now it is Official... I need help! Pin
Guffa9-Nov-07 23:06
Guffa9-Nov-07 23:06 
QuestionBrowser control in C# 2.0 Pin
A.Asif9-Nov-07 19:41
A.Asif9-Nov-07 19:41 
AnswerRe: Browser control in C# 2.0 Pin
Rajasekharan Vengalil9-Nov-07 20:18
Rajasekharan Vengalil9-Nov-07 20:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.