ببینید اتصال به بانکم مشکل داره
من وقتی تست اتصال رو می زنم open رو نمیده
هیچ خطایی هم نمیده
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Configuration;
namespace sodor
{
public partial class Form1 : Form
{
private string connectionstring = ConfigurationManager.ConnectionStrings["connect"].ConnectionString;
private OleDbConnection dbconnection = new OleDbConnection();
public Form1()
{
InitializeComponent();
dbconnection.ConnectionString = connectionstring;
}
public DataSet select()
{
try
{
string qurey = "SELECT prsnli as [شماره پرسنلی],nam as[??? ],family as[??? ???????? ],amozeshkah as[??? ???????? ],dorh as[????],tedad as[????? ],onwan1 as[????? 1],marge1 as[???? 1],data1 as [????? 1],onwan2 as[????? 2],marge2 as [???? 2],data2 as[????? 2],onwan3 as [?????3],marge3 as[???? 3],data3 as[????? 3],onwan4 as [????? 4],marge4 as[???? 4],data4 as [????? 4],onwan5 as[????? 5],marge5 as [???? 5],data5 as[????? 5],FORM tab1 ;";
OleDbCommand com = new OleDbCommand(qurey, this.dbconnection);
OleDbDataAdapter adapter = new OleDbDataAdapter(com);
DataSet result = new DataSet();
adapter.Fill(result);
return result;
}
catch (Exception)
{
MessageBox.Show("??? ");
return null;
}
finally
{
this.dbconnection.Close();
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.dbconnection.Open();
MessageBox.Show(this.dbconnection.State.ToString());
this.dbconnection.Close();
// this.dataGridView1.DataSource = select();
}
}
}
تست اتصالش جواب نمیده
توسط
kuuzzmm
(176 امتیاز)
●1 ●9 ●28