Comments by Schatak - CodeProject

Schatak 10-Oct-23 14:31pm View

what is this?

Schatak 2-Nov-22 5:48am View

any luck with this? I am facing the same issue.

Schatak 15-Mar-17 7:57am View

Thanks, i understand.

Schatak 15-Mar-17 4:46am View

Thanks for your reply.
without dynamic query its fine for me. No issues there. But with dynamic query it's a problem
Due to some reason i am making dynamic query, i will try to avoid it . Let's see

Schatak 9-Nov-16 23:49pm View

how to display on date from it without converting it into string..? this is what my concern
thanks

Schatak 2-Aug-16 3:30am View

Please share what you already tried, may be there is some mistake in your code.

Schatak 9-Jan-16 6:00am View

From Internet

Schatak 21-Oct-15 4:14am View

+5

Schatak 11-Sep-15 7:29am View

Depend upon what is actual need.

Schatak 11-Sep-15 7:25am View

where is the error? and what is your issue?

Schatak 11-Sep-15 7:22am View

Yes you can do it by this query
INSERT INTO sales(accnum, scriptname, remainingshares) select accnum,scriptname,(sharesbought-sharesold) remainingshares from transac

Schatak 11-Sep-15 6:34am View

+5

Schatak 11-Sep-15 6:29am View

first try to learn its ASP.NET and Developer :)

Schatak 11-Sep-15 4:28am View

What you have tried? Did you try to google it? i tired, and find so many examples. pick any of then try and if you stuck please post here.
Thanks

Schatak 11-Sep-15 4:27am View

Agree. !

Schatak 11-Sep-15 4:24am View

you can see into chrome console that what is not rendering, i think you are using bootstap here, so without runat if its working then probably your ids are not rendering properly, see console for this.

Schatak 11-Sep-15 3:59am View

If its an Identity column and auto increment , i do not thing Jump issue will be there until you delete some records.

Schatak 11-Sep-15 2:10am View

If i understand you want records for only those employees having same name in your query?

Schatak 11-Sep-15 1:58am View

You can not make group by on one column while selecting more than one column in Select statement so your query will not work.

Schatak 10-Sep-15 6:05am View

Split function can be anything i just described the solution. you can your own split function, it does not make any difference. :)

Schatak 9-Sep-15 6:25am View

what is the issue?

Schatak 9-Sep-15 2:55am View

you can use Hidden field for this.

Schatak 9-Sep-15 1:48am View

how about you try to search on google first for solution?

Schatak 8-Sep-15 3:14am View

I tried to delete... but was not able to delete either.

Schatak 8-Sep-15 0:56am View

http://thomas-barthelemy.github.io/2015/05/01/visual-studio-vshub/

Schatak 5-Sep-15 1:06am View

You should google it... There are many examples and explanations available on the internet.

Schatak 5-Sep-15 1:02am View

What is your question?

Schatak 4-Sep-15 4:27am View

Your question is unclear, are you trying to search in SQL IDE or though code?
if through your code then what is the issue?

Schatak 4-Sep-15 4:19am View

But why?

Schatak 4-Sep-15 4:10am View

Can you post your table or data, because procedure is fine, probably your table have no data.

Schatak 4-Sep-15 4:04am View

Do your homework by your own, if you stuck using the code, then post here.

Schatak 4-Sep-15 3:54am View

then what is your problem? where you are stuck ?

Schatak 4-Sep-15 3:50am View

You better find the solution for your real problem, StringBuilder in JS is not your problem. if "they" are saying to build one, then you are surely miss interpret what is actual issue.
Please confirm first.

Schatak 4-Sep-15 3:10am View

then from where did you find Left and Right cursor term?

Schatak 3-Sep-15 4:37am View

i do understand the risk of it. but if there are such functions by asp.net which allow us to call as per our need, then its not bad to use it.
Yes it is advisable not to use such approaches in avoidable circumstances.

Schatak 3-Sep-15 2:59am View

