image Insert & Select

Insert:

string strImageFileExt;
string imageName;

if (fuProductImage.FileName.ToString().Trim() != "")
{
strImageFileExt = fuProductImage.FileName.Substring(fuProductImage.FileName.LastIndexOf(".") + 1).ToLower();
imageName = ddlMovieName.SelectedItem.Text.Trim()+ "." + strImageFileExt;;
Save(imageName);

}



string strtest = "insert into Abirami_MovieDetails values('" + ddlMovieName.SelectedItem.Text.Trim() + "','" + imageName + "')";

SqlCommand sqlCmd = new SqlCommand(strtest, conn);
sqlCmd.ExecuteNonQuery();


Save Image Function:
private void Save(string imageName)
{

if (imageName != null && imageName.Trim() != "")
{
System.Drawing.Image objImage = null;
if (fuProductImage.HasFile)
{
objImage = System.Drawing.Image.FromStream(fuProductImage.FileContent);
System.Drawing.Image objSmallImage = objImage.GetThumbnailImage(161, 206, objTIA, IntPtr.Zero);
objSmallImage.Save(Server.MapPath("../AbiramiImages/" + imageName.Trim().Replace(" ", " ").Replace(" ", "_").Replace(":", "_").Replace("(", "_").Replace(")", "_")));
}
}
}



select:

SqlCommand cmd = new SqlCommand("select V_MovieProducer,V_MovieDirector,V_MovieMusicDirector,V_MovieWriter,V_MovieCast,V_MovieImage,V_Synopsis,V_StartDate,V_EndDate from Abirami_MovieDetails where V_MovieName='" + ddlMovieName.SelectedItem.Text.Trim() + "'", conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
txtProducer.Text = dr["V_MovieProducer"].ToString();
strImage = "../AbiramiImages/" + dr["V_MovieImage"].ToString().Trim();
if (System.IO.File.Exists(Server.MapPath(strImage)) == true)
{
Image1.ImageUrl = strImage;
}
else
{
Image1.ImageUrl = "../MovieImages/Image_Not_Available.gif";
}
}
dr.Close();

Stored Procedure code in DAL

