Comments by bjay tiamsic (Top 78 by date)

I have updated the question. Please inform if you need anything more. Thank you!

Updated.

I have done this technique before, I am just looking for more strategic approach. Thank you anyway. I will apply this for the meantime.

It works perfectly! Thank you so much!

Hi. Thanks for this and I am currently trying to use your suggestion. However, when I replaced 'ref' with 'out', the 'return dt;' line prompts error saying "The out parameter 'ExceptionMsg' must be assigned to before control leaves the current method"

Thank you for your answer! I really appreciate your help!

Hey! It worked!
But what does eq(0) mean? And how does that jQuery code define that the label is in a datalist?

Hi. Thanks for the reply.

How does your code define that the label is inside the datalist?

Isn't it that the dots indicate to move one folder out? I tried your suggestion but it game me this error
System.InvalidOperationException: Failed to map the path '/Reports/MyReport.rpt'.

Hi. I am still working locally. I tried debugging in my application server and other computers and I got the same error.

Yeah. It is included in my project.

This uses codes, is it possible to set it up using crystal report interface?

your solution worked but the popup blocker has to be turned off. I will be needing a solution that does not need to consider browser issues because I know popup blocker cannot be bypassed.

This worked but have to allow popup. If user is not knowledgeable about that, this approach is not acceptable, are there any other ways?

Exactly. Is that possible?

So it is a CssClass? What style should I consider?

Your codes

No. Just put there the ID of the control that you bind the YES/NO field.

Sorry. Here it is. The first link is the my current outcome.
https://www.dropbox.com/s/eq19zfuq6iystov/Capture.JPG?dl=0

And this one is the desired interface.

https://www.dropbox.com/s/ujqaufu7gn8hz2u/CorrectDesign.JPG?dl=0

in the //send email comment,
type there your code in sending email.

Do you have if (!Page.IsPostBack) in your page load?

isn't it complicated and wil cause more loop since it has to go through every row every time i check for the value?

Yes sir. After I bind it to the gridview, i will get the total

But why does it return different connectionstring when I put breakpoint?

Thanks for the comment. But it seems like it is not.
As you can see in SUPPLYConStr is Datasource=server31/... (this is a test server)

But when I put breakpoint in Default.aspx ConnectionString.SupplyConnectionString, it returns DataSource=[IPAddress]...which is the live server.

Here's the screen cap
https://www.dropbox.com/s/o3xyub97kywmzq4/Untitled.png?dl=0

Yes I understand. but in my page, it refers to the connectionstring "SupplyConnectionString" which is not in web.config

Noted on this sir! Thank you so much!

This is also perfect!

Hi. Thank you for this. It works, but not when status of any of the records is set to true. I tried the old record to set the status to true and it did not get that value. It is supposed to be display, in other words, STATUS field is my priority in checking and if no record has STATS=TRUE then the latest record based on effectivitydatefrom (EmploymentHistory table) and EffectivityDate (EmployeeSalaryHistory) should be considered

It works actually but I'm getting the undesired result. For example,
the where condition turned to be
"where EmploymentHistory.Status = 'TRUE' AND tblEmployeeMainInfo.LevelCode LIKE 'FACULTY%' OR tblEmployeeMainInfo.LevelCode LIKE 'STAFF%'"

it returns all records with faculty and staff value in LEVELCODE field, however it also returns those STATUS=FALSE

But when I enclosed the condition with OR with a parenthesis, it gets accurate result "where EmploymentHistory.Status = 'TRUE' AND (tblEmployeeMainInfo.LevelCode LIKE 'FACULTY%' OR tblEmployeeMainInfo.LevelCode LIKE 'STAFF%')"

It works actually but I'm getting the undesired result. For example,
the where condition turned to be
"where EmploymentHistory.Status = 'TRUE' AND tblEmployeeMainInfo.LevelCode LIKE 'FACULTY%' OR tblEmployeeMainInfo.LevelCode LIKE 'STAFF%'"

it returns all records with faculty and staff value in LEVELCODE field, however it also returns those STATUS=FALSE

But when I enclosed the condition with OR with a parenthesis, it gets accurate result "where EmploymentHistory.Status = 'TRUE' AND (tblEmployeeMainInfo.LevelCode LIKE 'FACULTY%' OR tblEmployeeMainInfo.LevelCode LIKE 'STAFF%')"

Heres the finalQuery

Select EmpPersonalInfo.EmployeeNo,EmpPersonalInfo.LastName,EmpPersonalInfo.FirstName,tblEmployeeMainInfo.BranchCode FROM EmploymentInfo LEFT JOIN EmpPersonalInfo ON EmploymentInfo.EmployeeNo=EmpPersonalInfo.EmployeeNo LEFT JOIN tblEmployeeMainInfo ON EmpPersonalInfo.EmployeeNo = tblEmployeeMainInfo.EmployeeCode LEFT JOIN EmploymentHistory ON EmpPersonalInfo.EmployeeNo = EmploymentHistory.EmployeeNo LEFT JOIN viewEmployeeApprover ON EmpPersonalInfo.EmployeeNo = viewEmployeeApprover.EmployeeNo LEFT JOIN EmployeePayType ON EmpPersonalInfo.EmployeeNo = EmployeePayType.EmployeeCode where EmploymentHistory.Status = 'TRUE' AND tblEmployeeMainInfo.LevelCode LIKE 'FACULTY%' order by EmpPersonalInfo.LastName,EmpPersonalInfo.FirstName,tblEmployeeMainInfo.BranchCode,EmpPersonalInfo.EmployeeNo

