C# 数据库 网络即时通信问题

using System;

using SystemCollectionsGeneric;

using SystemLinq;

using SystemText;

using SystemDataSqlClient;

using SystemData;

using SystemDataOleDb;

using SystemConfiguration;

namespace Makings

{

class DAL

{

//DataConnection dc = new DataConnection();

private static string strconn = ConfigurationManagerConnectionStrings["MakingsInfo"]ConnectionString;

/// <summary>

/// 显示所有物料的进出情况

/// </summary>

/// <returns></returns>

public static DataTable GetShowBomPass()

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("Pro_ShowBomPass", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaFill(dt);

return dt;

}

public static DataTable GetPassAndOut(string PN, DateTime StartTime, DateTime EndTime)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("CHK_PN", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@PN", PN);

sdaSelectCommandParametersAddWithValue("@StartTime", StartTime);

sdaSelectCommandParametersAddWithValue("@EndTime", EndTime);

sdaFill(dt);

return dt;

}

public static bool GetAdd(string PN, string Category, string Supplier, Single Price, double quantity, bool Operate, string Odd_Number, string Indent_Number, DateTime Time,string Remark)

{

bool result = false;

SqlConnection conn = new SqlConnection(strconn);

SqlCommand com = new SqlCommand("ADD_passAndout", conn);

comCommandType = CommandTypeStoredProcedure;

comParametersAddWithValue("@PN", PN);

comParametersAddWithValue("@Category", Category);

comParametersAddWithValue("@Supplier", Supplier);

comParametersAddWithValue("@Price", Price);

comParametersAddWithValue("@quantity", quantity);

comParametersAddWithValue("@Operate ", Operate);

comParametersAddWithValue("@Odd_Number", Odd_Number);

comParametersAddWithValue("@Indent_Number", Indent_Number);

comParametersAddWithValue("@Time", Time);

comParametersAddWithValue("@Remark",Remark);

connOpen();

result = comExecuteNonQuery() > 0;

connClose();

return result;

}

/// <summary>

/// 显示进出表所有信息

/// </summary>

/// <returns></returns>

public static DataTable GetShowPassOutAll()

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("Pro_pass_out", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaFill(dt);

return dt;

}

/// 获取最后一条记录

/// </summary>

/// <returns></returns>

public static DataTable GetAll()

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("CHK_All", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaFill(dt);

return dt;

}

/// <summary>

/// 根据用户名和密码登录

/// </summary>

/// <param name="Name">用户名</param>

/// <param name="password">密码</param>

/// <returns></returns>

public static bool Login(string Name, string password)

{

bool result = false;

SqlConnection conn = new SqlConnection(strconn);

SqlCommand cmd = new SqlCommand("Login", conn);

cmdCommandType = CommandTypeStoredProcedure;

cmdParametersAddWithValue("@Name", Name);

cmdParametersAddWithValue("@pwd", password);

//cmdParametersAddWithValue("@Ustate", Ustate);

connOpen();

SqlDataReader dr = cmdExecuteReader();

result = drRead();

connClose();

return result;

}

/// <summary>

/// 添加用户信息

/// </summary>

/// <param name="Name">用户名</param>

/// <param name="pwd">密码</param>

/// <returns></returns>

public static bool GetAddUser(string Name, string pwd)

{

bool result = false;

SqlConnection conn = new SqlConnection(strconn);

SqlCommand cmd = new SqlCommand("Add_userInfo", conn);

cmdCommandType = CommandTypeStoredProcedure;

cmdParametersAddWithValue("@Name", Name);

cmdParametersAddWithValue("@pwd", pwd);

connOpen();

result = cmdExecuteNonQuery() > 0;

connClose();

return result;

}

/// <summary>

/// 修改用户密码

/// </summary>

/// <param name="pwd">密码</param>

/// <returns></returns>

public static bool GetUpdateUser(string Name, string pwd)

{

bool result = false;

SqlConnection conn = new SqlConnection(strconn);

SqlCommand cmd = new SqlCommand("Update_PWD", conn);

cmdCommandType = CommandTypeStoredProcedure;

cmdParametersAddWithValue("@Name", Name);

cmdParametersAddWithValue("@pwd", pwd);

connOpen();

result = cmdExecuteNonQuery() > 0;

connClose();

return result;

}

/// <summary>

/// 根据姓名删除用户信息

/// </summary>

/// <param name="Name">用户名</param>

/// <returns></returns>

public static bool GetDeleteUser(string Name)

{

bool result = false;

SqlConnection conn = new SqlConnection(strconn);

SqlCommand cmd = new SqlCommand("Delete_User", conn);

cmdCommandType = CommandTypeStoredProcedure;

cmdParametersAddWithValue("@Name", Name);

connOpen();

result = cmdExecuteNonQuery() > 0;

connClose();

return result;

}

/// <summary>

/// 获取所有的用户信息

/// </summary>

/// <returns></returns>

public static DataTable GetAllUserInfo()

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("All_User", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaFill(dt);

return dt;

}

/// <summary>

/// 显示材料信息

/// </summary>

/// <returns></returns>

public static DataTable GetShowBomAll()

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("Pro_ShowBomAll", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaFill(dt);

return dt;

}

/// <summary>

/// 根据PN查询所有的材料信息

/// </summary>

/// <param name="PN"></param>

/// <returns></returns>

public static DataTable GetAllBOM(string PN)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("select_BOM", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@PN", PN);

sdaFill(dt);

return dt;

}

/// <summary>

/// 添加材料信息

/// </summary>

/// <param name="PN"></param>

/// <param name="Name">材料名称</param>

/// <param name="Standard">规格</param>

/// <param name="Unit">单位</param>

/// <param name="Category">类别</param>

/// <returns></returns>

public static bool GetAddBOM(string PN, string Name, string Standard, string Unit, string Category)

{

bool result = false;

SqlConnection conn = new SqlConnection(strconn);

SqlCommand smd = new SqlCommand("ADD_BOM", conn);

smdCommandType = CommandTypeStoredProcedure;

smdParametersAddWithValue("@PN", PN);

smdParametersAddWithValue("@Name", Name);

smdParametersAddWithValue("@Standard", Standard);

smdParametersAddWithValue("@Unit", Unit);

smdParametersAddWithValue("@Category", Category);

connOpen();

result = smdExecuteNonQuery() > 0;

connClose();

return result;

}

/// <summary>

/// 根据PN删除指定的材料

/// </summary>

/// <param name="PN"></param>

/// <returns></returns>

public static bool GetDeleteBOM(string PN)

{

bool result = false;

SqlConnection conn = new SqlConnection(strconn);

SqlCommand smd = new SqlCommand("delete_BOM", conn);

smdCommandType = CommandTypeStoredProcedure;

smdParametersAddWithValue("@PN", PN);

connOpen();

result = (smdExecuteNonQuery() > 0);

connClose();

return result;

}

/// <summary>

/// 获取所有的物料信息

/// </summary>

/// <returns></returns>

public static DataTable GetAllBOM()

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("AllBOM", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaFill(dt);

return dt;

}

/// <summary>

/// 根据PN删除指定数据

/// </summary>

/// <param name="PN"></param>

/// <returns></returns>

public static bool GetDeletePassAndOut(int id)

{

bool result = false;

SqlConnection conn = new SqlConnection(strconn);

SqlCommand smd = new SqlCommand("Delete_passAndout", conn);

smdCommandType = CommandTypeStoredProcedure;

smdParametersAddWithValue("@ID", id);

connOpen();

result = smdExecuteNonQuery() > 0;

connClose();

return result;

}

public static DataTable GetCHK_PassAndOut(string PN)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("CHK_PassAndout", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@PN", PN);

sdaFill(dt);

return dt;

}

public static DataTable GetCHK_Data(string PN)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("CHK_data", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@PN ", PN);

sdaFill(dt);

return dt;

}

public static DataTable GetCHK_data2(string PN)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("CHK_data2", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@PN", PN);

sdaFill(dt);

return dt;

}

public static DataTable GetRetrieveAllData(string PN, DateTime StartTime, DateTime EndTime)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("RetrieveAllData", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@PN", PN);

sdaSelectCommandParametersAddWithValue("@StartTime", StartTime);

sdaSelectCommandParametersAddWithValue("@EndTime", EndTime);

sdaFill(dt);

return dt;

}

#region 查询进出表所有记录

/// <summary>

/// 获取进出表所有 *** 作记录

/// </summary>

/// <param name="PN">原料PN码</param>

/// <returns>把表格返回</returns>

public static DataTable GetSelectPassOutAll(string PN)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("Pro_SelectAll", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@PN", PN);

sdaFill(dt);

return dt;

}

#endregion

public static DataTable GetCategoryData(string Categroy, DateTime StartTime, DateTime EndTime)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("Pro_SelectAllCategroy", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@Category", Categroy);

sdaSelectCommandParametersAddWithValue("@StartTime", StartTime);

sdaSelectCommandParametersAddWithValue("@EndTime", EndTime);

sdaFill(dt);

return dt;

}

/// <summary>

/// 进出汇总

/// </summary>

/// <param name="ST">开始时间</param>

/// <param name="ET">结束时间</param>

/// <returns></returns>

public static DataTable GetBomCount(DateTime ST, DateTime ET)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("Pro_BomCount", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@StartTime", ST);

sdaSelectCommandParametersAddWithValue("@EndTime", ET);

sdaFill(dt);

return dt;

}

/// <summary>

/// 添加电池信息

/// </summary>

/// <returns></returns>

public static bool GetAddProduction(string JobID, string PN, string BomName, string BomCategroy, string Standard, string Dosage, string BomUnit, string Purpose, string Actor, string UR, DateTime Time)

{

bool result = false;

SqlConnection conn = new SqlConnection(strconn);

SqlCommand cmd = new SqlCommand("Pro_ADDProduction", conn);

cmdCommandType = CommandTypeStoredProcedure;

cmdParametersAddWithValue("@JobID", JobID);

cmdParametersAddWithValue("@PN", PN);

cmdParametersAddWithValue("@Bomname", BomName);

cmdParametersAddWithValue("@BomCategroy", BomCategroy);

cmdParametersAddWithValue("@Standard", Standard);

cmdParametersAddWithValue("@Dosage", Dosage);

cmdParametersAddWithValue("@BomUnit", BomUnit);

cmdParametersAddWithValue("@Purpose ", Purpose);

cmdParametersAddWithValue("@Actor ", Actor);

cmdParametersAddWithValue("@UR", UR);

cmdParametersAddWithValue("@Time", Time);

connOpen();

result = cmdExecuteNonQuery() > 0;

connDispose();

connClose();

return result;

}

/// <summary>

/// 显示所有产品信息

/// </summary>

/// <returns></returns>

public static DataTable GetShowProduction()

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("Pro_ShowProduction", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaFill(dt);

return dt;

}

/// <summary>

/// 根据工单号查询电芯信息

/// </summary>

/// <param name="JID">工单号</param>

/// <returns></returns>

public static DataTable GetSelectProduct(string JID)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("Pro_CHK", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@JobID", JID);

sdaFill(dt);

return dt;

}

/// <summary>

/// 显示添加的数据

/// </summary>

/// <returns></returns>

public static DataTable GetAllProduction()

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("Pro_AllProduction", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaFill(dt);

return dt;

}

/// <summary>

/// 删除产品信息

/// </summary>

/// <param name="ID">删除条件ID</param>

/// <returns></returns>

public static bool GetDelProduction(int ID)

{

bool result = false;

SqlConnection conn = new SqlConnection(strconn);

SqlCommand cmd = new SqlCommand("Pro_DelProd", conn);

cmdCommandType = CommandTypeStoredProcedure;

cmdParametersAddWithValue("@ProductID", ID);

connOpen();

result = cmdExecuteNonQuery() > 0;

connDispose();

connClose();

return result;

}

public static DataTable GetSelectProductionJobID(string JobID, string PN, DateTime StartTime, DateTime EndTime)

{

DataTable dt = new DataTable();

SqlConnection conn = new SqlConnection(strconn);

SqlDataAdapter sda = new SqlDataAdapter("Pro_SelectProductionJobID", conn);

sdaSelectCommandCommandType = CommandTypeStoredProcedure;

sdaSelectCommandParametersAddWithValue("@JobID", JobID);

sdaSelectCommandParametersAddWithValue("@PN", PN);

sdaSelectCommandParametersAddWithValue("@StartTime", StartTime);

sdaSelectCommandParametersAddWithValue("@EndTime", EndTime);

sdaFill(dt);

return dt;

}

}

}

