hjran abdpor
چهارشنبه 03 خرداد 1391, 19:51 عصر
با سلام .
دو سه سال پیش یه وب سایت نوشتیم که اکثر کدهای مربوط به دیتابیسش به صورت SqlCommand نوشته شده !! حالا میخام ابم کدها را به SP تبدیل کنم و از DataSet استفاده کنم !!! بعضی از کدها را تبدیل کردم به Sp حالا اگه کسی بتونه کمکمون کنه ممنون میشم !!!! نمونه اش را میزام مثلا اینو تبدیل کنیم به SP.
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("SELECT BookCode, RqstCount FROM Request WHERE (RqstCode = " +
e.CommandArgument.ToString() + ")", connect);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter("SELECT Scale FROM BookScale WHERE (BookCode = " +
dt.Rows[0]["BookCode"].ToString() + ")", connect);
da1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
if (Convert.ToInt32(dt1.Rows[0]["Scale"]) > Convert.ToInt32(dt.Rows[0]["RqstCount"]))
{
try
{
SqlCommand Cmd = new SqlCommand("UPDATE Request SET Status = 1 WHERE (RqstCode = " +
e.CommandArgument.ToString() + ")", connect);
connect.Open();
Cmd.ExecuteNonQuery();
connect.Close();
GridView1.DataBind();
}
catch (Exception ex)
{
Session.Add("Msg_", "در روند ثبت اطلاعات اشکال زیر به وجود آمده است: <br>" + ex.Message);
Response.Redirect("~/ShowMessage.aspx");
}
}
else
{
Label14.Text = "تعداد درخواست بیشتر از تعداد موجود می باشد. نمیتوانید آن را ارسال کنید";
}
یا این :
if (FirstRadioButton.Checked == true)
SqlDataSource1.SelectCommand = "SELECT BookInfo.BookCode, BookInfo.Name, BookInfo.Writers, " +
"BookInfo.Translator, BookInfo.Price, BookScale.Scale, TempSubjects.Subject, (SELECT Pic_ FROM " +
"BookPic WHERE (BookCode = BookInfo.BookCode)) AS Pic_ FROM BookInfo INNER JOIN BookScale ON " +
"BookInfo.BookCode = BookScale.BookCode INNER JOIN TempSubjects ON BookInfo.SubjectCode = " +
"TempSubjects.SubjectCode WHERE (BookInfo.Name LIKE '" + BookNameTextBox.Text + "%')";
else
{
if (InRadioButton.Checked == true)
SqlDataSource1.SelectCommand = "SELECT BookInfo.BookCode, BookInfo.Name, BookInfo.Writers, " +
"BookInfo.Translator, BookInfo.Price, BookScale.Scale, TempSubjects.Subject, (SELECT Pic_ FROM " +
"BookPic WHERE (BookCode = BookInfo.BookCode)) AS Pic_ FROM BookInfo INNER JOIN BookScale ON " +
"BookInfo.BookCode = BookScale.BookCode INNER JOIN TempSubjects ON BookInfo.SubjectCode = " +
"TempSubjects.SubjectCode WHERE (BookInfo.Name LIKE '%" + BookNameTextBox.Text + "%')";
else
{
if (NoneRadioButton.Checked == true)
SqlDataSource1.SelectCommand = "SELECT BookInfo.BookCode, BookInfo.Name, BookInfo.Writers, " +
"BookInfo.Translator, BookInfo.Price, BookScale.Scale, TempSubjects.Subject, (SELECT Pic_ FROM " +
"BookPic WHERE (BookCode = BookInfo.BookCode)) AS Pic_ FROM BookInfo INNER JOIN BookScale ON " +
"BookInfo.BookCode = BookScale.BookCode INNER JOIN TempSubjects ON BookInfo.SubjectCode = " +
"TempSubjects.SubjectCode WHERE (BookInfo.Name LIKE '" + BookNameTextBox.Text + "')";
}
}
ممنونم .
دو سه سال پیش یه وب سایت نوشتیم که اکثر کدهای مربوط به دیتابیسش به صورت SqlCommand نوشته شده !! حالا میخام ابم کدها را به SP تبدیل کنم و از DataSet استفاده کنم !!! بعضی از کدها را تبدیل کردم به Sp حالا اگه کسی بتونه کمکمون کنه ممنون میشم !!!! نمونه اش را میزام مثلا اینو تبدیل کنیم به SP.
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("SELECT BookCode, RqstCount FROM Request WHERE (RqstCode = " +
e.CommandArgument.ToString() + ")", connect);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter("SELECT Scale FROM BookScale WHERE (BookCode = " +
dt.Rows[0]["BookCode"].ToString() + ")", connect);
da1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
if (Convert.ToInt32(dt1.Rows[0]["Scale"]) > Convert.ToInt32(dt.Rows[0]["RqstCount"]))
{
try
{
SqlCommand Cmd = new SqlCommand("UPDATE Request SET Status = 1 WHERE (RqstCode = " +
e.CommandArgument.ToString() + ")", connect);
connect.Open();
Cmd.ExecuteNonQuery();
connect.Close();
GridView1.DataBind();
}
catch (Exception ex)
{
Session.Add("Msg_", "در روند ثبت اطلاعات اشکال زیر به وجود آمده است: <br>" + ex.Message);
Response.Redirect("~/ShowMessage.aspx");
}
}
else
{
Label14.Text = "تعداد درخواست بیشتر از تعداد موجود می باشد. نمیتوانید آن را ارسال کنید";
}
یا این :
if (FirstRadioButton.Checked == true)
SqlDataSource1.SelectCommand = "SELECT BookInfo.BookCode, BookInfo.Name, BookInfo.Writers, " +
"BookInfo.Translator, BookInfo.Price, BookScale.Scale, TempSubjects.Subject, (SELECT Pic_ FROM " +
"BookPic WHERE (BookCode = BookInfo.BookCode)) AS Pic_ FROM BookInfo INNER JOIN BookScale ON " +
"BookInfo.BookCode = BookScale.BookCode INNER JOIN TempSubjects ON BookInfo.SubjectCode = " +
"TempSubjects.SubjectCode WHERE (BookInfo.Name LIKE '" + BookNameTextBox.Text + "%')";
else
{
if (InRadioButton.Checked == true)
SqlDataSource1.SelectCommand = "SELECT BookInfo.BookCode, BookInfo.Name, BookInfo.Writers, " +
"BookInfo.Translator, BookInfo.Price, BookScale.Scale, TempSubjects.Subject, (SELECT Pic_ FROM " +
"BookPic WHERE (BookCode = BookInfo.BookCode)) AS Pic_ FROM BookInfo INNER JOIN BookScale ON " +
"BookInfo.BookCode = BookScale.BookCode INNER JOIN TempSubjects ON BookInfo.SubjectCode = " +
"TempSubjects.SubjectCode WHERE (BookInfo.Name LIKE '%" + BookNameTextBox.Text + "%')";
else
{
if (NoneRadioButton.Checked == true)
SqlDataSource1.SelectCommand = "SELECT BookInfo.BookCode, BookInfo.Name, BookInfo.Writers, " +
"BookInfo.Translator, BookInfo.Price, BookScale.Scale, TempSubjects.Subject, (SELECT Pic_ FROM " +
"BookPic WHERE (BookCode = BookInfo.BookCode)) AS Pic_ FROM BookInfo INNER JOIN BookScale ON " +
"BookInfo.BookCode = BookScale.BookCode INNER JOIN TempSubjects ON BookInfo.SubjectCode = " +
"TempSubjects.SubjectCode WHERE (BookInfo.Name LIKE '" + BookNameTextBox.Text + "')";
}
}
ممنونم .