这是form1代码namespace AddData
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
//实例化数据库连接对象
//SqlConnection conn = new SqlConnection("Server=(local);User Id=sa;Pwd=81200823;DataBase=db_11");
//定义添加数据的SQL语句
AddData.datalink strconn = new AddData.datalink();
//我想在这里打开数据库连接输入strconn.没有open选项。
}
}这是模块里面的数据库连接字符串namespace AddData
{
public class datalink
{ SqlConnection conn = new SqlConnection("Server=(local);User Id=sa;Pwd=81200823;DataBase=db_11");
}
}
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
//实例化数据库连接对象
//SqlConnection conn = new SqlConnection("Server=(local);User Id=sa;Pwd=81200823;DataBase=db_11");
//定义添加数据的SQL语句
AddData.datalink strconn = new AddData.datalink();
//我想在这里打开数据库连接输入strconn.没有open选项。
}
}这是模块里面的数据库连接字符串namespace AddData
{
public class datalink
{ SqlConnection conn = new SqlConnection("Server=(local);User Id=sa;Pwd=81200823;DataBase=db_11");
}
}
namespace AddData
{
public class datalink
{
public void conn()
{
string conn;
conn = SqlConnection("Server=(local);User Id=sa;Pwd=81200823;DataBase=db_11");
} }
}我申明了个方法,可还是不行呀。
datalink.conn
using System;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace OpenConn
{
public partial class Form1 : Form
{
SqlConnection conn;
public Form1()
{
InitializeComponent();
} private void Form1_Load(object sender, EventArgs e)
{ } private void button1_Click(object sender, EventArgs e)
{
conn = OpenConn.ConnLink(); OpenConn.CloseConn(conn);
}
}
public class OpenConn
{
public static SqlConnection ConnLink()
{
//string conn;
try
{
SqlConnection conn = new SqlConnection("Server=(local);User Id=sa;Pwd=81200823;DataBase=db_11");
conn.Open();
return conn;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return null;
}
}
public static void CloseConn(SqlConnection cn)
{
cn.Close();
} }
}
public static void CloseConn(SqlConnection cn)
{
cn.Close();
}
低价源码出售了,全是自己开发的代码,希望和大家一起交流,集百家之所长,希望能对大家有所帮助。
网店地址:http://shop36675020.taobao.com