正文
vb.net无法保存 excel vba无法保存
小程序:扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序
【扫一扫了解最新限行尾号】
复制小程序
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);
ds = new DataSet("userDataset");
da.Fill(ds, "userTable");
return ds;
}
catch
{
return ds;
}
}
}
order
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.Text;
using System.Collections;
/// summary
/// order 的摘要说明
/// /summary
public class order
{
public order()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
}
public class OrderItemInfo
{
public int ProductID;
public int Number;
public double Price;
public string Name;
}
public class OrderInfo
{
public int TotalNumber;
public double TotalMoney;
public ArrayList OrderItemList = new ArrayList();
}
注册页面
database db = new database();
String xb;
if (RadioButton1.Checked == true)
xb = "男";
else
xb = "女";
string sqlstr = "insert memberlist(memberid,memberpwd,membersex,membere_mail) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + xb + "','" + TextBox4.Text + "')";
int num = db.executenon(sqlstr);
if (num 0)
{
Response.Write("script language='javascript'alter('注册成功')/script");
Response.Redirect("Default.aspx");
}
else
{
Response.Write("script language='javascript'alert('注册不成功')/script");
Response.Redirect("loginpage.aspx");
登陆按钮
string meid = TextBox1.Text;
string mepwd = TextBox2.Text;
string sqlstr = null;
if (RadioButton1.Checked)
{
sqlstr = "select count(memberid) from guanglilist where memberid='" + meid + "' and memberpwd='" + mepwd + "'";
}
else
{
sqlstr = "select count(memberid) from memberlist where memberid='" + meid + "' and memberpwd='" + mepwd + "' and checked='已审核'";
}
database db = new database();
int num = db.executesal(sqlstr);
if (num 0)
{
Response.Write("script language='javascript'alter('登陆成功')/script");
MultiView1.ActiveViewIndex = 1;
if (RadioButton1.Checked)
{
HyperLink1.Visible = true;
}
else
{
HyperLink1.Visible = false;
}
}
else
Response.Write("script language='javascript'alert('登录失败')/script");
HttpCookie cookie = new HttpCookie("loginMessage");
cookie.Values.Add("meid", meid);
Response.Cookies.Add(cookie);
Label3.Text = meid;
密码修改
protected void Page_Load(object sender, EventArgs e)
{
if (null != Request.Cookies["loginMessage"])
{
HttpCookie cookie = Request.Cookies["loginMessage"];
Label2.Text = Request.Cookies["loginMessage"]["meid"].ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string opwd = TextBox1.Text;
string npwd = TextBox2.Text;
string usid = Label2.Text;
string sqlstr = "update guanglilist set memberpwd='" + npwd + "' where memberid='" + usid + "' and memberpwd='" + opwd + "'";
database db = new database();
int num = db.executenon(sqlstr);
if (num 0)
{
Response.Write("script language='javascript'alert('密码修改成功')/script");
}
else
{
Response.Write("script language='javascript'alert('原密码错误')/script");
}
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
}
成员管理
屏蔽vb.net无法保存,审核:
string id = Convert.ToString(GridView1.SelectedDataKey.Value);
Response.Redirect("detail.aspx?id=" + id);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("check"))
{
string id = Convert.ToString(GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)].Value);
string sqlstr = "update memberlist set checked='已审核' where id='" + id + "'";
SqlDataSource1.UpdateCommand = sqlstr;
SqlDataSource1.Update();
}
if (e.CommandName.Equals("uncheck"))
{
string id = Convert.ToString(GridView1.DataKeys[Convert.ToInt32(e.CommandArgument)].Value);
string sqlstr = "update memberlist set checked='未审核' where id='" + id + "'";
SqlDataSource1.UpdateCommand = sqlstr;
SqlDataSource1.Update();
}
新闻管理
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["model"] = Request["model"];
ViewState["id"] = Request["id"];
if (ViewState["model"].ToString().Equals("edit"))
{
database db = new database();
string sqlstr = "select * from newlise where id=" + Convert.ToInt32(ViewState["id"]);
SqlDataReader dr = db.executeread(sqlstr);
if (dr.Read())
{
TextBox1.Text = dr[1].ToString();
TextBox2.Text = dr[2].ToString();
}
}
}
}
“添加”
protected void Button1_Click(object sender, EventArgs e)
{
string tle = TextBox1.Text;
string cont = TextBox2.Text;
string sql;
database db = new database();
if (ViewState["model"].ToString().Equals("add"))
sql = "insert into newlist(title,content) values('" + tle + "','" + cont + "')";
else
sql = "update newlise set title='" + tle + "',content='" + cont + "' where id =" + Convert.ToInt32(ViewState["id"]);
int num = db.executenon(sql);
if (num 0)
Response.Write("script language='javascript' alert ('提交成功!')/script");
else
Response.Write("script language='javascript' alert (提交不成功!')/script");
}
“编辑”
Response.Redirect("newsmanage.aspx?model=edit");
新书添加:
string lb_name = DropDownList1.SelectedValue.ToString();
string bk_name = TextBox2.Text;
string bk_auth = TextBox3.Text;
string bk_cbs = TextBox4.Text;
Double bk_pri = Convert.ToDouble(TextBox6.Text);
string bk_jj = TextBox1.Text;
string bk_ofile = File1.Value.ToString();
string[] tpfile = bk_ofile.Split('.');
string ext = "." + tpfile[tpfile.Length - 1];
Random r = new Random();
string bk_img = DateTime.Now.Year.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Second.ToString() + r.Next(100, 1000).ToString();
bk_img = bk_img + ext;
File1.PostedFile.SaveAs(Server.MapPath("image/") + bk_img);
bk_img = "image" + "/" + bk_img;
string sqlstr = "insert into booklist(bookname,autler,cbs,price,info,img,categary) values('" + bk_name + "','" + bk_auth + "','" + bk_cbs + "'," + bk_pri + ",'" + bk_jj + "','" + bk_img + "','" + lb_name + "')";
database db = new database();
int num = db.executenon(sqlstr);
if (num 0)
{
Response.Write("script language='javascript'alter('插入成功')/script");
Response.Redirect("bookmanage.aspx");
}
else
{
Response.Write("script language='javascript'alter('插入失败')/script");
}
购物
public partial class bookshop2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Request["name"] != null)
{
ViewState["name"] = Request["name"].ToString();
}
else
{
ViewState["name"] = "%";
}
if (!IsPostBack)
{
ViewState["pageindex"] = "0";
BindData(ViewState["name"].ToString());
}
}
private void BindData(string categoryName)
{
database db = new database();
string sqlstr = "SELECT * From booklist where categary like '%" + categoryName + "%'";
DataSet ds = db.executedataset(sqlstr);
DataTable dataTable = ds.Tables[0];
if (dataTable != null dataTable.Rows.Count 0)
{
DataView dataView = dataTable.DefaultView;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dataView;
pds.AllowPaging = true;
pds.PageSize = 2;
pds.CurrentPageIndex = Convert.ToInt32(ViewState["pageindex"].ToString());
lb_pageCount.Text = (Convert.ToInt32(ViewState["pageindex"]) + 1).ToString() + "/" + pds.PageCount.ToString() +
"页";
if (!pds.IsFirstPage)
{
lkPre.Visible = true;
}
else
{
lkPre.Visible = false;
}
if (!pds.IsLastPage)
{
lkNext.Visible = true;
}
else
{
lkNext.Visible = false;
}
DataList2.DataSource = pds;
DataList2.DataBind();
}
else
{
lkNext.Visible = false;
lkPre.Visible = false;
lb_pageCount.Visible = false;
}
}
protected void IndexChanging(object sender, EventArgs e)
{
string strCommand = ((LinkButton)sender).CommandArgument.ToString();
int pageindex = Convert.ToInt32(ViewState["pageindex"].ToString());
if (strCommand == "pre")
{
pageindex = pageindex - 1;
}
else
{
pageindex = pageindex + 1;
}
ViewState["pageindex"] = pageindex;
BindData(ViewState["aname"].ToString());
}
protected void DataList2_ItemCommand(object source, DataListCommandEventArgs e)
{
OrderItemInfo item = null;
OrderInfo order = null;
string cmdName = null;
int bookid = 0;
string sqlstr = null;
cmdName = e.CommandName.ToString();
if (cmdName.Equals("buyIt"))
{
bookid = Convert.ToInt32(e.CommandArgument);
sqlstr = "select bookname,price from booklist where id=" + bookid;
}
if (Request.Cookies["loginMessage"] != null)
{
if (Session[Session.SessionID] == null)
{
item = new OrderItemInfo();
order = new OrderInfo();
database db = new database();
SqlDataReader dr = db.executeread(sqlstr);
dr.Read();
item.ProductID = bookid;
item.Name = dr[0].ToString();
item.Number = 1;
item.Price = Convert.ToDouble(dr[1]);
order.OrderItemList.Add(item);
order.TotalMoney = item.Price;
order.TotalNumber = item.Number;
Session[Session.SessionID] = order;
}
else
{
order = (OrderInfo)Session[Session.SessionID];
item = new OrderItemInfo();
OrderItemInfo tempItem = null;
int i = 0;
for (i = 0; i order.OrderItemList.Count; i++)
{
tempItem = (OrderItemInfo)order.OrderItemList[i];
if (tempItem.ProductID == bookid)
{
tempItem.Number++;
order.TotalMoney += tempItem.Price;
break;
}
}
if (i == order.OrderItemList.Count)
{
database db = new database();
SqlDataReader dr = db.executeread(sqlstr);
dr.Read();
item.ProductID = bookid;
item.Name = dr[0].ToString();
item.Number = 1;
item.Price = Convert.ToDouble(dr[1]);
order.OrderItemList.Add(item);
order.TotalMoney += item.Price;
}
order.TotalNumber++;
Session[Session.SessionID] = order;
}
Response.Write("scriptwindow.alert('恭喜您,添加该商品到购物车成功vb.net无法保存!')/script");
}
else
{
Response.Write("scriptwindow.alert('未登陆用户不允许购买商品!')/script");
}
}
}
vb.net修改DATAGridview后保存与ACCESS错误
一般是将access数据库绑定到datagridview中,要添加数据只需要datagridview1.Item(3, 0).Value=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()
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 2003点击全部保存,为什么没反应
是保存vb.net无法保存了vb.net无法保存的vb.net无法保存,没事
vb.net无法保存的介绍就聊到这里吧,感谢你花时间阅读本站内容,更多关于excel vba无法保存、vb.net无法保存的信息别忘了在本站进行查找喔。