public DataSet GetOnlineTicketsReport(DateTime dStartDate,DateTime dEndDate,string strScreenName, string strShowTime)
{

MySqlCommand cmd = new MySqlCommand("LMT_GetReport", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("?DD_StartDate", MySqlDbType.Datetime);
cmd.Parameters["?DD_StartDate"].Value = dStartDate;
cmd.Parameters.Add("?DD_EndDate ", MySqlDbType.Datetime);
cmd.Parameters["?DD_EndDate "].Value = dEndDate;
cmd.Parameters.Add("?VV_ScreenName ", MySqlDbType.VarChar, 50);
cmd.Parameters["?VV_ScreenName "].Value = strScreenName;
cmd.Parameters.Add("?VV_ShowTime ", MySqlDbType.VarChar, 50);
cmd.Parameters["?VV_ShowTime "].Value = strShowTime;
DataSet ds = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(ds);
return ds;
}

One Textbox assign Multible Button value

i have created 10 Buttons. when i click 5th button the textbox value must be in 5.
this code will help...
in Design part Button Event Click event give btnTickets_Click

Web Application:
protected void lnkShowDate_Click(object sender, EventArgs e)
{
string str = ((System.Web.UI.WebControls.LinkButton)(sender)).ToolTip;
}

Windows:
private void btnTickets_Click(object sender, EventArgs e)
{
txtTicket.Text = ((System.Windows.Forms.ButtonBase)(sender)).Text;
}

Get Multi row in Single Coloum using C#.Net Code

Get Value from Dataset and assign to Gridview:

public string strTransactionNumber1 = "";
public string strTransactionNumber2 = "";
public string strSeatNo = "";

DataTable dtData = new DataTable();
dtData.Columns.Add("TransactionNumber");
dtData.Columns.Add("UserName");
dtData.Columns.Add("TransactionDate");
dtData.Columns.Add("ShowDate");
dtData.Columns.Add("ShowTime");
dtData.Columns.Add("MovieName");
dtData.Columns.Add("SeatName");
dtData.Columns.Add("TotalTickets");
dtData.Columns.Add("Per Seat Price");
dtData.Columns.Add("Limata Amount");
dtData.Columns.Add("Client Amount");
dtData.Columns.Add("Name");
dtData.Columns.Add("MobileNumber");
dtData.Columns.Add("EmailID");
dtData.Columns.Add("IDCardType");
dtData.Columns.Add("IDCardInfo");
DataTable dt = new DataTable();

DataSet dsReport = new DataSet();
OtherBLL objReport = new OtherBLL();
dsReport = objReport.GetTheatreReport(Convert.ToDateTime(txtStartDate.Text), Convert.ToDateTime(txtEndDate.Text), 146, ddlShowTime.SelectedItem.Text);
if (dsReport.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsReport.Tables[0].Rows.Count; i++)
{

dt = dsReport.Tables[0];
DataRow dr;
dr = dtData.NewRow();
if (i > 0)
strTransactionNumber1 = dt.Rows[i - 1]["V_TransactionNumber"].ToString();
strTransactionNumber2 = dt.Rows[i]["V_TransactionNumber"].ToString();

if (strTransactionNumber1 == strTransactionNumber2)
{
strSeatNo += "," + dt.Rows[i]["V_SeatName"].ToString();
}
else
{
strSeatNo = dt.Rows[i]["V_SeatName"].ToString();
}
dtData.Rows.Add(dt.Rows[i]["V_TransactionNumber"].ToString(), dt.Rows[i]["V_UserName"].ToString(), dt.Rows[i]["D_TransactionDate"].ToString(), dt.Rows[i]["D_ShowDate"].ToString(), dt.Rows[i]["V_ShowTime"].ToString(), dt.Rows[i]["V_MovieName"].ToString(), strSeatNo, dt.Rows[i]["N_TotalTickets"].ToString(), dt.Rows[i]["C_SeatPrice"].ToString(), dt.Rows[i]["LimataAmount"].ToString(), dt.Rows[i]["F_TotalPrice"].ToString(), dt.Rows[i]["V_CardHolderName"].ToString(), dt.Rows[i]["V_MobileNumber"].ToString(), dt.Rows[i]["V_EmailID"].ToString(), dt.Rows[i]["V_IDCardType"].ToString(), dt.Rows[i]["V_IDCardInfo"].ToString());
// dtData.Rows.Add(dt.Rows[i]["V_TransactionNumber"].ToString(), dt.Rows[i]["D_ShowDate"].ToString(), dt.Rows[i]["V_ShowTime"].ToString(), dt.Rows[i]["V_MovieName"].ToString(), dt.Rows[i]["N_TotalTickets"].ToString(), dt.Rows[i]["F_TotalPrice"].ToString(), strSeatNo);
if (i > 0)
{
if (dt.Rows[i - 1]["V_TransactionNumber"].ToString() == dt.Rows[i]["V_TransactionNumber"].ToString())
{
int iCount = dtData.Rows.Count - 1;
dtData.Rows[iCount - 1].Delete();
}
}
dtData.AcceptChanges();
}

grdReport.Visible = true;
lblMessage.Visible = false;
Session["DataSet"] = dtData;
grdReport.DataSource = dtData;
grdReport.DataBind();

Get Multi row in Single Coloum using SQL Query & Check 2 value in same colume

Get Multi Row Seat Name in single colum:

(select (select TD.V_SeatName as col1 FROM Transaction T where TD.N_TransactionID=T.N_TransactionID
for xml raw, elements, type).query('for $col1 in (row/col1) return concat($col1, ",")')) as SeatName


Check 2 value in same colume:(Get Status for (1 or 4))

select * from testtable where N_Status in(1,4)

Negative to Postive Value

converting Negative Value to Pstive value in C#:
string s = "-123.45";
s = Math.Abs(Convert.ToDouble(s)).ToString();
//Output=123.45

Date Time Format

Convert Date Time:
string=strStartDate;
strStartDate = Convert.ToDateTime(strStartDate).ToString("yyyy/MM/dd");