Comments by Salman622 (Top 80 by date)

no it would not happen
until you click the start process button again and if you click it again there would be a error i.e.
This BackgroundWorker is currently busy and cannot run multiple tasks concurrently
to prevent this your can apply a check in your start process click event

take a boolean variable at global level in form assign value true to it
and in your background worker do work event
apply a check like below
if(boolVariable)
{
boolVariable=false;
for(int i=0;i<100;i++)
{
longTask();
}
}

and in your RunWorkerComplete event just do that boolVariable to true
thats it

In this case you use a backgroung worker in c# to execute the function on button click.
and to stop it on button click you can stop the background worker thats it.

what happening in your case is
when first user logs in
your security Class stores the information of first user because the variables are static when the second user logs in the values changes as per the second user
and all the user logged in will use the the values of the user who login last.
so here you have to change your logic of storing the value of dept.
instead of storing the values in static variable you can store the values in session and your problem will be solve

Its Only a Logic how he can achieve that.
If any problem exists due to font,font-size,style etc he can sort it out by increasing or decreasing the number of character in the label

go to below link
http://www.openjs.com/scripts/events/keyboard_shortcuts/

Mr. sergey Alexandrovich actually you get it wrong

i mean to say before shutdown my service should stop but its not stopping and i want to achieved that.

in this case you can use barcode reader machine

i would suggest to use background worker here
for eg.
as you say you have a form A.
and i am adding to buttons to it.
say for eg. btn1 and btn2
when you click on btn1 it perform some task and wait for btn2 to be clicked

