SQL + C# connection

[Thelastairbender]

---

uhmm mga bro ask lang unta ko unsaon ug connect sa ako program sa ako sql file....la pa ni discuss sa amo pero advance study ra ko...unsaon diay ni siya mga bro na mag insert ko data sa ako table using c# codes? tnx really appreciate if naay mo reply...

[nullpointer]

uhmm mga bro ask lang unta ko unsaon ug connect sa ako program sa ako sql file....la pa ni discuss sa amo pero advance study ra ko...unsaon diay ni siya mga bro na mag insert ko data sa ako table using c# codes? tnx really appreciate if naay mo reply...

What sql server are you using? MS Sql, Mysql, Oracle, Postgre, etc?

[Thelastairbender]

microsoft server 2005 amo gamit sir

[khiphistos]

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
class Program
{
static SqlConnection conn;
static void Main(string[] args)
{
string strConn = @"Server =(local); database=TestDB; uid= sa; pwd =pass19251950";

try
{
conn = new SqlConnection(strConn);
conn.Open();
Console.WriteLine("Successfully open........");

}
catch (SqlException e)
{
Console.WriteLine(e.Message);

}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
Console.WriteLine("Successfully close........");

}
}
Console.ReadLine();

}
}
}

[nullpointer]

microsoft server 2005 amo gamit sir

You use khiphistos codes for connecting to the db server.

For data manipulation you can have the basics

Insert record
...
SqlCommand command =
new SqlCommand("INSERT INTO table1 " +
"VALUES('Test','Test',123,'blaah');",
conn);
command.ExecuteNonQuery();

Console.WriteLine("A new record has been created.");
...

Retrieving data

...
SqlCommand command =
new SqlCommand("SELECT * FROM table1",conn);
SqlDataReader reader = command.ExecuteReader();
while(reader.Read()){
Console.WriteLine(reader.GetString(0));
....
....
}
reader.Close();
Console.WriteLine("End of program.");
...

[Deathnote]

conn;<----is this a variable?
and whats reader?
reader.Close();

[nullpointer]

conn;<----is this a variable?
and whats reader?
reader.Close();

hehehe...
I presume that the object conn is the taken from khiphistos code which is the SqlConnection object..

reader object is the SqlDataReader which is used to traverse the data return by SqlCommand....basically command.ExecuteReader() method call. If you inspect ExecuteReader() method of SqlCommand it returns SqlDataReader object.

reader.Close() - its always safe to close open data reader when its not in use anymore.