Comments by PrakashCs.net (Top 28 by date)

i.e not reflecting updated value in @Html.TextBoxFor(m => m.OCustomer.FirstName)

this ObjOrder.OCustomer.FirstName = " New customer name"; this name is not reflecting on my saveorder view.

use this solution

if you want to update same row which is filter use following code

if (_dtrecomendationData.Select("Priority = 2").Length > 0)
{
DataRow[] dr = _dtrecomendationData.Select("Priority = 2");

foreach (DataRow dre in dr)
{
dre["Priority"] = "--";
}

_dtrecomendationData.AcceptChanges();
}

if you want to update same row which is filter use following code

if (_dtrecomendationData.Select("Priority = 2").Length > 0)
{
DataRow[] dr = _dtrecomendationData.Select("Priority = 2");

foreach (DataRow dre in dr)
{
dre["Priority"] = "--";
}

_dtrecomendationData.AcceptChanges();
}

check this link might be help you link[^]

print or select your @SQL statement and run it in query analyser you will able to trace what exact error is in @SQL statement.

Why do you want to call function in select query ?

instead of that use table join Glass_Lens and Glass_Lense_cat

from t1 in Glass_Lens
join t2 in Glass_Lense_cat on t1.catid equals t2.catid
select new { t1.col1, t2.col2}

answer 3 in link i.e.
When you use a const string, the compiler embeds the string's value at compile-time.
Therefore, if you use a const value in a different assembly, then update the original assembly and change the value, the other assembly won't see the change until you re-compile it.

A static readonly string is a normal field that gets looked up at runtime. Therefore, if the field's value is changed in a different assembly, the changes will be seen as soon as the assembly is loaded, without recompiling.

This also means that a static readonly string can use non-constant members, such as Environment.UserName or DateTime.Now.ToString(). A const string can only be initialized using other constants or literals.
Also, a static readonly string can be set in a static constructor; a const string can only be initialized inline.

Note that a static string can be modified; you should use static readonly instead.

yes use DateTime? MyDate=null; correct answer Suvabrata Roy

static variable value can be change if it is static readonly variable in the constructor .

recreate instance of that class .

could you please share ClientAuthorizetables and TemperingTableTemplates

is it giving some error or returning empty result set?

try this now it should work

public void add(Student std)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into dab (name) values (@name)", con);
//cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.Add("@name", SqlDbType.NVarChar);
cmd.Parameters["@name"].Size = 4000;
cmd.Parameters["@name"].Value = name;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
}

what error it is giving now, give me exact error message.

what exactly error it is giving? from where you call javascript methods?

best way to do this bind you datatable to gridview and export it

please refer this link
http://www.codeproject.com/Answers/788069/How-Can-I-Save-Data-In-A-Datatable-To-Excel-In-Asp#answer1

Do you need table structure or exactly what?

Could please post error ?

welcome friend.

correct Wes Aday,it is already mention in this link
http://www.codeproject.com/Questions/787658/Help-Excel-process-keep-runnung-export-excel-with

Please read query string before and check whether it returns valid value.

on what basis you are going to map LocationIn and location LocationOut ?