锐客网

  1. 首页 > 睿知 > it技术 > >

vb.net无法保存 为什么vb保存后打不开

IT技术保存

vb.net，数据库插入数据后不保存给vb.net无法保存你一段vb.net无法保存我过去的vb代码,vb连接access的,用adodb,很方便
代码比较丑陋,凑合看吧,是个自用的通讯录程序
txl是表名,Mobile,QQ,MSN...都是字段名称
'将列表框内容逐项加入数据库,创建更新sql字串
sqlString
=
"update
txl
set
Mobile='"
Trim$(txt(1).Text)
"',QQ='"
_
Trim$(txt(2).Text)
"',MSN='"
Trim$(txt(3).Text)
"',Email='"
Trim$(txt(4).Text)
"',Phone='"
_
Trim$(txt(5).Text)
"',Home='"
Trim$(txt(6).Text)
"',Birthday='"
txt(7).Text
"',Address='"
_
Trim$(txt(8).Text)
"',Postcode='"
Trim$(txt(9).Text)
"',Info='"
Trim$(txt(10).Text)
_
"'
where
Name='"
Trim$(ListView1.ListItems.Item(SelectIndex).Text)
"'"
'更新记录
Set
rs
=
conn.Execute(sqlString,
,
adCmdText)
要创建全局变量
Dim
conn
As
ADODB.Connection
'数据库连接
然后form在load的时候打开链接,可以操作数据库
'连接无密码数据库
Set
conn
=
New
ADODB.Connection
conn.ConnectionString
=
_
"Provider=Microsoft.Jet.OLEDB.4.0;"
_
"Data
Source="
dbName
";"
_
"Persist
Security
Info=False"
'打开连接
conn.Open 。
vb.net修改DATAGridview后保存与ACCESS错误一般是将access数据库绑定到datagridview中，要添加数据只需要datagridview1.Item(3, 0).Value=https://www.04ip.com/post/XXX这种就行了，删除修改同理 。保存到access是你已经有了一个access表吧？不然字段都要新建的 。如果要保存到数据库的话就调用sql语句链接数据库了，我找个以前的代码Dim OleDbConn As OleDbConnection = New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=保存信息\保存信息.mdb;persist security info=false")
OleDbConn.Open()
Dim adapter As New OleDbCommand("insert into 受检单位信息(检测日期,测量器具) values(#" + DateTimePicker1.Value + "#,'" + 测量器具 + "')", OleDbConn)
adapter.ExecuteNonQuery()
Asp.net VB保存数据问题,无法保存到数据库database
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// summary
/// database vb.net无法保存的摘要说明
/// /summary
public class database
{
private SqlConnection conn;
public database()
{
//
// TODO: 在此处添加构造函数逻辑
//
string sqlcon = "Server=localhost;Initial catalog=mydb;user=sa;password=123456";
conn = new SqlConnection(sqlcon);
}
public int executenon(string sqlstr)
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
int num = cmd.ExecuteNonQuery();
return num;
conn.Close();
}
public int executesal(string sqlstr)
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
int num = Convert.ToInt32(cmd.ExecuteScalar());
return num;
conn.Close();
}
public SqlDataReader executeread(string sqlstr)
{
SqlDataReader dr = null;
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
dr=cmd.ExecuteReader();
return dr;
conn.Close();
}
public DataSet executedataset(string sqlstr)
{
DataSet ds=null;
try
{
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);

推荐阅读


上一篇：c语言套接字什么意思，c 套接字

下一篇：gis母线漏气处理，gis母线穿墙封堵装置