Click here to Skip to main content
15,923,142 members
Home / Discussions / C#
   

C#

 
GeneralRe: problem usinf usercontrol object in HTML page Pin
samy10030-Dec-07 11:39
samy10030-Dec-07 11:39 
GeneralBinding to a property Pin
peterchen29-Dec-07 14:30
peterchen29-Dec-07 14:30 
GeneralMySql & C# Question ... pulling data Pin
shadowhazard29-Dec-07 9:59
shadowhazard29-Dec-07 9:59 
GeneralRe: MySql & C# Question ... pulling data [modified] Pin
shadowhazard29-Dec-07 11:27
shadowhazard29-Dec-07 11:27 
GeneralRe: MySql & C# Question ... pulling data Pin
Justin Perez29-Dec-07 14:00
Justin Perez29-Dec-07 14:00 
GeneralRe: MySql & C# Question ... pulling data Pin
shadowhazard29-Dec-07 17:16
shadowhazard29-Dec-07 17:16 
GeneralRe: MySql & C# Question ... pulling data Pin
Mark Churchill30-Dec-07 15:59
Mark Churchill30-Dec-07 15:59 
GeneralRe: MySql & C# Question ... pulling data Pin
shadowhazard30-Dec-07 17:30
shadowhazard30-Dec-07 17:30 
yeah, here is my updated version as of yesterday, again this code is just my sample code i am testing, this is not the DB and such that i will be using in my main program.

string strMovieName = this.movieNameTB.Text;<br />
<br />
            try<br />
            {<br />
<br />
                if (strMovieName == "")<br />
                {<br />
                    MessageBox.Show("You must provide the Movie name");<br />
                    return;<br />
                }<br />
<br />
                string strFindMovie = "SELECT * FROM movie WHERE movie_name = '" + strMovieName + "'";<br />
<br />
<br />
                //create the connection between the program and the database<br />
                MySql.Data.MySqlClient.MySqlConnection conDatabase = new<br />
                    MySql.Data.MySqlClient.MySqlConnection("Data Source=localhost; Database=moviesite; Persist Security Info=yes; username=*******; password=*****");<br />
<br />
                MySql.Data.MySqlClient.MySqlCommand cmdDatabase = new<br />
                    MySql.Data.MySqlClient.MySqlCommand(strFindMovie, conDatabase);<br />
<br />
                //open connection to the dtabase<br />
                conDatabase.Open();<br />
<br />
                MySql.Data.MySqlClient.MySqlDataReader rdrMovie;<br />
                rdrMovie = cmdDatabase.ExecuteReader();<br />
<br />
                while (rdrMovie.Read())<br />
                {<br />
                    this.typeTB.Text = rdrMovie.GetString(2);<br />
                    this.movieYearTB.Text = rdrMovie.GetString(3);<br />
                }<br />
<br />
                //closes teh reader<br />
                rdrMovie.Close();<br />
                //closes the con to the database<br />
                conDatabase.Close();<br />
            }<br />
            catch (MySqlException ex)<br />
            {<br />
                MessageBox.Show(ex.Message);<br />
            }

QuestionAny query about northwind? Pin
omegazafer29-Dec-07 9:44
omegazafer29-Dec-07 9:44 
AnswerRe: Any query about northwind? Pin
Paul Conrad30-Dec-07 6:44
professionalPaul Conrad30-Dec-07 6:44 
GeneralRe: Any query about northwind? Pin
omegazafer30-Dec-07 10:09
omegazafer30-Dec-07 10:09 
GeneralRe: Any query about northwind? Pin
Paul Conrad30-Dec-07 10:30
professionalPaul Conrad30-Dec-07 10:30 
GeneralRe: Any query about northwind? Pin
omegazafer30-Dec-07 10:57
omegazafer30-Dec-07 10:57 
Generali need your help ....am stuck Pin
netJP12L29-Dec-07 9:40
netJP12L29-Dec-07 9:40 
GeneralA little problem Pin
zeeShan anSari29-Dec-07 8:28
zeeShan anSari29-Dec-07 8:28 
AnswerRe: A little problem Pin
Guffa29-Dec-07 9:03
Guffa29-Dec-07 9:03 
GeneralRe: A little problem Pin
Rich Insley29-Dec-07 9:08
Rich Insley29-Dec-07 9:08 
QuestionGetting handle to browser window? Pin
cakewalkr729-Dec-07 3:30
cakewalkr729-Dec-07 3:30 
GeneralRe: Getting handle to browser window? Pin
Scott Dorman29-Dec-07 3:59
professionalScott Dorman29-Dec-07 3:59 
GeneralException handling scenario Pin
beatles169229-Dec-07 1:23
beatles169229-Dec-07 1:23 
GeneralRe: Exception handling scenario Pin
Luc Pattyn29-Dec-07 1:58
sitebuilderLuc Pattyn29-Dec-07 1:58 
Generalmake binary file Pin
zafax_28-Dec-07 22:47
zafax_28-Dec-07 22:47 
GeneralRe: make binary file Pin
Colin Angus Mackay29-Dec-07 2:40
Colin Angus Mackay29-Dec-07 2:40 
GeneralRe: make binary file Pin
Scott Dorman29-Dec-07 3:35
professionalScott Dorman29-Dec-07 3:35 
GeneralRe: make binary file Pin
zafax_29-Dec-07 3:55
zafax_29-Dec-07 3:55 

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.