Exactly

Schatak 3-Sep-15 1:17am View

then what is the issue? are you not getting the value?

Schatak 3-Sep-15 1:07am View

You means after calling ClearControls() function from Javascript, you need to set txtChallanNo text box's value to "New"?

Schatak 2-Sep-15 0:37am View

Nice :)

Schatak 2-Sep-15 0:34am View

Your Welcome :) Accept the solution or mark it solved. So that other knows that it was solved.

Schatak 1-Sep-15 2:37am View

your question is not clear.. can you elaborate more?

Schatak 1-Sep-15 2:24am View

But why you want so? i means is there any kind of requirement that only one user can see that page at a time ?

Schatak 1-Sep-15 2:16am View

Exactly

Schatak 27-Aug-15 3:38am View

Great, thanks for down vote. My mistake

Schatak 27-Aug-15 1:28am View

why do not you code behind of the button event to show and hide.

Schatak 27-Aug-15 0:59am View

More than one button clicks or more than buttons to open ModalPopup?

Schatak 26-Aug-15 9:44am View

what error you are getting?

Schatak 26-Aug-15 9:38am View

What do you mean by "Solve this task"? Is anybody here is to SOLVE your tasks? No, all are here to help you if you stuck somewhere in your code.
So try your self first and then if you find issues with your code OR you are not able to get the directions Google it first, I am sure you will get 100s of solutions, and if those solutions still not work for you then post your error with proper code and ask for HELP.
Thanks

Schatak 26-Aug-15 9:32am View

What is the error? are you able to get data into AwardList from your database?

Schatak 26-Aug-15 8:58am View

are you able to get data from database to Reader?

Schatak 26-Aug-15 7:16am View

What I understand is you want to combine 3 database columns into a Single column ?
these col1, col2 and col3 are in one table?

Schatak 30-Jul-15 7:21am View

Thanks for your efforts :)

Schatak 30-Jul-15 7:20am View

1. It did not work for me bad luck.
2. Optional parameter didn't work for me either , again bad luck :(
3. constructor without parameter and it worked for me.. :)

Thanks for your help:)

Schatak 30-Jul-15 7:15am View

Yeah that is typo mistake, i corrected into question.
i created a constructor without parameter( as in ur solution) and it worked for me.

Thanks

Schatak 23-May-15 0:58am View

You means you want to find 'btnSend'?

Schatak 23-May-15 0:55am View

Your most welcome

Schatak 23-May-15 0:55am View

Deleted

Your most welcome :)

Schatak 22-May-15 1:01am View

Google it you will find 100 solutions, if you stuck somewhere then ask for help.
Cheers :)

Schatak 19-May-15 8:35am View

What is the error?

Schatak 16-May-15 7:38am View

Common... is this a question? What is the issue? what is not coming? where you stuck ? what is your expectation from code?
Ask your self first then here :)

Schatak 15-May-15 2:26am View

You means you need to have nested repeater?

Schatak 15-May-15 2:20am View

Agreed !

Schatak 29-Apr-15 9:09am View

+5 for this :)

Schatak 24-Mar-15 2:55am View

When you are binding your data..use exception handling you will get to know if there is some error.
then only one can help you to resolve errors

Schatak 24-Mar-15 1:53am View

I solved it my self.
Thanks

Schatak 13-Mar-15 8:33am View

Best answer :)

Schatak 3-Mar-15 5:12am View

Rather than posting here, you can Google it. You will find many example. You can post your code related issues here

Schatak 2-Mar-15 23:58pm View

which xml?

Schatak 28-Feb-15 3:08am View

+5

Schatak 28-Feb-15 2:56am View

Good, then accept the solution :P

Schatak 27-Feb-15 4:50am View

Thanks :)

Schatak 20-Dec-14 0:17am View

try something by yourself... if you stuck then ask for solution

Schatak 20-Dec-14 0:05am View

why you want to delete record? can't you simply update it?

