I'm trying to make a website that people can upload file to the server, then the webpage will automatically insert the username and the file name into the database. I have thought about this for couple days but still got nothing. can some one help me?
can some one post a very simple aspx file that can insert a record to the sql database with C#? Not the code that generated by ASP.net 2.0!
I want to see how to access the database manually.
Thank you.
A quick example:
protected void Button1_Click(object sender, EventArgs e)
{
string connectionString = @."Data Source=Confute;Initial Catalog=AdventureWorks;Integrated Security=SSPI";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataSource sds = new SqlDataSource(connectionString, "select * from Orders (where EmployeeID in (@.list))");
SqlCommand cmd = new SqlCommand("insert into t1 (name) select @.name", connection);
//add text of txtBox_Name as input parameter for the insert command
cmd.Parameters.Add("name", txtBox_Name.Text);
connection.Open();
cmd.ExecuteNonQuery();
}
}
|||It is really help! Thank you very much
No comments:
Post a Comment