how to put data from MySQL to C#

Question

0.00/5 (No votes)

See more:

hey I'm already done for the searching method and all i want to do is to put the data into the textbox.

For example I need pull data from DB using ID and set other info in required text box, ID is provided by user in a Text Box.

thanks for helping me.. :)) GOD BLESS!

my code.....

C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
namespace WindowsFormsApplication17.Forms
{
public partial class Form7 : Form
{
public Form7()
{
InitializeComponent();
}

private void btnAdd_Click(object sender, EventArgs e)
{
string input = txtStudID.Text.Trim();
string conn = "server=localhost;user=root;password=1;database=record;";
MySqlConnection myconn = new MySqlConnection(conn);
string sql = "SELECT `StudentID` FROM `Information` WHERE `StudentID` = '" + input + "';";
MySqlDataAdapter da = new MySqlDataAdapter(sql, myconn);
MySqlDataReader reader;
DataTable dt = new DataTable();
da.Fill(dt);

if (dt.Rows.Count == 0)
{
MessageBox.Show(input + " does not exist.", "Not Exists");
txtStudID.Focus();
txtStudID.Text = "";

}
else
{
//this for textboxes that will display the data from column..
txtStudName.Text = dt.Columns[0] + "";
txtAdd.Text = dt.Columns + "address";
txtContact.Text = dt.Columns + "Contact";

}
}

private void btnClose_Click(object sender, EventArgs e)
{
Form1 form1 = new Form1();
form1.Show();
this.Hide();

}
}
}

Posted 24-Sep-13 21:03pm

black_diamond

Updated 24-Sep-13 21:17pm

Suvabrata Roy

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*Suvabrata Roy* · Accepted Answer · 2013-09-24T21:14:00

Hi,

C#

txtAdd.Text = dt.Columns + "address";
txtContact.Text = dt.Columns + "Contact";

This part is bit confusing for me apart from that.

you should write the code in this way,

C#

string input = txtStudID.Text.Trim();
// This a very bad thing to put Connection string with in the code.
string conn = "server=localhost;user=root;password=1;database=record;"; 

MySqlConnection myconn = new MySqlConnection(conn);
// Change Field Name as you have in your Table
string sql = "SELECT `StudentAdd`,`StudentName`,`StudentContact` FROM `Information` WHERE `StudentID` = '" + input + "';";
MySqlDataAdapter da = new MySqlDataAdapter(sql, myconn);
MySqlDataReader reader;
DataTable dt = new DataTable();
da.Fill(dt);

 
if (dt.Rows.Count == 0)
{
MessageBox.Show(input + " does not exist.", "Not Exists");
txtStudID.Focus();
txtStudID.Text = "";
 
}
else
{
//this for textboxes that will display the data in column..
// I guess that not data contains null 
txtStudName.Text = dt.Rows[0]["StudentName"].ToString() + "";
txtAdd.Text = dt.Rows[0]["StudentAdd"].ToString() + "address";
txtContact.Text = dt.Rows[0]["StudentContact"].ToString() + "Contact"; 
 

 
}