nava_2012
چهارشنبه 09 فروردین 1391, 20:35 عصر
private void ExecuteSProBotton_Click(object sender, EventArgs e)
{
try
{
SqlConnection Database1 = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\Database1.mdf;Integrated Security=True;User Instance=True");
System.Text.StringBuilder result = new System.Text.StringBuilder();
SqlCommand ExecuteSQLCommand = new SqlCommand();
ExecuteSQLCommand.Connection = Database1;
ExecuteSQLCommand.CommandType = CommandType.StoredProcedure;
ExecuteSQLCommand.CommandText = "sp_Execute";
ExecuteSQLCommand.Connection.Open();
SqlDataReader reader = ExecuteSQLCommand.ExecuteReader();
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
result.Append(reader[i].ToString() + "\t");
}
result.Append(Environment.NewLine);
}
reader.Close();
ExecuteSQLCommand.Connection.Close();
ResultTextBox.Text = result.ToString();
}
catch
{
}
اشکال کجاست که اطلاعات جدول نمایش داده نمی شود؟
stored bprosedure:
ALTER PROCEDURE dbo.sp_Execute
AS
SELECT Id,fname,lname FROM Students
RETURN
{
try
{
SqlConnection Database1 = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\Database1.mdf;Integrated Security=True;User Instance=True");
System.Text.StringBuilder result = new System.Text.StringBuilder();
SqlCommand ExecuteSQLCommand = new SqlCommand();
ExecuteSQLCommand.Connection = Database1;
ExecuteSQLCommand.CommandType = CommandType.StoredProcedure;
ExecuteSQLCommand.CommandText = "sp_Execute";
ExecuteSQLCommand.Connection.Open();
SqlDataReader reader = ExecuteSQLCommand.ExecuteReader();
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
result.Append(reader[i].ToString() + "\t");
}
result.Append(Environment.NewLine);
}
reader.Close();
ExecuteSQLCommand.Connection.Close();
ResultTextBox.Text = result.ToString();
}
catch
{
}
اشکال کجاست که اطلاعات جدول نمایش داده نمی شود؟
stored bprosedure:
ALTER PROCEDURE dbo.sp_Execute
AS
SELECT Id,fname,lname FROM Students
RETURN