Schatak 19-Nov-14 7:14am View

Right

Schatak 5-Nov-14 5:52am View

what you have tried so far? are you stuck somewhere?

Schatak 1-Nov-14 6:38am View

Yes, this value may return decimal value so Int.parse will not convert it.

Schatak 1-Nov-14 6:09am View

on which value its giving error? value is integer or you are passing any decimal or string?

Schatak 1-Nov-14 6:08am View

Correct :)

Schatak 1-Nov-14 5:49am View

kindly check it with break point that what value is coming to label WorkHrs which is not converting to Int. if value is not convert-able to integer then it throw error.
You can check that. Alternatively use Convert.Int32 or TryParse.

Schatak 1-Nov-14 3:42am View

what is not working? can you tell me?

Schatak 1-Nov-14 2:10am View

Yes you are right. there is extra if statement which can be removed.
Thanks

Schatak 1-Nov-14 2:07am View

Thanks :)

Schatak 17-Oct-14 1:26am View

You want distinct record for this?

Schatak 6-Oct-14 3:51am View

by writing order by two times doesn't cause this issue.
Issue can be with your syntax in writing colon signs. can you please share your code how you are writing?

Schatak 27-Aug-14 4:11am View

Yeah i see that. my req. was to pass any date format, any ways i made separate function to convert date in this format and then find the days difference with ur logic.
Thanks

Schatak 27-Aug-14 1:44am View

will it work with any date format?

Schatak 27-Aug-14 1:43am View

not working and reason is you are passing wrong parameter in Date function
Thanks anyways :)

Schatak 26-Aug-14 8:13am View

e.g. if i pass 2014-08-01 as date1 and 2014-08-26 as date2 its not working but if i do it like
date1 = new Date(2014, 0, 1); // any custom date
date2 = new Date() //Today date

then its working. my req is to pass custom date as user input

Schatak 5-Aug-14 6:49am View

Thanks alot, +5.
it works :)

Schatak 5-Aug-14 6:47am View

It works but query taking time to load. and above solution seems better option, But thanks for the effort and reply

Schatak 5-Aug-14 6:30am View

Alright, and how about years?

Schatak 5-Aug-14 6:26am View

then do i need to take care of years?

Schatak 1-Aug-14 6:51am View

what error you are getting?

Schatak 30-Jul-14 8:35am View

Be more specific in your question for a better solution.

Schatak 30-Jun-14 8:13am View

agreed

Schatak 30-Jun-14 8:11am View

what you want?

Schatak 17-Jun-14 3:13am View

why not to use matrix?

Schatak 16-Jun-14 9:22am View

Oh i got you ....let me edit my solution for that

Schatak 13-Jun-14 8:56am View

what are your requirements?

Schatak 23-May-14 9:31am View

:) thanks

Schatak 10-May-14 6:46am View

Good one :)

Schatak 10-May-14 6:42am View

you means you want to export data in text file?

Schatak 9-May-14 1:14am View

question is not clear. can you share your query?

Schatak 9-May-14 1:12am View

its just an alternate if such situation arise

Schatak 7-May-14 7:39am View

because you have specified "TransactionTypeDivForCommercial" visibility=false so it will always give you false.
are you setting its visibility = true somewhere in your code or not?

Schatak 26-Apr-14 2:10am View

try this<br>
Table tbl = (Table)this.Master.FindControl("ContentPlaceHolder1").FindControl("table");
ContentPlaceHolder1: your ContentPlaceHolder ID on Master page
table: table id in Master page

Schatak 25-Apr-14 9:29am View

vs2008, and vs2010 too
working on both

Schatak 25-Apr-14 8:54am View

you need to improve your queries then...may be you are making it complex

Schatak 25-Apr-14 8:27am View

yes, may be there is something in installation you are missing

Schatak 25-Apr-14 8:17am View

yes, i added it successfully and written a sample code. its working fine.

Schatak 25-Apr-14 7:16am View

