The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
string format = “MMMM/dd/yyyy”;
change to
string format = “M/d/yyyy”;
Index and length must refer to a location within the string. Parameter name: length
string fulltext2 = dr["FullText2"].ToString();
Line 282:
Line 283: fulltext2 = fulltext2.Substring(0, 6);
Line 284:
Line 285: if (fulltext2 != “
This application is currently offline. To enable the application, remove the app_offline.htm file from the application root directory.
Please delete app_offline.htm from solution explorer
PATINDEX examples MSSQL 2008
SELECT PATINDEX(‘%asd[a-z]%’,Heading)
FROM ITEMS
WHERE IID = 10002;
Datetime year in dropdown using c# asp.net
DateTime Past_Year = DateTime.Now;
Past_Year = Past_Year.AddYears(2);
intyear = Past_Year.Year;
for (int i = 1900; i <= intyear; i++)
{
DDL_Year.Items.Add(i.ToString());
}
MultiView in Asp.net
Code
protected void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
MultiView1.ActiveViewIndex = Convert.ToInt32(DropDownList1.SelectedValue);
}