isnull check

By -

isnull(production_name,'')

Comments

Post a Comment

Popular posts from this blog

How to change value on selection of dropdown list control in datagid

By -
How to change value on selection of dropdown list control in datagrid. // drpmodify is dropdown list. protected void drpmodify_SelectedIndexChanged(object sender, EventArgs e) { DropDownList list = (DropDownList)sender; TableCell cell = list.Parent as TableCell; DataGridItem item = cell.Parent as DataGridItem; DropDownList index = (DropDownList)item.Cells[10].FindControl("drpmodify"); DropDownList drpmodify12 = null; drpmodify12 = (DropDownList)index; TextBox txtupdate = null; txtupdate = (TextBox)item.Cells[11].FindControl("TxtUpdate"); if ((drpmodify12.SelectedValue == "N") || (drpmodify12.SelectedValue == "M") || (drpmodify12.SelectedValue == "NE") || (drpmodify12.SelectedValue == "DU") || (drpmodify12.SelectedValue == "D") || (drpmodify12.SelectedValue == "I")) { txtupdate.Text = ""...
Read more
By -
Solution to error - String was not recognized as a valid DateTime.                                                       or  Conversion from string "29/04/2020" to type 'Date' is not valid Save date in SQL DB Dim requestdate As String             requestdate = DateTime.ParseExact(txtfrom.Text, "dd/MM/yyyy", Nothing).ToString("yyyy/MM/dd") comm.Parameters.AddWithValue("@req_date", requestdate)
Read more

Dictionary used for key value pair

By -
       var dicQuarter = new Dictionary<List<Dealer>, int >();         dicQuarter.Add("-Select-", 0);             dicQuarter.Add("Quarter-I", 1);             dicQuarter.Add("Quarter-II", 2);             dicQuarter.Add("Quarter-III", 3);             dicQuarter.Add("Quarter-IV", 4);                                     ddlAuthorisedFullName.DataSource = dicQuarter;                     ddlAuthorisedFullName.DataTextField = "FULLNAME";    ...
Read more