I just tried to the same, and am easily able to add generic Handler into VS 2008.

Schatak 25-Apr-14 3:34am View

is there any spl need to add so?

Schatak 24-Apr-14 1:21am View

what is the error? how you are using it?

Schatak 22-Apr-14 5:57am View

i tried it in firefox and its working.... which version you have?
have you checked popups are blocked or not.

Schatak 22-Apr-14 4:34am View

meaning?? what is not working?

Schatak 11-Apr-14 8:49am View

This is what i have written above you can't do it like this, if you want to take the risk then delete existing record and insert records with Row_number() instead of updating it.

Schatak 11-Apr-14 3:24am View

please elaborate bit more. what you want to say in one line? how you want to select date, from where you are selecting a date, do you want to pass a date into query?

Schatak 11-Apr-14 1:28am View

Try yourself if you stuck somewhere then ask for help

Schatak 10-Apr-14 9:20am View

question is not clear.what you want actually?

Schatak 10-Apr-14 8:15am View

then can you please improve your question and let us know

Schatak 10-Apr-14 8:00am View

what you have tried so far?

Schatak 9-Apr-14 9:29am View

what issue you are getting this page working fine/.... i just checked with the link you provided

Schatak 9-Apr-14 8:04am View

Glad to help :)

Schatak 9-Apr-14 7:28am View

what is this?

Schatak 9-Apr-14 7:19am View

you need to check the data for "dTurnover" might be there is some issue in data

Schatak 9-Apr-14 6:59am View

same error you are getting?

Schatak 9-Apr-14 6:33am View

which data type you are taking to store images? which control you are using to display images?

Schatak 9-Apr-14 6:11am View

Try this link

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

Schatak 9-Apr-14 5:54am View

you can accept this solution, i will see into this decimal part

Schatak 9-Apr-14 4:42am View

You are in wrong section, try to search for article.

Schatak 9-Apr-14 4:40am View

Strange , i am passing same value and its working fine. Do one thing just try to pass a hardcode value like this.
="Amount in words: " & Code.ChangeToWords(FormatNumber(Sum(CDec(135.60)),2))
and see if it works

Schatak 9-Apr-14 4:35am View

Meaning you want to export to word file with images in coding ? and images are in database?

Schatak 9-Apr-14 4:24am View

can you please tell me value of Fields!dTurnover.Value individually? what value it is having?

Schatak 9-Apr-14 4:17am View

Okay you means to say you have multiple entries of Specialization in TM_Specialization table corresponding to one Profile right?

Schatak 9-Apr-14 4:08am View

Deleted

why dont you just try
SELECT distinct Profile, Specialization
FROM TM_Profile TM_P INNER JOIN TM_Specialization TM_s
ON TM_S.ProfileID=TM_P.ProfileID

Schatak 9-Apr-14 4:03am View

="Amount in words: " & Code.ChangeToWords(FormatNumber(Sum(Fields!dTurnover.Value),2))

Schatak 9-Apr-14 3:55am View

One more question here, how you ca saving their specialization in specialization column? are the inserting hard coded or dynamically?

Schatak 9-Apr-14 3:25am View

Definition of ChangeToWords function is?

Schatak 9-Apr-14 3:23am View

Other profile?

Schatak 9-Apr-14 2:50am View

What error you are getting ? and can you show your code?

Schatak 8-Apr-14 9:12am View

means you want date only? no time with it?

Schatak 8-Apr-14 8:55am View

:)

Schatak 8-Apr-14 8:03am View

Welcome :)

Schatak 8-Apr-14 7:36am View

what is the issue?

Schatak 8-Apr-14 7:04am View

Your Welcome :)

Schatak 8-Apr-14 3:50am View

Deleted

and if its working then at least accept the solution and upvote

Schatak 8-Apr-14 3:49am View

write OnSelectedIndexChanged="ddl2_SelectedIndexChanged" for your serial no drop down and bind data accordingly . by serial no.

