Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
5
Reply
How can I insert at the first line into my database
Israel
Jan 25 2017 9:19 AM
242
Reply
Hi!
I need to try something I never tryied before.
With these codes I can insert records ONLY at the end of my database.
But I would like to learn how can I insert one row as the first row among all the rows.
if (conn.State != ConnectionState.Open)
conn.Open();
OleDbParameter data = new OleDbParameter("@data", OleDbType.VarChar);
OleDbParameter qde = new OleDbParameter("@qde", OleDbType.VarChar);
OleDbParameter descritivo = new OleDbParameter("@descritivo", OleDbType.VarChar);
comm.Parameters.Add(data);
comm.Parameters.Add(qde);
comm.Parameters.Add(descritivo);
data.Value = "0";
qde.Value = "0";
descritivo.Value = "-";
comm.Connection = conn;
//comm.CommandText = "insert into facturacao ([data],[qde],[descritivo]) values(@data,@qde,@descritivo)";
comm.CommandText = "insert into mesa1 ([data],[qde],[descritivo]) values(@data,@qde,@descritivo)";
comm.ExecuteNonQuery();
{
conn.Close();
}
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
How to convert varchar to datetime in Sql server database
Create whatsAapp chat using C# Windows Applicaiton