有这样一组代码
private void InsertData(string MediaName, string fileName, string saveName)
{
//string name=fileName.Substring(0, fileName.LastIndexOf('.'));
string imgName = saveName + ".jpg";//图片文件名;
string playName = saveName + ".flv";
string sqlstr = "insert into Media(FMediaName,FMediaUpPath,FMediaPlayPath,FMediaImgPath) values(@MName,@MUppath,@MPlaypath,@MImgpath)";
//string constr = ConfigurationManager.ConnectionStrings["sqlcon"].ToString();
SqlDataSource1.InsertCommand = sqlstr;
SqlDataSource1.InsertCommandType = SqlDataSourceCommandType.Text;// CommandType.Text;
SqlDataSource1.InsertParameters.Add("MName", MediaName);
SqlDataSource1.InsertParameters.Add("MUppath", PublicMethod.upFile + fileName);
SqlDataSource1.InsertParameters.Add("MPlaypath", PublicMethod.playFile + playName);
SqlDataSource1.InsertParameters.Add("MImgpath", PublicMethod.imgFile + imgName);
SqlDataSource1.Insert();
}
我想把它改成oleDbCommand格式 我照着百度来的格式改了一下
private void InsertData(string MediaName, string fileName, string saveName)
{
//string name=fileName.Substring(0, fileName.LastIndexOf('.'));
string imgName = saveName + ".jpg";//图片文件名;
string playName = saveName + ".flv";
//string constr = ConfigurationManager.ConnectionStrings["sqlcon"].ToString(); OleDbConnection con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=data.mdb");
OleDbCommand oldC=new OleDbCommand("insert into users (FMediaName, FMediaUpPath,FMediaPlayPath,FMediaImgPath) values (@MName, @MUppath,MPlaypath,@MImgpath)", con); }
然后我就无从下手了 请问这一段应该怎么改
SqlDataSource1.InsertParameters.Add("MName", MediaName);
SqlDataSource1.InsertParameters.Add("MUppath", PublicMethod.upFile + fileName);
SqlDataSource1.InsertParameters.Add("MPlaypath", PublicMethod.playFile + playName);
SqlDataSource1.InsertParameters.Add("MImgpath", PublicMethod.imgFile + imgName);
MSDN找了一下 好像没有发现 可能是我查找的方式不对吧 所以请各位大神帮忙指点一下 谢谢
private void InsertData(string MediaName, string fileName, string saveName)
{
//string name=fileName.Substring(0, fileName.LastIndexOf('.'));
string imgName = saveName + ".jpg";//图片文件名;
string playName = saveName + ".flv";
string sqlstr = "insert into Media(FMediaName,FMediaUpPath,FMediaPlayPath,FMediaImgPath) values(@MName,@MUppath,@MPlaypath,@MImgpath)";
//string constr = ConfigurationManager.ConnectionStrings["sqlcon"].ToString();
SqlDataSource1.InsertCommand = sqlstr;
SqlDataSource1.InsertCommandType = SqlDataSourceCommandType.Text;// CommandType.Text;
SqlDataSource1.InsertParameters.Add("MName", MediaName);
SqlDataSource1.InsertParameters.Add("MUppath", PublicMethod.upFile + fileName);
SqlDataSource1.InsertParameters.Add("MPlaypath", PublicMethod.playFile + playName);
SqlDataSource1.InsertParameters.Add("MImgpath", PublicMethod.imgFile + imgName);
SqlDataSource1.Insert();
}
我想把它改成oleDbCommand格式 我照着百度来的格式改了一下
private void InsertData(string MediaName, string fileName, string saveName)
{
//string name=fileName.Substring(0, fileName.LastIndexOf('.'));
string imgName = saveName + ".jpg";//图片文件名;
string playName = saveName + ".flv";
//string constr = ConfigurationManager.ConnectionStrings["sqlcon"].ToString(); OleDbConnection con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=data.mdb");
OleDbCommand oldC=new OleDbCommand("insert into users (FMediaName, FMediaUpPath,FMediaPlayPath,FMediaImgPath) values (@MName, @MUppath,MPlaypath,@MImgpath)", con); }
然后我就无从下手了 请问这一段应该怎么改
SqlDataSource1.InsertParameters.Add("MName", MediaName);
SqlDataSource1.InsertParameters.Add("MUppath", PublicMethod.upFile + fileName);
SqlDataSource1.InsertParameters.Add("MPlaypath", PublicMethod.playFile + playName);
SqlDataSource1.InsertParameters.Add("MImgpath", PublicMethod.imgFile + imgName);
MSDN找了一下 好像没有发现 可能是我查找的方式不对吧 所以请各位大神帮忙指点一下 谢谢
这样写下去