新建:
![9125154-b7f664a52120cc53.png](https://i-blog.csdnimg.cn/blog_migrate/5c7ad1c49195d79bef4759cee4b54421.webp?x-image-process=image/format,png)
新建数据库mydb.mdf、添加表:
![9125154-20d522eb4e4a25e1.png](https://i-blog.csdnimg.cn/blog_migrate/d1b6cf5467d4c47584e1863d6129fc54.webp?x-image-process=image/format,png)
更新数据库;
右击数据库,选择属性,复制连接字符串;(这里之前做过了,就简单点过不做细节。点击这里可以看详细步骤截图参考_《用ASP.NET做一个简单的数据流动展示》)
到web.config:
![9125154-c2fc2d5341e08ba9.png](https://i-blog.csdnimg.cn/blog_migrate/ddd8de6e879cfd5590382a9038c3d060.webp?x-image-process=image/format,png)
注意相对路径|DataDirectory|......
<connectionStrings>
<add name="DefaultConnection"
connectionString="Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=aspnet-manages-c703b6e8-d35a-4082-aadf-60f5ad784980;AttachDbFilename=|DataDirectory|\aspnet-manages-c703b6e8-d35a-4082-aadf-60f5ad784980.mdf;Integrated Security=SSPI"
providerName="System.Data.SqlClient"/>
<add name ="connstr" connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\mydb.mdf;Integrated Security=True"/>
</connectionStrings>
删除,重建default窗口文件;
设计,插入表:
![9125154-cb0aa81e132ee020.png](https://i-blog.csdnimg.cn/blog_migrate/740000319a1eb670de533b77bc53d017.webp?x-image-process=image/format,png)
![9125154-d36b715abc825634.png](https://i-blog.csdnimg.cn/blog_migrate/07aee4a97e2f034a05d3fcd3cc5cc6d7.webp?x-image-process=image/format,png)
设计:
顶行合并;
输入文字;
顶行内容居中;
二列添加textbox;
![9125154-2ad7d216d355e05c.png](https://i-blog.csdnimg.cn/blog_migrate/c67c54f14b2723d31b455f2d9bcde8a2.webp?x-image-process=image/format,png)
改id:
Name_TextBox
Cate_TextBox
Price_TextBox
Time_TextBox
Address_TextBox
Contact_TextBox
![9125154-a1f5f16ade9093a7.png](https://i-blog.csdnimg.cn/blog_migrate/d77422e8144161749d1baa4ba8b4331e.webp?x-image-process=image/format,png)
合并末行,加个button,修改text,加个GridView:
![9125154-0ce1fac81463e6c2.png](https://i-blog.csdnimg.cn/blog_migrate/e04abad138ac4d6fb2ae7200964b883c.webp?x-image-process=image/format,png)
![9125154-ff45af0620df2d9b.png](https://i-blog.csdnimg.cn/blog_migrate/87f563f3fac9ec1492b434e0d44888a2.webp?x-image-process=image/format,png)
![9125154-055489052ba35baf.png](https://i-blog.csdnimg.cn/blog_migrate/d273baf5bc2d92f984928a15295109ee.webp?x-image-process=image/format,png)
新建一个common类:
右击App_Code:
![9125154-632d700161a6acb5.png](https://i-blog.csdnimg.cn/blog_migrate/78c77bd1f54c767b13e2632e727b3e82.webp?x-image-process=image/format,png)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
/// <summary>
/// common 的摘要说明
/// </summary>
public class common
{
public common()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static SqlConnection myconn()
{
string connstr = ConfigurationManager.ConnectionStrings["connstr"].ToString();
SqlConnection myconn = new SqlConnection(connstr);
return myconn;
}
}
回来default窗口,双击设计界面里边入库按钮,开始编写逻辑:
![9125154-29b5a9f0d085f6e6.png](https://i-blog.csdnimg.cn/blog_migrate/974a622e13fef7cb4d367e6dde41da0c.webp?x-image-process=image/format,png)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
displayDB();
}
protected void Button1_Click(object sender, EventArgs e)
{
insertDB();
displayDB();
}
//套路:1.connstr-sqlconn-open打开数据库
//2.cmdstr-sqlcmd(cmdstr,conn)-cmd.ex执行数据库操作,或者其他;
//3.关闭
protected void insertDB()
{
SqlConnection myconn = common.myconn();
myconn.Open();
double Pricevalue = Convert.ToDouble(Price_TextBox.Text.Trim());
string cmdstr = @"insert into Tproduct(Fname,Fcategory,Fprice,Ftime,Faddress,Fcontactname)
values('" + Name_TextBox.Text + "' , '" + Cate_TextBox.Text + "' , " + Pricevalue + " , '" + Time_TextBox.Text + "' , '" + Address_TextBox.Text + "' , '" + Contact_TextBox.Text + "' )";
SqlCommand mycmd = new SqlCommand(cmdstr,myconn);
mycmd.ExecuteNonQuery();
mycmd.Dispose();
myconn.Close();
Response.Write("<script>alert('入库成功')</script>");
}
protected void displayDB()
{
string connstr = ConfigurationManager.ConnectionStrings["connstr"].ToString();
SqlConnection myconn = new SqlConnection(connstr);
myconn.Open();
string cmdstr = @"select * from Tproduct";
SqlDataAdapter myda = new SqlDataAdapter(cmdstr,myconn);//查出
DataSet myds = new DataSet();//转型
myda.Fill(myds);
GridView1.DataSource = myds;//赋能控件
GridView1.DataKeyNames = new string[] { "id" };
GridView1.DataBind();
myda.Dispose();
myds.Dispose();
myconn.Close();
}
}
如图,插入和展示就完成了:
![9125154-88ad5b3e916be8d2.png](https://i-blog.csdnimg.cn/blog_migrate/48932b2930b432423a01b5b29c670f8c.webp?x-image-process=image/format,png)
![9125154-ce60d06e965e7bd6.png](https://i-blog.csdnimg.cn/blog_migrate/c92c47c3e86d3fc64b4d42825e6df60c.webp?x-image-process=image/format,png)
现在增加查找功能:
末行配置多三个控件:
![9125154-0503291dbc950074.png](https://i-blog.csdnimg.cn/blog_migrate/b104c75900fe68e61a76a5b14f4b89cd.webp?x-image-process=image/format,png)
![9125154-c37b9686409ccb50.png](https://i-blog.csdnimg.cn/blog_migrate/41e69786c017d66f04bad0f042f5cf7b.webp?x-image-process=image/format,png)
![9125154-bb6f8c878c93a886.png](https://i-blog.csdnimg.cn/blog_migrate/92131b4c6fb2dd6495734cf4c8c2822d.webp?x-image-process=image/format,png)
分别添加点击逻辑即可:
protected void jqFind_Button_Click(object sender, EventArgs e)
{
SqlConnection myconn = common.myconn();
myconn.Open();
string cmdstr = "select *from Tproduct where Fname='" + Find_TextBox.Text.Trim() + "'";//单引号双引号括起来
SqlDataAdapter myda = new SqlDataAdapter(cmdstr, myconn);
DataSet myds = new DataSet();
myda.Fill(myds);
int rowNum = myds.Tables[0].Rows.Count;
int columnNum = myds.Tables[0].Columns.Count;
DataTable usingTable = myds.Tables[0];
if (rowNum == 0)
{
usingTable = usingTable.Clone();//克隆
usingTable.Rows.Add(usingTable.NewRow());//加新行
GridView1.DataSource = usingTable;//赋能
GridView1.Rows[0].Cells.Clear();//清空
GridView1.Rows[0].Cells.Add(new TableCell());//加新格
GridView1.Rows[0].Cells[0].Text = "无相关记录";//text
GridView1.Rows[0].Cells[0].ColumnSpan = columnNum;
}
else
{
GridView1.DataSource = myds;
GridView1.DataBind();
}
myds.Dispose();
myda.Dispose();
myconn.Close();
}
protected void mhFind_Button_Click(object sender, EventArgs e)
{
SqlConnection myconn = common.myconn();
myconn.Open();
string cmdstr = "select *from Tproduct where Fname like '%"+Find_TextBox.Text.Trim()+"%'";
SqlDataAdapter myda = new SqlDataAdapter(cmdstr, myconn);
DataSet myds = new DataSet();
myda.Fill(myds);
GridView1.DataSource = myds;
GridView1.DataBind();
myds.Dispose();
myda.Dispose();
myconn.Close();
}
效果:
![9125154-3980a4d67def14e8.png](https://i-blog.csdnimg.cn/blog_migrate/f973e9bb8cd4a25ac8cad3a148b4e5c1.webp?x-image-process=image/format,png)
精确查找
![9125154-bc60a73692eead05.png](https://i-blog.csdnimg.cn/blog_migrate/645e3694f8ec9dae5194a1eddb19eb02.webp?x-image-process=image/format,png)
模糊查找