i have c# String look like this:
String name is finaloutput
"IP,C1,PktUp,PktDown,Upstream,Downstream,C2,C3,C4,C5\r\n192.168.1.56,0,77776,98364,9203233,96637437,0,0,0,0\r\n192.168.1.12,0,80718,105922,11845169,94299988,0,0,0,0"
i want to insert String data to sql database table
this is my column header
IP,C1,PktUp,PktDown,Upstream,Downstream,C2,C3,C4,C5
this is my data row
192.168.1.56,0,77776,98364,9203233,96637437,0,0,0,0
192.168.1.12,0,80718,105922,11845169,94299988,0,0,0,0
my table name is usage
my table column name is
IP C1 PktUp PktDown Upstream Downstream C2 C3 C4 C5
how to insert data to my table.
i try this code but insert first row only.
private void button1_Click(object sender, EventArgs e)
{
string finaloutput = "IP,C1,PktUp,PktDown,Upstream,Downstream,C2,C3,C4,C5\r\n192.168.1.56,0,77776,98364,9203233,96637437,0,0,0,0\r\n192.168.1.12,0,80718,105922,11845169,94299988,0,0,0,0";
string[] fields = finaloutput.Split(',');
using (SqlConnection con = new SqlConnection(@"Data Source='localhost';Initial Catalog='NetUsage';User ID='sa';Password='tstc123'"))
{
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO usage(IP, Upstream, Downstream) VALUES (@IP, @Upstream, @Downstream)", con);
cmd.Parameters.AddWithValue("@IP", fields[0].ToString());
cmd.Parameters.AddWithValue("@Upstream", fields[4].ToString());
cmd.Parameters.AddWithValue("@Downstream", fields[5].ToString());
cmd.ExecuteNonQuery();
}
}
look like this
IP Upstream Downstream
IP Upstream Downstream
i want to this
IP Upstream Downstream
192.168.1.56 9203233 96637437
192.168.1.12 11845169 94299988
Plz help me i am new to c#