sql = "insert into ChatRoom(姓名,內容) values (?,?)" Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand(sql, conn) 不用加cmd = New OleDb.OleDbCommand(sql, conn) 试试
what is "values (?,?)"?? did you fill the parameters?
values (?,?)是什么意思,如果是字符就改为values ('?','?')
saucer(思归, MS .NET MVP) 這是一種格式 sql裡有的。 看你的五顆星,長老級人物。
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand(SQLcmd, conn) sql = "insert into ChatRoom(姓名,內容) values (?,?)" cmd = New OleDb.OleDbCommand(sql, conn) 直接用: sql = "insert into ChatRoom(姓名,內容) values (?,?)" Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand (sql, conn) 还有如果有参数的话,还要看参数是否处理了.再看看,访问mdb,有没有权限.
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand(SQLcmd, conn) sql = "insert into ChatRoom(姓名,內容) values (?,?)" cmd = New OleDb.OleDbCommand(sql, conn) cmd.ExecuteNonQuery() 虽然系统报错是cmd.ExecuteNonQuery()其实是cmd = New OleDb.OleDbCommand(sql, conn)句错,重复做两次。 sql = "insert into ChatRoom(姓名,內容) values (?,?)" Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand(sql, conn) 即可,注意:是sql而不是SQLcmd。
就用northwind(北風)的這個資料庫吧。 因為這是個默認的資料庫
this.Label1.Text = this.File1.PostedFile.ContentType; byte[] FileContent = new Byte[this.File1.PostedFile.InputStream.Length]; this.File1.PostedFile.InputStream.Position =0; this.File1.PostedFile.InputStream.Read(FileContent,0,FileContent.Length); string fileType = this.File1.PostedFile.ContentType; string fileName = this.File1.PostedFile.FileName; string SqlStr = "insert filetest(fileName,fileType,fileDetail) values(@Name,@fileType,@fileDetail)"; // string SqlStr = "insert filetest(fileName,fileType,fileDetail) values(?,?,?)"; SqlCommand com = new SqlCommand(SqlStr); com.Parameters.Add("@Name",fileName); com.Parameters.Add("@fileType",fileType); com.Parameters.Add("@fileDetail",FileContent); SqlDataConnector con = new SqlDataConnector(); con.SqlOpen(); con.ExecuteSqlCommand(com);C#的例子,昨天写的关于上传文件的。你翻译成VB的就可以了!你哪种方式没有见过。我想应该是参数的吧。但是你都更本没有处理参数,自然就不行了。
string sqlstr = String.Format("Insert into I_CONCURRENTCTR Values('{0}','{1}','{2}','{3}',0)", iid,tache.TacheId,flow.VirtualEnd(flow,flow.GetVexIndex(tache.TacheId),1).TacheId,count);也可以用这种方式,给参数传值,给了参数,就必须给参数的值
Private Sub Edit_Data(ByVal DBName As String, ByVal SQLcmd As String) Dim conn As OleDb.OleDbConnection Dim rd As OleDb.OleDbDataReader Dim provider = "provider=microsoft.jet.oledb.4.0" Dim database = "data source=" & Server.MapPath("ChatRoom.mdb") conn = New OleDb.OleDbConnection(provider & ";" & database) conn.Open() Dim cmd As OleDb.OleDbCommand cmd = New OleDb.OleDbCommand("insert into chatroom(姓名,內容) values('" & Session("name") & "','" & txtspeak.Text & "')", conn) cmd.ExecuteNonQuery() '***!!!為什麼老報一句的錯---"運行必須使用更新查詢"!!!!誰能告訴我為什麼? conn.Close() End Sub
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand(sql, conn)
不用加cmd = New OleDb.OleDbCommand(sql, conn)
试试
sql裡有的。
看你的五顆星,長老級人物。
sql = "insert into ChatRoom(姓名,內容) values (?,?)"
cmd = New OleDb.OleDbCommand(sql, conn)
直接用: sql = "insert into ChatRoom(姓名,內容) values (?,?)"
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand (sql, conn)
还有如果有参数的话,还要看参数是否处理了.再看看,访问mdb,有没有权限.
我看過它的權限了,可寫入
所以我想幹脆你們給我一個例子,就是在資料庫裡或是mdb檔的某個table插入,刪除一筆資料.:)
謝啦,分不夠可以再up
sql = "insert into ChatRoom(姓名,內容) values (?,?)"
cmd = New OleDb.OleDbCommand(sql, conn)
cmd.ExecuteNonQuery()
虽然系统报错是cmd.ExecuteNonQuery()其实是cmd = New OleDb.OleDbCommand(sql, conn)句错,重复做两次。
sql = "insert into ChatRoom(姓名,內容) values (?,?)"
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand(sql, conn)
即可,注意:是sql而不是SQLcmd。
因為這是個默認的資料庫
byte[] FileContent = new Byte[this.File1.PostedFile.InputStream.Length];
this.File1.PostedFile.InputStream.Position =0;
this.File1.PostedFile.InputStream.Read(FileContent,0,FileContent.Length);
string fileType = this.File1.PostedFile.ContentType;
string fileName = this.File1.PostedFile.FileName;
string SqlStr = "insert filetest(fileName,fileType,fileDetail) values(@Name,@fileType,@fileDetail)";
// string SqlStr = "insert filetest(fileName,fileType,fileDetail) values(?,?,?)";
SqlCommand com = new SqlCommand(SqlStr);
com.Parameters.Add("@Name",fileName);
com.Parameters.Add("@fileType",fileType);
com.Parameters.Add("@fileDetail",FileContent);
SqlDataConnector con = new SqlDataConnector();
con.SqlOpen();
con.ExecuteSqlCommand(com);C#的例子,昨天写的关于上传文件的。你翻译成VB的就可以了!你哪种方式没有见过。我想应该是参数的吧。但是你都更本没有处理参数,自然就不行了。
iid,tache.TacheId,flow.VirtualEnd(flow,flow.GetVexIndex(tache.TacheId),1).TacheId,count);也可以用这种方式,给参数传值,给了参数,就必须给参数的值
Dim conn As OleDb.OleDbConnection
Dim rd As OleDb.OleDbDataReader Dim provider = "provider=microsoft.jet.oledb.4.0"
Dim database = "data source=" & Server.MapPath("ChatRoom.mdb")
conn = New OleDb.OleDbConnection(provider & ";" & database)
conn.Open() Dim cmd As OleDb.OleDbCommand
cmd = New OleDb.OleDbCommand("insert into chatroom(姓名,內容) values('" & Session("name") & "','" & txtspeak.Text & "')", conn) cmd.ExecuteNonQuery() '***!!!為什麼老報一句的錯---"運行必須使用更新查詢"!!!!誰能告訴我為什麼?
conn.Close()
End Sub