This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
error
An unhandled exception of type 'System.NotSupportedException' occurred in mscorlib.dll
Additional information: The given path's format is not supported.
code
if (tid.Text == "" || tname.Text == "" || tlink.Text == "")
MessageBox.Show("Please insert information");
else
{
string filePath = @"'" + tlink.Text + "'";
byte[] bytes = File.ReadAllBytes(filePath);
SqlConnection conn = new SqlConnection(@"Data Source=.;Initial Catalog=StudentProject;Integrated Security=True");
SqlCommand insert = new SqlCommand("insert into network values(@f1,@f2,@f3,f4,f5,f6,f7,f8,f9");
insert.Parameters.AddWithValue("@f1",tid.Text);
insert.Parameters.AddWithValue("@f2",tname.Text);
insert.Parameters.AddWithValue("@f3",textBox1.Text);
insert.Parameters.AddWithValue("@f4",textBox2.Text);
insert.Parameters.AddWithValue("@f5",textBox3.Text);
insert.Parameters.AddWithValue("@f6",textBox4.Text);
insert.Parameters.AddWithValue("@f7",textBox5.Text);
insert.Parameters.AddWithValue("@f8",textBox6.Text);
insert.Parameters.AddWithValue("@f9", bytes);
conn.Open();
insert.ExecuteNonQuery();
conn.Close();
@HoshangHassan-6250
I agree with Viorel-1, there is no reason to add a single quote before and after the path, the system cannot understand such a path:
'd:\test\db\db1.mdb'
If tlink.Text is a valid file path, then try this:
string filePath = tlink.Text;
byte[] bytes = File.ReadAllBytes(filePath);
Show an example of tlink.Text if it still never works.
error change to that
An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.dll
Additional information: ExecuteNonQuery: Connection property has not been initialized.
To solve this problem, try adding conn:
SqlCommand insert = new SqlCommand("insert into network values(@f1,@f2,@f3,f4,f5,f6,f7,f8,f9", conn);
After solving the connection problem, you will probably receive new errors, because the INSERT statement looks incorrect. Some ‘@’ and ‘)’ seem missing. Try fixing the syntax.