Click here to Skip to main content
15,914,594 members
Home / Discussions / C#
   

C#

 
AnswerRe: free graph/chart libraries Pin
stancrm10-Jan-07 20:06
stancrm10-Jan-07 20:06 
AnswerRe: free graph/chart libraries Pin
Tamimi - Code10-Jan-07 20:07
Tamimi - Code10-Jan-07 20:07 
QuestionHow do I assign a handler to a command button? Pin
JoeRip10-Jan-07 19:15
JoeRip10-Jan-07 19:15 
AnswerRe: How do I assign a handler to a command button? Pin
JoeRip10-Jan-07 19:20
JoeRip10-Jan-07 19:20 
GeneralRe: How do I assign a handler to a command button? Pin
JoeRip10-Jan-07 19:20
JoeRip10-Jan-07 19:20 
JokeRe: How do I assign a handler to a command button? Pin
CPallini10-Jan-07 21:22
mveCPallini10-Jan-07 21:22 
QuestionInsert a Record Pin
mwith10-Jan-07 18:54
mwith10-Jan-07 18:54 
AnswerRe: Insert a Record [modified] Pin
lost in transition 11-Jan-07 5:54
lost in transition 11-Jan-07 5:54 
MySQLString = "INSERT INTO Bank_Details(Bank_Code,Bank_Name,Acc_No)" +
              "VALUES('"+ txtBankCode.Text +"','"+ txtBankName.Text +"','"+ txtAccNo.Text +"')";

SqlConnection MySqlConn = new SqlConnection(MyConnectionString);
SqlCommand    MySqlComm = new SqlCommand(MySQLString, MySqlConn);
// MySqlConn and MySqlComm refer to variable and not the DBMS
MySqlComm.Connection.Open();
MySqlComm.ExecuteNonQuery();
MySqlComm.Connection.Close();


mwith wrote:
And can anybody explain me, what are the good/bad coding practices with this?


When working with DB try your best to keep it simple.

Also, check the SQL statement if Bank_Code and Acc_No are 'int' data types then you need to convert the textboxes from string to int. i.e. Convert.ToInt32(txtBankCode.Text)
Good Luck,
Jason




-- modified at 12:01 Thursday 11th January, 2007

Programmer: A biological machine designed to convert caffeine into code. * Developer: A person who develops working systems by writing and using software.
[^]

Questionserialize treeview [modified] Pin
Maddie from Dartford10-Jan-07 18:23
Maddie from Dartford10-Jan-07 18:23 
Questionwindows exe Pin
raju_net181810-Jan-07 18:00
raju_net181810-Jan-07 18:00 
AnswerRe: windows exe Pin
Christian Graus10-Jan-07 18:36
protectorChristian Graus10-Jan-07 18:36 
AnswerRe: windows exe Pin
ednrgc11-Jan-07 3:08
ednrgc11-Jan-07 3:08 
QuestionXML Parser in c# Pin
aruna_koride10-Jan-07 17:22
aruna_koride10-Jan-07 17:22 
AnswerRe: XML Parser in c# Pin
Christian Graus10-Jan-07 18:40
protectorChristian Graus10-Jan-07 18:40 
QuestionAny One Modbus Pin
sajid.salim.khan10-Jan-07 17:15
sajid.salim.khan10-Jan-07 17:15 
QuestionLeading Zeros in a DateTime Structure Pin
eggie510-Jan-07 14:46
eggie510-Jan-07 14:46 
AnswerRe: Leading Zeros in a DateTime Structure Pin
Scott Dorman10-Jan-07 15:33
professionalScott Dorman10-Jan-07 15:33 
GeneralRe: Leading Zeros in a DateTime Structure Pin
eggie511-Jan-07 8:50
eggie511-Jan-07 8:50 
GeneralRe: Leading Zeros in a DateTime Structure Pin
Scott Dorman11-Jan-07 13:01
professionalScott Dorman11-Jan-07 13:01 
QuestionMDA ContestSwitchDeadlock Pin
Nooie10-Jan-07 13:42
Nooie10-Jan-07 13:42 
AnswerRe: MDA ContestSwitchDeadlock Pin
Nader Elshehabi10-Jan-07 14:00
Nader Elshehabi10-Jan-07 14:00 
GeneralRe: MDA ContestSwitchDeadlock Pin
Nooie10-Jan-07 14:08
Nooie10-Jan-07 14:08 
GeneralRe: MDA ContestSwitchDeadlock Pin
Nooie10-Jan-07 14:18
Nooie10-Jan-07 14:18 
GeneralRe: MDA ContestSwitchDeadlock Pin
Nader Elshehabi10-Jan-07 14:20
Nader Elshehabi10-Jan-07 14:20 
GeneralRe: MDA ContestSwitchDeadlock Pin
Nooie10-Jan-07 14:27
Nooie10-Jan-07 14:27 

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.