SqlConnection con = new SqlConnection(strCon);
con.Open();
DataTable dt = new DataTable();
int i = 0;
for (; i < 100; i++)
{
if (dgvM[data.Text.ToString(), i].Value.ToString() == null)
{
string command1 = "INSERT INTO montarze ([" + data.Text.ToString() +
"]) VALUES('" + Miasto_z.Text.ToString() + "')";
string command2 = "INSERT INTO montarze ([" + data.Text.ToString() +
"]) VALUES('" + Targi.Text.ToString() + "')";
string command3 = "INSERT INTO montarze ([" + data.Text.ToString() +
"]) VALUES('" + stoisko_z.Text.ToString() + "')";
SqlDataAdapter sda1 = new SqlDataAdapter(command1, con);
SqlCommandBuilder cb1 = new SqlCommandBuilder(sda1);
sda1.Fill(dt);
SqlDataAdapter sda2 = new SqlDataAdapter(command2, con);
SqlCommandBuilder cb2 = new SqlCommandBuilder(sda2);
sda2.Fill(dt);
SqlDataAdapter sda3 = new SqlDataAdapter(command3, con);
SqlCommandBuilder cb3 = new SqlCommandBuilder(sda3);
sda3.Fill(dt);
break;
}
else
{
if (dgvM[data.Text.ToString(), i].Value.ToString() == "")
{
MessageBox.Show("ok");
}
else
{
if (dgvM[data.Text.ToString(), i].Value.ToString() == Miasto_z.Text)
{
if (dgvM[data.Text.ToString(), i].Value.ToString() == Targi.Text)
{
if (dgvM[data.Text.ToString(), i].Value.ToString() == stoisko_z.Text)
{
MessageBox.Show("Stoisko Juz isteniej");
break;
}
else
{
string command3 = "INSERT INTO montarze ([" + data.Text.ToString() +
"]) VALUES('" + stoisko_z.Text.ToString() + "')";
SqlDataAdapter sda = new SqlDataAdapter(command3, con);
SqlCommandBuilder cb = new SqlCommandBuilder(sda);
sda.Fill(dt);
break;
}
}
else
{
string command2 = "INSERT INTO montarze ([" + data.Text.ToString() +
"]) VALUES('" + Targi.Text.ToString() + "')";
string command3 = "INSERT INTO montarze ([" + data.Text.ToString() +
"]) VALUES('" + stoisko_z.Text.ToString() + "')";
SqlDataAdapter sda2 = new SqlDataAdapter(command2, con);
SqlCommandBuilder cb = new SqlCommandBuilder(sda2);
sda2.Fill(dt);
SqlDataAdapter sda3 = new SqlDataAdapter(command3, con);
SqlCommandBuilder cb1 = new SqlCommandBuilder(sda3);
sda3.Fill(dt);
break;
}
}
else
{
string command1 = "INSERT INTO montarze ([" + data.Text.ToString() +
"]) VALUES('" + Miasto_z.Text.ToString() + "')";
string command2 = "INSERT INTO montarze ([" + data.Text.ToString() +
"]) VALUES('" + Targi.Text.ToString() + "')";
string command3 = "INSERT INTO montarze ([" + data.Text.ToString() +
"]) VALUES('" + stoisko_z.Text.ToString() + "')";
SqlDataAdapter sda1 = new SqlDataAdapter(command1, con);
SqlCommandBuilder cb1 = new SqlCommandBuilder(sda1);
sda1.Fill(dt);
SqlDataAdapter sda2 = new SqlDataAdapter(command2, con);
SqlCommandBuilder cb2 = new SqlCommandBuilder(sda2);
sda2.Fill(dt);
SqlDataAdapter sda3 = new SqlDataAdapter(command3, con);
SqlCommandBuilder cb3 = new SqlCommandBuilder(sda3);
sda3.Fill(dt);
break;
}
}
}
}
}
}
na samym poczatku w 1 warunku wyskakuje błąd:
Odwołanie do obiektu nie zostało ustawione na wystąpienie obiektu.
nie wiem juz co wymyslec