在你安装SQL Server的时候，必须指定安装一个或者多个网络链接库。这个组件用于在SQL Server和客户端软件之间建立一个网络连接。虽然在SQL Server上可以安装并运行多于一个的网络链接库，但是在同一时刻客户端只能装载并激活一个网络链接库文件。为了使客户端能够通过网络和SQL Server进行通信，SQL Server和客户端双方必须运行相同的网络链接库，否则，它们之间就不能进行通信。

缺省情况下，会为客户端工具安装命名管道网络链接库。假设SQL Server上也使用命名管道，那么客户端不加任何改变就可以和SQL Server进行通信了。如果为了某种原因，你决定不在SQL Server上运行命名管道，那么你就必须为客户端选择一个和SQL Server上运行的网络链接库相匹配的网络链接库。

如果你使用的客户端 *** 作系统并不是Windows NT或者Windows 95/98，就有可能必须要选择另外的网络链接库，例如Banyan VINES或者NWLink IPX/SPX网络链接库。如果是这种情况，你同时必须保证SQL Server上运行着同样的网络链接库。

选择正确的网络链接库对很多数据库管理员来讲可能都比较困惑。选择的标准在于客户端如何通过网络与SQL Server通信，这个问题比较复杂，因为有很多种在客户端和服务器端应用程序之间进行通信的方法。选择正确的网络链接库的最重要的一点在于要向开发你的SQL Server 客户端/服务器应用程序的人咨询。很有可能开发程序的人编写的应用是在特定的网络链接库上运行的。如果是这种情况，就应该使用运行该应用所需要的网络链接库。

4 高级配置

很少需要用到客户端配置工具中的高级配置表单。在这个表单中，你可以设置客户端软件在试图与SQL Server进行连接时向SQL Server发送特定的配置字符串。

不就是 把 串口接收的数据存入 数据库

或者 把 数据库 的 数据 通过串口发送 出去？

其实 ，就是 编程问题

推荐看书

Visual C++_Turbo C串口通信编程实践

Visual_Basic与_RS-232_串行通信控制

以上就是关于C# 数据库 网络即时通信问题全部的内容，包括:C# 数据库 网络即时通信问题、怎样使客户端与数据库进行连接 比如我做一个在windows下运行的客户端，或者做一个网页客户端，、如何建立串口与数据库的通信等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！