static public void readFunc()
{
SqlConnection con = DoConneection.funcConnection();
try
{
con.Open();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT [ROLL_NO],[SUBJECT],[MARKS] FROM [dbo].[MARKS] ");
String sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, con))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine("{0} {1} {2}", reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2));
}
Console.ReadLine();
}
}
con.Close();
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
}
static public void insertFunc()
{
SqlConnection con = DoConneection.funcConnection();
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[MARKS] ([ROLL_NO],[SUBJECT],[MARKS]) VALUES(4,'Arts',99)");
String sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, con))
{
using (SqlDataReader reader = command.ExecuteReader())
{
con.Open();
while (reader.Read())
{
Console.WriteLine("{0} {1} {2}", reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2));
}
Console.ReadLine();
}
}
con.Close();
}
static public void updateFunc()
{
SqlConnection con = DoConneection.funcConnection();
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE FROM [dbo].[MARKS] SET SUBJECT='MATHS' where ROLL_NO=1");
String sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, con))
{
using (SqlDataReader reader = command.ExecuteReader())
{
con.Open();
while (reader.Read())
{
Console.WriteLine("{0} {1} {2}", reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2));
}
Console.ReadLine();
}
}
con.Close();
}
