internal DataTable GetConformedResults(string spName, string fName, string lName) { DataTable dt = new DataTable(); SqlConnection con = new SqlConnection("Data Source=BUDDHIKA-PC\\SQLEXPRESS;Initial Catalog=VertualDoctor;Integrated Security=True"); con.Open(); SqlCommand SqlCmd = new SqlCommand(spName, con); SqlCmd.Parameters.Add("@vcFistName", DbType.String).Value = fName; SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.Add("@vcLastName", DbType.String).Value = lName; SqlCmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter DataAdp = new SqlDataAdapter(); DataAdp.SelectCommand = SqlCmd; DataSet result = new DataSet(); //Create a dataset DataAdp.Fill(result, "result"); //Fill the dataset dt = result.Tables["result"]; con.Close(); con.Dispose(); return dt; }
I could able to fix this with following steps: 1) Removed "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18" folder 2) Deleted registry key "HKLM\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Management Studio" 3) Installed SSMS
Comments