Schatak 8-Apr-14 3:32am View

Google it rather to ask here. Try it yourself if you stuck somewhere in the code, then ask

Schatak 7-Apr-14 9:29am View

Try links in Solution one, you will get the idea

Schatak 7-Apr-14 9:21am View

what you want?

Schatak 7-Apr-14 9:20am View

Agreed. At least something and show your code here, if you stuck somewhere then some one can help.

Schatak 7-Apr-14 9:11am View

that you can see yourself. its working fine the basic inserting , updating etc. else try yourself

Schatak 7-Apr-14 7:35am View

Google it, you will get numbers of solutions, if you stuck somewhere in coding then you can ask question or discuss your problem.
THanks

Schatak 7-Apr-14 7:33am View

check the solution two.i have given you. if you find it helpful go ahead and try it. donot forget to up vote and accept the solution :)
Happy Coding

Schatak 7-Apr-14 6:51am View

Definition of your table? Also all these condition should be matched or one of them?

Schatak 7-Apr-14 6:50am View

Deleted

did you try it yourself? if yes then where you are getting error? where you stuck?

Schatak 7-Apr-14 5:43am View

can you show your table definition?

Schatak 7-Apr-14 5:40am View

for serial number you have DropDown list that means you have pre-defined serial nos. then why there is primary key with identity (1,1) in table. if you have pre-defined serial no then there is no such need of primary key serial no. but if there is any need of primary key then you can take a column name rowid as primary key to keep the records unique, so tell me what ur requirements?

Schatak 7-Apr-14 5:00am View

incomplete information , please elaborate bit more., where you want to have matrix and where you stuck?

Schatak 7-Apr-14 4:56am View

Sure and if you find it helpful, then do not forget to accept the solution and vote ;)

Schatak 7-Apr-14 4:53am View

in which control you are displaying values??? any grid view or something? because to update or delete or authorize a record you need to have key value for a particular record.

Schatak 7-Apr-14 4:36am View

by the way its not Mr. is Miss :P

yeah i am checking you are totally messed up with procedure lots of mistakes

Schatak 7-Apr-14 4:28am View

Deleted

Okay ,now check my above comment.
"in your table there is no column with the name "tran_status" and in your procedure check your insert query you are passing a value for a column which is not in the table."

Schatak 7-Apr-14 4:20am View

in your table there is no column with the name "tran_status" and in your procedure check your insert query you are passing a value for a column which is not in the table.

Schatak 7-Apr-14 4:15am View

in your drop down for action what value you are passing? it should be "add" according to your stored procedure

<asp:DropDownList ID="ddl1" ClientIDMode="Static" runat="server" AutoPostBack="false">
<asp:ListItem Value="add">Add
<asp:ListItem Value="update">Update

Schatak 7-Apr-14 3:59am View

What are you doing? you are providing a very wrong query here..

Schatak 7-Apr-14 3:17am View

you want to have count of Late and early arrivals?

Schatak 7-Apr-14 2:17am View

what error you are getting?>

Schatak 5-Apr-14 11:14am View

Okay in that case make .msi or .exe of you project. you can also get the files from release folder eg .exe file or .dll files, there is also files like .dll.config. copy those files and place it customer computer.
In sql , the same way as mentioned above, create a .bak file and restore it.

Schatak 5-Apr-14 9:26am View

you want to host everything on Client's computer?

Schatak 5-Apr-14 5:35am View

Your welcome :)

Schatak 3-Apr-14 4:46am View

inappropriate information. what error you are getting while saving? what datatype you have taken in SQL side?

Schatak 2-Apr-14 14:16pm View

Perfectly answered :)

Schatak 2-Apr-14 14:03pm View

agreed

Schatak 2-Apr-14 13:40pm View

several ways...
By the queries or Use Triggers..

Schatak 2-Apr-14 6:30am View

elaborate bit more please. whats you have tried so far? what are the structure of tables?

Schatak 2-Apr-14 4:34am View