here what you can do is.
on btn1 click give the task to a background worker in while loop.
in while loop you can have if block like if(//boolean variable to check){//your logic}

and on btn2 click set a variable to true.
in this case what happen is your background code will run continously untill the condition meets and after performing a task you can stop the background worker.

you can query the data from db in the order you want.

Its a simple thing for example if you have multiple gridview on your web form
Like a dash board and all grid take some what time to bind its data.
so here you can use threading were all grid will simultaneously bind its data
and your application speeds up.

what is the dataType for WorkHour.EndTime and tblApp.EndDate
in sql

no there is no difference if you are inserting through literal values

but it would be usefull for bulk insertion for that query would like

INSERT INTO TableName1(AccountNo,Customer,ContactNo) select column1,column2,column3 FROM TableName WHERE
coalesce(column1,'')+coalesce(column2,'')+coalesce(column3,'') NOT In (Select distinct coalesce(AccountNo,'')+coalesce(Customer,'')+coalesce(ContactNo,'') From TableName1);

this query would insert only record which are not in TableName1

no idea...

below is the code for read data
string SourceConstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + OtherPath.Text + ";Extended Properties= 'Excel 12.0;'";
OleDbConnection con1 = new OleDbConnection(SourceConstr);
con1.Open();
string query = "Select * from [" + OtherSheet.Text + "$]";
DataTable exceltable = new DataTable();
OleDbDataAdapter data = new OleDbDataAdapter(query, con1);
data.Fill(exceltable);
con1.Close();

Its Reading Data PRoper but the problem comes at date column
as i have given example above

which architecture u r using....

in hobby table Create one column Namely UserRegistrationID assign foreign key to it and in User Details Use ID as Primary key

when fetching data for particular user Use join
structure will be fine and Later there will be no permutations and Combinations

paste your GetDt() function

verify the version of Crystal report viewer in your tool box by hovering mouse on crystalreportviewer tool

and then do cross checking of version in your GAC (Global assembly cache).

Open Rdlc report
then click on view tab at last there is a option for report data

Its Simple so you can use like this


with Cte
as
(
select HULLNO from EngineMaster_Duplicates where HULLNO Like HULLNO+'%'
Group By HULLNO
Having (Select Count(HULLNO) as cn from EngineMaster_Duplicates where HULLNO Like HULLNO+'%')>1
)
Select * from EngineMaster_Duplicates s,cte c where s.HULLNO =c.HULLNO order by s.HULLNO

You want each and Every record which is duplicate

with Cte
as
(
select HULLNO from EngineMaster_Duplicates where HULLNO Like 'SN2066%'
Group By HULLNO
Having (Select Count(HULLNO) as cn from EngineMaster_Duplicates where HULLNO Like 'SN2066%')>1
)
Select * from EngineMaster_Duplicates s,cte c where s.HULLNO =c.HULLNO


this will work definately try and let me know

Instead of * you can use Column Names of EngineMaster_Duplicates

Like
s.Seq,s.ENGINENO,s.HULLNO

with Cte
as
(
select HULLNO from EngineMaster_Duplicates
Group By HULLNO
Having Count(SUBSTRING(HULLNO,1,6))>1
)
Select * from EngineMaster_Duplicates s,cte c where s.HULLNO =c.HULLNO and s.VoucherNo Like 'SN2066%'


try this

what value is there in hullno
is it SN2065 or (SN2065#1 ....)
and what is the primary key of table EngineMaster_Duplicates

Problem is with 64-bits machine else application is working fine on 32-bits machine

If that link is not useful to you
then i can Provide you the Code snippet for button to print your ssrs report

numeric fields do not take value with single code
if you know the value is null
then simple pass 0 or Null
eg.
insert into ItemMaster
( ITEM_CODE,
ITEM_NAME,
DRAWING_NO,
WEIGHT_CAST,
WEIGHT_FINISH,
CROSSING_COUNT,
catID )
values('a','a','',0,0,'','')

else you can use

insert into ItemMaster
( ITEM_CODE,
ITEM_NAME,
DRAWING_NO,
WEIGHT_CAST,
WEIGHT_FINISH,
CROSSING_COUNT,
catID )
values('a','a','',Null,Null,'','')

Like and Unlike is a asp control or html control

Your MySqlConnection object is not getting a Connection string
thats why its returning that object refrence not set

for checking
while you are debugging
as your break point comes to conn.Open();
check the connection string in that object

Hope then you will come to know where is the problem

try debugging the value returning is not of type integer

Thanks

Thanks Arun

can you provide the basic syntax for catching error if occur during excution and performing rollback or commit

welcome

you have not get it right what i have said you

browser on which your application is running on that browser javascript may be disable so please check the setting of that browser

check the string in lbl_carID it might contain alphabets or symbols

have you given a reference of jquery txt file to use $(Document).ready

Replace "YourKey" with the Session Key You want to Clear.

below karthik has given a nice solution
to use class

do you want to retrive that value on the same page or some other page

to close javascript aleart() Method pop up there is already a default button namely ok to close that pop up

is txtSalary is asp control

can you explain the flow of this page so that i can give you a solution

Pop Up is Appearing Bro...

is there any condition when it should return a Row index

for your kind information solution 1 is wrong according to the question asked
You should have a look to that also.

just read the Question above and see the solution below.
and plz don't interfere.

do you have eyes

can you explain little bit more about your problem

wait a minute i have code i have to search

Is it web or window application

can you provide the complete .cs page

write your code in if block not in else part

write your code in if block not in else part

when the page is post back it lost all its data
and the requirement of R_Coder is label text which is lost because of post back
if he write his code in !ispostback block the label text will not lost
and it will only load once after that it will not enter that block
here this is the solution........

plz provide your code

what is the actual text is it absent or null

use item template to genrate drop down list for a column in grid

thank you but i have done by generating connection dynamically in code bihine aspx

but thing you have to do is give the size of any thing in your website in percentage instead of pixel

can you tell me how will you maintain your property

what you want to do......?

what is the length of word you have inserted in varchar(20) field

are you using sqlDataSource

if you solve this plz provide me the solution actully i am also in same situation

drag and drop the columns from datatset in detail section of crystalreport then it will able to display all the record of table as well as header

i'll recommand you to use else if ladder
because when your code of first if block get false it returns else part
then second return false it give else part and so on .....

thats why its displaying error msg thrice instead of one...

what is Error in your code please specify

if possible avoid reloading data

GETDATA is for auto complete and its working

and item_name_text_Change is for some other purpose that's why is have not put that code the requirement for auto complete on typing in text box is all depend on service method getdata

check out the sql query in your function

Put where condition after from clauses

you have given the label text as Label


what you want to do

weather u want to display as eg:- Label3.... 3 is your dropdown selected text and Label is Label2 text