Comments by Korathu 2 (Top 43 by date)

set locked true..But still didn't work..

Excel 2010...Haven't started...Knows how to import...

I want to pass null to string variable in my sql query where condtn(Eg: WHERE ISNULL('"+S+"',a.ds)=a.ds) to return all records if null and data set if any code behind in c#

I want to pass column name from c# code behind and sort as per the column name....My SP as follows:
SELECT a.AssetId, a.SerialNo, a.ServiceTag, a.CostCenterId, a.AssetStatusId, a.AssetConditionId, a.Description, a.AssetEntryDate, a.RefId, a.RefModule, a.LoginId,
a.StoreStockId, a.AssetNo, a.BarCode, a.AssetPict, a.Notes, i.ItemName, m.Model, it.ItemType, c.CategoryName, b.BrandName, ac.AssetCondition, cc.CostCenter,
CASE WHEN taissue.RefId = 0 THEN 'Not Assigned' WHEN taissue.RefModule = 'D' THEN
(SELECT Department
FROM TblDepartment
WHERE DepartmentId = taissue.RefId) ELSE
(SELECT PersonName
FROM TblPerson
WHERE PersonId = taissue.RefId) END AS [user], ast.AssetStatus, s.PurchaseRate, s.POInfo, s.WarrantyDate, v.VendorName, sm.PurDate, sm.PONo
FROM TblAsset AS a INNER JOIN
TblStoreStock AS ss ON a.StoreStockId = ss.StoreStockId INNER JOIN
TblStock AS s ON s.StockId = ss.StockId INNER JOIN
TblStoreEntryMaster AS sm ON sm.PurchaseId = s.PurchaseId INNER JOIN
TblItem AS i ON s.ItemId = i.ItemId INNER JOIN
TblModel AS m ON m.ModelId = i.ModelId INNER JOIN
TblIemType AS it ON m.ItemTypeId = it.ItemTypeId INNER JOIN
TblCategory AS c ON it.CategoryId = c.CategoryId INNER JOIN
TblBrand AS b ON b.BrandId = m.BrandId INNER JOIN
TblVendor AS v ON s.VendorId = v.VendorId INNER JOIN
TblAssetCondition AS ac ON ac.AssetConditionId = a.AssetConditionId left JOIN
TblAssetStatus AS ast ON ast.AssetStatusId = a.AssetStatusId INNER JOIN
TblCostCenter AS cc ON a.CostCenterId = cc.CostCenterId

LEFT join TblAssetIssueDet tbissue on tbissue.AssetId=a.AssetId
left join TblAssetIssueMst taissue on taissue.IssueId=tbissue.IssueId
left join TblDepartment d on d.DepartmentId=taissue.RefId
where

isnull(null,c.CategoryId) = c.CategoryId and
isnull(null, b.BrandId) = b.BrandId and
isnull(null,ac.AssetConditionId) = ac.AssetConditionId and
isnull(null,d.DepartmentId) = d.DepartmentId
order by isnull(@sorder,0)

In my case how i can loop on executing a db schema file....How long i should set the thread to sleep...else if i set to 100 execution of schema won't be over by that time...

I got progress bar control for it..But how to work it while executing a schema db file insertion code behind...

as usual normal set up process....

Its getting removed from control pane; but not from program files automatically..Has to manualy try it...Please let me know whats the reason...

No it isn't..I tried to uninstall my app.exe from control panel..But it isn't getting removed from program files...So i have to remove from program files....I want to remove it from program files automatically when i uninstall from control panel..How to do so....

I tried to uninstall my app.exe from control panel..But it isn't getting removed from program files...So i have to remove from program files....I want to remove it from program files automatically when i uninstall from control panel..How to do so....

Its the exe of my project created and its not getting removed from program files on uninstalling...

Can you provide the code..I want to access network folder and upload to it..

Can you explain more in detail..Want to do so code behind or during deploment...

I want to set write permission code behind

I am creating an exe file and creating database after installing the setup..then i am writing the server details etc to a txt file with in c drive and converting into zs file..But file isn't getting created....Access denied permission shown....

Both xtrareport and cs page

None worked ...

add array indices one after other to string array under button click i mean..

Nothing worked...

can u make it more clear...

I don't want to use any third party dll....Also the framework must be 4.0....

from where i can refer system.io.compression.filesystem dll

I want to run multiple forms at the same time...

Tried..Didn't work..Please give correct answer..

DataTable dt = Common.dc.TblMaintenances.Where(a => a.ContractId == Id && a.IsScheduled == true || a.IsScheduled == false).OrderBy(a => a.ScheduledDate).Select(a => new { a.MaintenanceId,a.MaintenanceDate.ToString("dd/MM/yyyy"), a.MaintenancePerson, a.Remarks, a.ScheduledDate, a.IsScheduled, a.Cost }).getDataTable();
Tried but its error

Actualy i am not reposting intentionaly....I am getting 404 not found error while using aspxuploadprogressbar handler in devexpress...Its happpening due to url routing set in global.asax.Pls tell a way to resolve this....

Actualy on using aspxprogressbarhandler of aspxupload 404 not found(url not found issue shown...Its in the folder of my project..I am routing few pages outside the folder...So how to avoid such an issue...It happens onlyfor uploading via devexpress..

I am having only frommonth,fromyear,tomonth and toyear in dropdownlists...How to do if so..

Yes exactly under the onclick of checkbox javascript event..

That I got..I want to select top 2 jobtilte and all jobrefids in a single sql query...

I want to get @ formats in inserted binary files via sql query.....Please provide a solution at the earliest...

Its during bulk upload process where email ids of resumes if any are stored..So i am trying to convert doc files in to binary file and then via indexing find email address if any....

I tried all as said..But page isn't redirecting correctly

I want to access the listbox values server side..Javascript already done..

I tried the above..But unable to get the tag properly in my project..Either assembly error or unknown specified tag..
Under App_Code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Text;
using AjaxControlToolkit.HTMLEditor;
using AjaxControlToolkit.HTMLEditor.ToolbarButton;
namespace CustomControls
{
public class CustomEditor : Editor
{
protected override void FillTopToolbar()
{
TopToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.Bold());
TopToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.Italic());
}

protected override void FillBottomToolbar()
{
BottomToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.DesignMode());
BottomToolbar.Buttons.Add(new AjaxControlToolkit.HTMLEditor.ToolbarButton.PreviewMode());
}
}
}


Then under the aspx page of content page
<%@ Register Namespace="CustomControls" TagPrefix="HTMLEditor" Assembly="CustomControls"%>
<HTMLEditor:CustomEditor runat="server" Height="500px" Width="100%" ID="editor" AutoFocus="true" ></HTMLEditor:CustomEditor>
I am not getting the tag source code ....

I mean how to extract email ids from the word or pdf(resume) file)...I am able to extract..But if there are multiple email ids how can one get the exact candidate email id....Actualy i wish to insert only the candidate email id and filename from the resumes into database
during bulk upload...

Email Ids already extracted.But I wish to get the candidate email id alone from a resume..How can one get exactly that if there are multiple email ids in the resume ...