Database

szSQLCommand1 = "INSERT INTO Files(Name, Size) VALUES(@Name, @Size)";<br />
szSQLCommand2 = "INSERT INTO FileData(Data) VALUES(@Data)";

			string szSQLCommand1;<br />
            string szSQLCommand2;<br />
			Int32 intFileSize;<br />
			byte[] rawData;<br />
			FileStream fsRead;<br />
<br />
			try<br />
			{<br />
				fsRead = new FileStream(lblPath.Text, FileMode.Open, FileAccess.Read);<br />
				intFileSize = Convert.ToInt32(fsRead.Length);<br />
<br />
				rawData = new byte[intFileSize];<br />
				fsRead.Read(rawData, 0, intFileSize);<br />
				fsRead.Close();<br />
<br />
                mySQLConnection.Open();<br />
                <br />
                szSQLCommand1 = "INSERT INTO Files(Name, Size) VALUES(@Name, @Size)";<br />
                szSQLCommand2 = "INSERT INTO FileData(Data) VALUES(@Data)";<br />
<br />
				cmd.Connection = mySQLConnection;<br />
				cmd.CommandText = szSQLCommand1;<br />
				cmd.Parameters.AddWithValue("@Name", txtName.Text);<br />
                cmd.Parameters.AddWithValue("@Size", intFileSize);<br />
<br />
                cmd2.Connection = mySQLConnection;<br />
                cmd2.CommandText = szSQLCommand2;<br />
                cmd2.Parameters.AddWithValue("@Data", rawData);<br />
<br />
				cmd.ExecuteNonQuery();<br />
                cmd2.ExecuteNonQuery();<br />
<br />
				MessageBox.Show("File Inserted into database successfully!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);<br />
<br />
				mySQLConnection.Close();

Leia2011 wrote:

how can I create a new table?

Leia2011 wrote:

Is this possible?

Leia2011 wrote:

do you have any ideas?