お世話になります。
今C#を使用し、SQLserverに接続、DateTableにSQLクエリーを入れる処理の実装をしています。
しかし、DBにアクセスしようとすると、「Connection.servervesionは型System.InvalidOperationEいxceptionの例外をスローしました」となり、DBに接続できません。
どのようにコードを修正すれば、DBに接続し、DateTableにSQLクエリを格納出来ますでしょうか。
=============================
以下コードです。
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
namespace WebApplication4
{
public partial class Projects : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
} protected void Seach_Project(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(); SqlCommand command = new SqlCommand(); DataTable ds = new DataTable(); //接続文字列 connection.ConnectionString =@"Data Source=.\SQLEXPRESS;AttachDbFilename= C:\Users\user\Documents\Visual Studio 2010\Projects\WebApplication4 \WebApplication4\App_Data\SES_DB.mdf; Integrated Security=True;User Instance=True"; using (SqlDataAdapter adapter = new SqlDataAdapter()) { //connection内でConnection.servervesionは型System.InvalidOperationException 例外をスローしましたと例外がスローされ、DBにアクセスが出来ないです。 command.Connection = connection; string ProjectName = ""; string ProjectStart = ""; string ProjectStaion = ""; string ProjectPlyse = ""; string ProjectLowerLimit = ""; string ProjectUpperLimit = ""; string language01 = ""; string language02 = ""; string language03 = ""; string language04 = ""; if (Project_language01.Checked == true) { language01 = "PHP"; } if (Project_language02.Checked == true) { language02 = "Java"; } if (Project_language03.Checked == true) { language03 = "HTML/CSS"; } if (Project_language04.Checked == true) { language04 = "COBOL"; } string[] ProjectTable = new string[10]; ProjectTable[0] = Project_name.Text; ProjectTable[1] = Project_Start.Text; ProjectTable[2] = Project_Station.Text; ProjectTable[3] = Project_Plyse.Text; ProjectTable[4] = Project_Lower_Limit.Text; ProjectTable[5] = Project_Upper_Limit.Text; ProjectTable[6] = language01; ProjectTable[7] = language02; ProjectTable[8] = language03; ProjectTable[9] = language04; for (int i = 0; i < 1; ++i) { if (ProjectTable[0].Length != 0) { ProjectName = ProjectTable[0].ToString(); } else { ProjectName = "0"; } if (ProjectTable[1].Length != 0) { ProjectStart = ProjectTable[1].ToString(); } else { ProjectStart = "0"; } if (ProjectTable[2].Length != 0) { ProjectStaion = ProjectTable[2].ToString(); } else { ProjectStaion = "0"; } if (ProjectTable[3].Length != 0) { ProjectPlyse = ProjectTable[3].ToString(); } else { ProjectPlyse = "0"; } if (ProjectTable[4].Length != 0) { ProjectLowerLimit = ProjectTable[4].ToString(); } else { ProjectLowerLimit = "0"; } if (ProjectTable[5].Length != 0) { ProjectUpperLimit = ProjectTable[5].ToString(); } else { ProjectUpperLimit = "0"; } if (ProjectTable[6].Length != 0) { language01 = ProjectTable[6].ToString(); } else { language01 = "0"; } if (ProjectTable[7].Length != 0) { language02 = ProjectTable[7].ToString(); } else { language02 = "0"; } if (ProjectTable[8].Length != 0) { language03 = ProjectTable[8].ToString(); } else { language03 = "0"; } if (ProjectTable[9].Length != 0) { language04 = ProjectTable[9].ToString(); } else { language04 = "0"; } } command.CommandText = "SELECT * FROM Project_Table WHERE Project_name='" + ProjectName + "'" + "OR Project_Place='" + ProjectStaion + "'" + "OR Project_Start='" + ProjectStart + "'" + "OR Project_Playse='" + ProjectPlyse + "'" + "OR Project_Lwor_Limit='" + ProjectLowerLimit + "'" + "OR ProjecT_Max_Limiit='" + ProjectUpperLimit + "'" + "OR Project_language01='" + language01 + "'" + "OR Project_language02='" + language02 + "'" + "OR Project_language03='" + language03 + "'" + "OR Project_language04='" + language04 + "';"; adapter.SelectCommand = command; // SQLを実行し結果をdsの中に格納します。 adapter.Fill(ds); } } }
}
=================================================
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。