Oops sorry I posted the wrong code. Will update

It did not work when I used parameters in query. I get an error "An expression of non-boolean type specified in a context where a condition is expected, near 'order'". I updated my question by the way

Noted sir! Thank you!

Thank you so much, how about List with 2 parameters? I just searched it, I can use this to broaden may vocabulary in programming. THank you for responding and giving idea. I really appreciate it

Sorry I'm really not familiar with this but I think it's getting clearer

What to you call this by the way? List with 2 values like a 2D Array?

I got this class.

public class OrderFields
{
public int OrderNo { get; set; }
public string OrderField { get; set; }

public OrderFields(int num, string field)
{
OrderNo = num;
OrderField = field;
}
}

I added items to it using the codes in my main post and I want to get the values of OrderField

Yes I am aware of that.
this ain't working
lnkLoanType.Font.Bold = true;
row.BackColor= System.Drawing.ColorTranslator.FromHtml("#A1DCF2");


and having this code, which gives the style using c#, I don't see the significance of <SelectedRowStyle> property of GridView in design code.

What I totally want is to apply the <SelectedRowStyle>, instead of styling it using c# in code behind

This is perfect!! Thanks! Please help other programmers also.

Thank you. I have thought of this logic, I am just wondering if there are built-in functionality. Anyway, thank you so much for this. Will try!

Hi Thanks for your comments.
Yes I will be needing this frequently, I will be using this as a text file needed to submit to a government branch for government contribution, the file needs to follow this requirement.
So I dont think it matters to convert the string back to number

I would also like to ask for a link where I can start reading and commence with the syntax for OpenXML thanks

Yes I guess but I did not use OpenXML as I would need to go through the beginner's side on this. I stick to my codes but I followed your comment to use CSS.

Got it! Thanks! I never thought that gridview styles are only applicatble pages.

Can you also provide a link where I can customize it like the margin, font family, size etc.? I will be exporting a data from datatable and the word document will have a header and footer (Word Header and Footer is not necessary, just a custom header/footer would do)

Wait. So i tried it locally and I needed to install it in order to get the .dll
Do I also need to install it to the server (may affect other application)? or possible to just copy and paste the .dll from my local project to the server project folder?

I am trying to render the gridview. I tried this

gvExportDoc.DataSource = dtInput;
gvExportDoc.DataBind();

string title = "OthersAbroad_BankReport";
Response.Clear();
Response.Buffer = true;


Response.AddHeader("content-disposition", "attachment;filename=" + title + ".doc");
Response.Charset = "";
Response.ContentType = "application/ms-word";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
gvExport.RenderControl(hw);

string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();


It works, however, my GridView font is Arial but Times New Roman is being defaulted when the word file was produced and I couldn't customize the margin.

yep. this rounds UP, but I need it to ROUND DOWN to nearest 15. I got the answer on this link http://www.codeproject.com/Articles/24582/Rounding-a-DateTime-object-to-a-defined-number-of provided by
Garth J Lancaster

Thank you so much! This is the best solution!

Here. But it rounds up

DateTime(((dt.Ticks + d.Ticks - 1) / d.Ticks) * d.Ticks);

Yes sir. I am 100% that it is correct because other classes work when called in CssClass property of the control

but this one works in HeaderFooterMainTemplateEmp.css

.doc-item { background:url(../Images/GridViewButtons/doc.png) no-repeat 0px; width:16px; height:16px; display:inline-block; }

Thank you! I got the result. However, I wanted to make the first column as ColumnNames and their respective value as row

Hi. Thank you for your response. I forgot to put the language im using. I am doing this in SQL Server 2008

Thanks for the response. But i tried this I dont get the desired output.. Flexi-housing not being pulled up only other AdjustmentCodes

I should only get 2 record: FLEXI-HOUSING and R-TRAVEL ALLOW but I'm getting 4

These ones(AdjustmentCode) sir. They are not being read as distinct because of lettercase

AdjustmentCode|Adjustment (description)
FLEXI-HOUSING | flexi- housing
Flexi-housing | flexi- housing
R-TRAVEL ALLOW | travel allowance
R-Travel Allow | travel allowance

Sorry I didnt know that i did not hit the update button. I've been editing it this morning.

Im not sending out a blank email, it just goes blank when a record is NULL.

Hi. The link answer did not work for me. I'm in the network currently. When I type in server47/mywebsitedir/webmainpage/login.aspx

it gives my computer's ip address.

but when I used server47's public ipaddress
(example)
201.12.258.1/mywebsitedir/webmainpage/login.aspx
it gives the server47's ip address (192.1.2.3), not my computer's ip address.

Yes. In SQL please

I think im off with this one. I don't use caml query. Sorry for that.

This is applicable if you want to display DayName (i.e. Monday, Tuesday, etc) in you grid. But if you want to display only the number representation of the day make it
select Id,Title,'"+columnday+"' as Day_ from Timesheet
Text='<%# Bind("Day_") %>

use the word "AS" to name your column

select Id,Title,DATENAME(DW,CAST('"+columnday+"' AS INT)) as Day_ from Timesheet
Text='<%# Bind("Day_") %>

Please send your query and how you bind you gridview.. if possible send all the codes you use for binding. we can't help yu if no codes are being shown

Can you explain it clearer?

Please post your code so we can see and understand where the error is coming from