1. 实现linux mono Develop中调用windows 中的ql Server 2005
l linux 与 windows 在一个局域网的网段中
l windows 中安装 sql Server 2005
2. windows 中的设置
l sql sever 2005 northwin数据库
1.1 product结构
1.2 Categories 结构
2 如果本机的防火强开启，请关闭。如果防火墙开启，windows会阻止linux的访问
3. Linux中的设置
3.1 Ping windows 的IP ,确认linux 可访问windows
3.2 界面设计
3.2.1 数据与PropertyGrid绑定界面
3.2.2 数据与gridView绑定界面
3.3 代码
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WinMonoApp
{
public partial class frmWFBrowse : Form
{
SqlDataAdapter myDataAdapter = null;
//List<bindPropertyData> bindPropertyList = null;
string myConnectionString = null;
string sqlProduct = "SELECT * FROM [Northwind].[dbo].[Products] ";
string sqlCategory = "SELECT [CategoryID],[CategoryName],[Description] FROM [Northwind].[dbo].[Categories] ";
DataSet myCategory = new DataSet();
DataSet myProduct = new DataSet();
public frmWFBrowse()
{
InitializeComponent();
}
private void btnOK_Click(object sender, EventArgs e)
{
myConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["WinMonoApp.Properties.Settings.BPMDBConnectionString"].ConnectionString;
//MessageBox.Show(myConnectionString);
myDataAdapter = new SqlDataAdapter(sqlCategory, myConnectionString);
myDataAdapter.Fill(myCategory);
myDataAdapter.SelectCommand.CommandText = string.Format(sqlProduct );
myDataAdapter.Fill(myProduct);
//MessageBox.Show(myDs.Tables[0].Rows.Count.ToString());
this.FillTemplate();
}
private void FillTemplate()
{
try
{
if(myCategory.Tables.Count!=0)
{
this.lbTemplate.DisplayMember = "CategoryName";
this.lbTemplate.DataSource = myCategory.Tables[0];
}
}
catch(Exception myEx)
{
MessageBox.Show(myEx.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void lbTemplate_SelectedIndexChanged(object sender, EventArgs e)
{
var wfv = this.lbTemplate.SelectedItem as DataRowView ;
if (wfv != null)
{
this.llDeleteTemplate.Enabled = true;
this.pgTemplateV.SelectedObject = wfv;
DataRow[] myProductList=myProduct.Tables[0].Select(string.Format("CategoryID={0}",wfv.Row.ItemArray[0]));
this.pgTemplateInfo.SelectedObjects = myProductList;
DataTable myDataTable = myProductList[0].Table.Clone();
myDataTable.Rows.Clear();
foreach (var row in myProductList)
{
myDataTable.ImportRow(row );
}
this.dgvBindProperty.DataSource = myDataTable ;
}
}
private void frmWFBrowse_Load(object sender, EventArgs e)
{
this.llDeleteTemplate.Enabled = false;
}
private void llDeleteTemplate_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
}
}
}
3.4 App.config
<connectionStrings>
<add name="WinMonoApp.Properties.Settings.BPMDBConnectionString" connectionString="Data Source=10.168.14.131;Initial Catalog=Northwind;User ID=sa;Password=sqlsa" providerName="System.Data.SqlClient"/>
</connectionStrings>
3.5 运行效果
3.5.1 PropertyGrid绑定效果
3.5.2 PropertyGrid子项编辑
3.5.3 GridView绑定效果
