Assigning a database value to a string in c#(.net)

Question

actually i am making a login system so i want to know how can we assign a value read from the database to any string variable in a database?

Sunny Sharma · Answer

Hi, To use MySql Database in C#, download and install MySql .NET connector from here: http://dev.mysql.com/downloads/connector/net/ After you finish installation,add reference to MySql.Data.dll and add namespace as: Using MySql.Data.MySqlClient; Syntax for ConnectionString is as follows: "Server=localhost;uid=username;password=pwd;database=test;pooling=false;" Below is a sample code snippet which will enable you to connect and perform operations on MySql Database: //Create and initialize the connection and command MySqlConnection conn = new MySqlConnection(connectionString); MySqlCommand cmd = new MySqlCommand("select * from table", conn); try { conn.Open(); } catch(Exception ex) { // Database connection error; } if (conn.State == ConnectionState.Open) //ConnectionState Enum is contained in System.Data namespace { //Perform operations here MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string name = reader.GetString(0); //Here you assign the values from database to variables } } if (conn.State == ConnectionState.Open) { try { conn.Close(); } catch { } } ---------------------------------------------------------------------------------- Happy Coding :) Please don't forget to accept this as answer if it helps! Thanks.

ejaz ul haq · Answer

Sure buddy :) just let me try

ejaz ul haq · Answer

i am using mysql

Sunny Sharma · Answer

which database you're using, I mean... SQL Server, MySQL... ?

Assigning a database value to a string in c#(.net)

Answers (4)