is billid primary key?

Schatak 2-Apr-14 4:28am View

what controls you want?

Schatak 2-Apr-14 3:35am View

if its helpful then accept it solution and rate it :)

Schatak 2-Apr-14 2:57am View

as per i understand from your requirements following is the code. and you made so many mistakes in SQL. Delete query was totally disaster. fixed it, run the following code

ALTER procedure gas
(
@action varchar(20),
@serial_no int,
@gas_name varchar(50),
@tran_stat varchar(50)
)
as
BEGIN
SELECT @tran_stat = tran_stat, @serial_no = serial_no, @gas_name = gas_name FROM tbl_Cyl_gas_master WHERE serial_no=@serial_no
IF(@tran_stat ='')
SET @tran_stat = CASE when @action='ADD' then 'FR' END
IF(@action ='add')
BEGIN
INSERT INTO tbl_Cyl_gas_master(serial_no,gas_name,tran_stat) VALUES (@serial_no,@gas_name,@tran_stat)
END
ELSE IF @action='update'
BEGIN
IF (@tran_stat = 'FR')
UPDATE tbl_Cyl_gas_master set gas_name=@gas_name, @tran_stat = @tran_stat WHERE serial_no=@serial_no
ELSE
RAISERROR ('Transaction not is fresh',16,1);
END
ELSE IF @action='authorise'
BEGIN
IF (@tran_stat = 'FR')
UPDATE tbl_Cyl_gas_master SET tran_stat='AU' WHERE serial_no=@serial_no
ELSE
RAISERROR ('Transaction already Authorised',16,1)
END
ELSE
DELETE from tbl_Cyl_gas_master where serial_no=@serial_no
END
GO

Schatak 2-Apr-14 2:05am View

when you are passing 'Authorise' in your Stored Procedure and in a case statement you are saying if when @action='Authorise' then 'AU'
so then next condition "else if @action='Authorise'" is not matching that's why its always saying 'Transaction already Authorised'

Schatak 2-Apr-14 1:16am View

forgot to mention..

int id = Convert.ToInt32(e.CommandArgument);
using(SqlCommand cmd = new SqlCommand("update dbo.RecordEmployee set TIME_OUT=@timeout, REMARKS=@editRemarks where EMPLOYEE_NAME =@empname and id=@id", conn))
{
cmd.Parameters.AddWithValue("@id", id);
cmd.ExecuteNonQuery();
}

Schatak 1-Apr-14 13:25pm View

can you please show your table structure ?

Schatak 1-Apr-14 13:23pm View

what error you are getting?

Schatak 1-Apr-14 8:24am View

No probs :)

Schatak 1-Apr-14 8:23am View

you want to have inline query in code behind?

Schatak 1-Apr-14 7:36am View

cool

Schatak 1-Apr-14 3:06am View

what should be the output if you are inputting 3?

Schatak 1-Apr-14 3:06am View

Deleted

what should be the output if you are inputting 3?

Schatak 1-Apr-14 2:27am View

Maciej Los : Great work,
@hackersid i was trying the same with CTE. before i submitted you got your solution :)

Schatak 29-Mar-14 7:39am View

can you please tell me your table structure as well?

Schatak 28-Mar-14 7:17am View

It helped. Thanks

Schatak 27-Mar-14 9:07am View

Really helpfull

Schatak 27-Mar-14 7:15am View

This is not proper question..Please elaborate..

Schatak 27-Mar-14 7:12am View

Perfect

Schatak 27-Mar-14 4:01am View

above query is not concatenating but adding

Schatak 26-Mar-14 7:35am View

what exactly you want ? Elaborate bit more

Schatak 26-Mar-14 7:32am View

where you are specifying Tool-tip?

Schatak 24-Mar-14 3:18am View

"Usp_GetImeiTable" is your SP?

Schatak 24-Mar-14 2:52am View

what is the structure of your tables on which you are making join?

Comments by Schatak (Top 200 by date)