Comments by Amalraj Ramesh (Top 71 by date)

NO, i have this check box in popup, I want set focus when popup show..

Use scope_identity function

so there is a no way to convert that docx file in landscape mode??? With out using open xml.

is it possible to change landscape mode??

Thanks dude.. its working

pls verify my code

its working..

void m1(int parm1)
{
int intcount=MethodBase.GetCurrentMethod().GetParameters().Count();
}

Thanks arun.. i got some to implement this idea...

i dont have any idea..

Method

its working fine with open office document, Only problem is while open that doc in open office writer

yes

If you check checkbox immidiatly wants to insert DB???

Can u give me some sample data for role table

Thats fine.. U have to add new unique id for every role for example Admin=1,Supervisor=2 and map to userid

/^([a-zA-Z0-9_.-&])+@([a-zA-Z0-9_.-])+\.([a-zA-Z])+([a-zA-Z])+$/;

Are you insert the updated datetime in db??

if you bind the combo box properly
selected value defiantly will work
For better solution post your code logic

I want to update the LogoutTime in Db while im closed the browser via close button is it possible??

working??

open VS and start coding...

happy coding...:P

Give your table data.. and expected output??

Ms Sql Server ???

post your code for best solution

1394011615 = what date??

Verify this link

https://stackoverflow.com/questions/15742716/how-to-get-column-values-in-one-comma-separated-value

change the div id like btnPrint
or
$("#print").css("visibility", "visible");

I think its not possible.. :P

Try this
SELECT TM_UserID
, FullName
, (CONVERT(VARCHAR(11),AttendanceDate,106) +','+ CONVERT(VARCHAR(11),DATEADD(day, 1, AttendanceDate),106)) AS AbsenteeDate

FROM
@GetAbsenteeDate
ORDER BY
FullName

You want nextdate with comma seperation im i right???

I can't understand.

give the exception details???

Post your code..

post your table data also for better solution

i can't understand clearly about your problem..

it throw any error or not??

use mouseleftdwon event

private void Button_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
// Your code
}

see below

you already done it..

DataView dv = table2.DefaultView;
dv.Sort = "NEW1 ASC";
DataTable sortedDT = dv.ToTable();

What is the problem here..?

check dbo.FakturaDB_Faktura is exist or not in FakturaDB

need more info about error in which line did u get this error...

replace this

private static DataTable CompareTwoDataTable(DataTable table1, DataTable table2)
{
DataTable table3 = new DataTable();
DataTable dt = new DataTable();
DataRow dr = null;

for (int i = 0; i < table1.Rows.Count; i++)
{
string col = table1.Rows[i]["Par Name"].ToString();
if (table2.Columns.Contains(col))
{
if (!table3.Columns.Contains(col))
{
table3.Columns.Add(col, typeof(string));
}

for (int j = 0; j < table2.Rows.Count; j++)
{
if (table3.Rows.Count != table2.Rows.Count)
{
dr = table3.NewRow();
table3.Rows.Add(dr);
}
table3.Rows[j][col] = table2.Rows[j][col].ToString();
}
}
}

for (int loop = 0; loop < table3.Columns.Count; loop++)
{
DataView dataview = table3.DefaultView;
dataview.Sort = table3.Columns[loop].ColumnName;
dt = dataview.ToTable();

}

return dt;//Error Not in the current context how to return the sorted table in this case dt
}

for (int loop = 0; loop < ft.Columns.Count; loop++)
{
DataView dataview = ft.DefaultView;
dataview.Sort = ft.Columns[loop].ColumnName;
DataTable dt = dataview .ToTable();
}

dt.DefaultView.Sort = "ColumnName ASC/DESC";

DataView dataview = ft.DefaultView;
dataview.Sort = ft.Columns[0].ColumnName;
DataTable dt = dataview .ToTable();

Use templetefiled and do that

add like this

<add assembly="Microsoft.Office.Interop.Word, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C">

make sure that your web config that version no is same

use like this

protected void btnTestFromDataTable_Click(object sender, EventArgs e)
{
DataSet ds = SampleData();
var wb = new XLWorkbook();
for (int intSheetCount = 0; intSheetCount < ds.Tables.Count; intSheetCount++)
{
var dataTable = ds.Tables[intSheetCount];
var ws = wb.AddWorksheet(dataTable);
}
wb.SaveAs(@"C:\Users\amalraj.a\Documents\Visual Studio 2010\Projects\ClosedXMLSample\XLFiles\UsingDataTable.xlsx");
}

Use like this

DataView dataview = dtright.DefaultView;
dataview.Sort = dtright.Columns[0].ColumnName;
DataTable dt = dataview.ToTable();

I think Request.QueryString["DIST_ID"].Tostring() is null

give your connection string..

give the server name another pc IP address

hey im happy to helpe you

string subject = "Hai UserName <br/> Thanks .... constaract your mail body";

You can use HTML tag to constact the email subject.

Happy coding..!

U don't want save files in db you just save the files in application temp folder and save the file name only in db

try this ajax control if any issue let me know

http://www.asp.net/ajaxlibrary/ajaxcontroltoolkitsamplesite/ajaxfileupload/ajaxfileupload.aspx

In management studio right click on table name and click on view dependencies
It will show the dependencies tables and sp

Have refer this BranchID as foreign key reference

Use data type like date

Which format stored in server in the format like yyyy-MM-dd

You can do this from c# code using timer control

first you have to check the query string has value or not
if(Request.QueryString["DIST_ID"].Tostring()!=null)

Ok, But i want to get Click event in aspx.cs page.

Thank for your reply,
I am not getting any errors or Exception

Button btn = (Button)myControl.FindControl("imgbtnAdd");
//btn is not null the value came for that button
btn.Click += new EventHandler(this.SrchButton_Click);
//
public void SrchButton_Click(object sender, EventArgs e)
{
mpeSearchPopup.Show();
}