Comments by <font color="9E7BFF">Aarti Meswania</font>

Aarti Meswania 7-Oct-19 2:04am View

5ed! :)

Aarti Meswania 4-Oct-19 1:15am View

Hi Akshay,

That is called "dynamic query" for which you can refer link I have mentioned above. but I am trying to say that it is not safe as well as it might give you results slower. in above link see example of dynamic query
DECLARE @SQLString AS NVARCHAR(MAX);
SET @SQLString = N'SELECT ' +@columnnames+N' FROM ' + @tablename;
EXEC(@SQLString);

Let me suggest another approach, You have to find data in table so that columns are fixed. you want to filter 10 columns - 15 columns or 100 columns no matter, it's fine...
you can do that easily without dynamic query.
How???
WHERE
(tsn.SurveyorName= @SurveyorName OR @SurveyorName IS NULL)
AND (state = @state OR @state IS NULL)

kind of this you can write as many as you want.
and pass value to particular parameter(s) which you want, and avoid passing value to parameter(s) which you don't want, and see the magic :) It will give you exact output you seek. moreover, it's good and maintainable approach to write code:)

Aarti Meswania 1-Oct-19 3:26am View

Glad to help you through this platform. However, I can't exchange the contact information, irfan. also I am not too much sharp in ASP.net.
Codeproject members are active n helpful to each other. you can post your queries here on codeproject and people who have knowledge in relevant topic would help you :)

Aarti Meswania 30-Sep-19 9:46am View

Irfan, first of all I am a female :) you can say aarti instead of sir.
so....
here, (select sum(Qty) from inv where VouDt< i.VouDt) as OpnQty
means collecting qty field values which falls into less than running date and sum up qty to retrieve opening qty. for running date.
you can learn subquery for further details

Aarti Meswania 30-Sep-19 6:01am View

vusamozi asked question in which stock is considered.
and when you sell something qty reduce not add up.

Aarti Meswania 30-Sep-19 5:32am View

please put your code for sps you have create and It seems you can solve the problems using sp only. kindly give sp details and the sample data and required output, that will make things easier to understand and you will able to get solution faster.
.net code is not required here, as it will just be used to trigger sp.

Aarti Meswania 30-Sep-19 5:21am View

there are 3 columns here for quantity, OpenQty, Qty (which means consumed), closingQty.

if opening Quantity is -1 (A thing(mobile) was already borrowed)
consumed quantity is 1, it's another A thing(mobile) you are borrowing so it's having -ve sign (-1)
so closing qty is "opening Quantity" - "consumed quantity" = "closing quantity"
so -1-1=-2 (you have borrowed 2 things(mobiles))
hope that helps, actually logic is easy if you have a stock and qty is consumed from that, but here it's case where you do not have stock and to serve customer you borrow new mobile from sister firm, sale it and then later you gonna return another new mobile to the sister firm when you bring new stock.

Aarti Meswania 27-Sep-19 2:24am View

can you please post your sql query?

Aarti Meswania 26-Sep-19 4:31am View

perfect :)

Aarti Meswania 18-Sep-19 6:46am View

Thank you, Maciej Los :)

Aarti Meswania 15-May-15 15:14pm View

Printer.FontName = "times new roman"
simply give name of your font

Aarti Meswania 2-Apr-15 5:14am View

create store procedure for insert and update records.
and set an event scheduler which automatically run on desired time and sync. data.
please visit link..
https://dev.mysql.com/doc/refman/5.1/en/events.html

Aarti Meswania 27-Mar-15 2:29am View

your question is not clear...
do you have a data in table like below
1 abc...
2 pqr...
3 xyz....
if it is so, then you can display data of first row when user clicks button 1, 2nd row data when user clicks button 2..

please be clear is it a text and you are facing issue to split it?
or facing problem to open up new window which have label docked in and display text whatever it is..

Aarti Meswania 5-Mar-15 4:22am View

simply modify your sql query associated with report and apply grouping

Aarti Meswania 18-Nov-14 3:13am View

Do you mean to say window application with c#?
and you have to read data from db first please google how to connect with db and read data from table.

Aarti Meswania 22-Sep-14 12:59pm View

:)

Aarti Meswania 22-Sep-14 12:40pm View

no didn't mean that SA :)

Aarti Meswania 22-Sep-14 12:14pm View

welcome!
it isn't exaggeration. It's really perfect solution :)

Aarti Meswania 22-Sep-14 12:02pm View

Thank you, Sergey Alexandrovich Kryukov
:)

Aarti Meswania 22-Sep-14 12:02pm View

5+! :)
TryParse and double type will make code perfect

Aarti Meswania 22-Sep-14 11:22am View

please check updated solution

Aarti Meswania 22-Sep-14 11:20am View

values should be float

Aarti Meswania 22-Sep-14 10:21am View

ok
try this once
while (count < linesPerPage && ((line = myReader.ReadLine()) != null))
{
if(count==0)
(
yPosition = 590;
topMargin = 590;
}
else
{
yPosition = 100;
topMargin = 100;
}
yPosition = topMargin + (count * printFont.GetHeight(e.Graphics));
e.Graphics.DrawString(line, printFont, myBrush, leftMargin, yPosition, new StringFormat());
count++;
}

Aarti Meswania 22-Sep-14 6:09am View

first of all find "no. of pages" to be printed

Aarti Meswania 22-Sep-14 4:50am View

what is issue are all pages having 590 margin or 100?

Aarti Meswania 21-Sep-14 11:36am View

sql jobs are like timers.
On configured time sql job runs and performs task assigned to it.
the task can be sp(store procedure) or exe files etc
http://msdn.microsoft.com/en-IN/library/ms190268.aspx

Aarti Meswania 20-Sep-14 13:09pm View

first you tell me are you using SQL server as back-end database?

Aarti Meswania 20-Sep-14 12:18pm View

please describe your query properly

Aarti Meswania 20-Aug-14 12:39pm View

thanks :)

Aarti Meswania 2-Aug-14 4:56am View

thank u :)

Aarti Meswania 28-Jul-14 9:50am View

welcome :)

Aarti Meswania 28-Jul-14 7:46am View

without ID it's good option
my method is resource and time taking if OP do not need ID then your query is best suited

Aarti Meswania 28-Jul-14 7:44am View

thank you, Maciej Los :)

Aarti Meswania 28-Jul-14 6:49am View

welcome :)
Glad to help you! :)

Aarti Meswania 26-Jun-14 2:35am View

5! :)

Aarti Meswania 30-May-14 13:25pm View

nice solution.
5+! :)

Aarti Meswania 23-May-14 2:58am View

Thank you, Maciej Los :)

Aarti Meswania 21-May-14 8:47am View

5+! :)

Aarti Meswania 15-May-14 2:08am View

that's good you got solution.
good day! :)

Aarti Meswania 15-May-14 1:47am View

it is because you have used str()
please do as below
order by S.On_Hand_Qty

Aarti Meswania 14-May-14 2:45am View

please provide sample output.

Aarti Meswania 14-May-14 2:33am View

nice answer
5+! :)

Aarti Meswania 14-May-14 2:30am View

ok store-procedure was the best way to do this :)

Aarti Meswania 14-May-14 2:14am View

DECLARE @Temptbl table (col Nvarchar(200))
INSERT INTO @Temptbl (col)
VALUES('<html><body><p style=''Color:Red;Font-Size:2px''>xyz xyz xyz</p><image src="~xyz/xyz.png" alt="image"/></body></html>')
SELECT * FROM @Temptbl

run this and check output

Aarti Meswania 14-May-14 2:11am View

yes you will get same format

Aarti Meswania 20-Apr-14 11:05am View

welcome! :)

Aarti Meswania 20-Apr-14 10:33am View

detailed solution. 5+! :)

Aarti Meswania 20-Apr-14 10:28am View

5+ :)

Aarti Meswania 17-Apr-14 4:30am View

Most welcome!
Glad to help you! :)

Aarti Meswania 15-Apr-14 4:55am View

take a look to your code block

Dim n As Integer = DataGridView1.RowCount - 1

it is causing issue what you are doing everytime calculating "total" for grid's last line
DataGridView1.RowCount - 1

you should use CurrentCellDirtyStateChanged event and e.rowindex/columnindex property to get currrent row/col
follow link I suggested in my answer

Aarti Meswania 14-Apr-14 7:58am View

WITH a as
(
SELECT 49 as qty, 'a' as nm UNION ALL
SELECT 51 as qty, 'b' as nm UNION ALL
SELECT 49 as qty, 'c' as nm UNION ALL
SELECT 50 as qty, 'd' as nm
)
SELECT qty,nm,row_number() OVER (partition BY srno order by qty,nm) from
(
SELECT qty,nm, row_number() OVER (partition BY qty order by nm) srno from a
) as temp
order by qty,nm

Aarti Meswania 14-Apr-14 2:40am View

welcome! :)

Aarti Meswania 14-Apr-14 1:46am View

5+! :)

Aarti Meswania 13-Apr-14 2:48am View

welcome :)

Aarti Meswania 11-Apr-14 4:25am View

5+! :)

Aarti Meswania 10-Apr-14 8:56am View

DECLARE @nthLowest int = 3
DECLARE @nthHighest int = 3
;WITH tbl_emp as
(
SELECT 27000 as sal,'emp 01' as emp union ALL
SELECT 2,'emp 02' union ALL
SELECT 3,'emp 03'
)
SELECT sal, emp FROM
(
SELECT sal, emp ,
row_number() OVER ( order by sal,Emp) as sal_asc_order,
row_number() OVER ( order by sal DESC,Emp ) as sal_desc_order
FROM tbl_emp
) as temp
WHERE sal_asc_order = @nthLowest -- you can also use <=
--WHERE sal_desc_order = @nthHighest -- you can also use >=

Aarti Meswania 9-Apr-14 8:32am View

which binding you are using (transport protocol)?

Aarti Meswania 9-Apr-14 2:38am View

5+! :)

Aarti Meswania 8-Apr-14 13:48pm View

first step is follow the link understand how they fill-up combobox

Aarti Meswania 8-Apr-14 13:05pm View

5+! :)

Aarti Meswania 8-Apr-14 12:58pm View

but what is problem you are facing?

Aarti Meswania 8-Apr-14 12:35pm View

Thank you! Maciej los :)

Aarti Meswania 7-Apr-14 7:17am View

<pre lang="sql">SELECT 'Original' as grp, * FROM yourtblname
UNION ALL
SELECT 'Duplicate' as grp, * FROM yourtblname
UNION ALL
SELECT '3rd Copy' as grp, * FROM yourtblname</pre>
now in report add group header by 'grp' field
paste 'grp' field inside group to display title
to display each grp on new page..
1. On the left hand side of the Section Expert, select your Group Footer.
2. Then, on the right hand side, select "New Page After".

Aarti Meswania 7-Apr-14 5:23am View

Welcome! :)

Aarti Meswania 7-Apr-14 4:52am View

I have updated ans try now

Aarti Meswania 7-Apr-14 4:10am View

search on google for that because I already suggest a way to solve issue, I think you have to create some global variable and maintain record count for all 4 sub-report then you can make the final condition for section 'b'

Aarti Meswania 7-Apr-14 2:58am View

just add underlined line in Addtab() method as I did

Aarti Meswania 6-Apr-14 11:56am View

Welcome!
Glad to help you! :)

Aarti Meswania 6-Apr-14 11:31am View

why are you adding prefix "amrapali complaints"?
just remove it...

Aarti Meswania 6-Apr-14 11:05am View

Welcome! :)
rating a single star is considered as down-vote.
please do not use "sir" I m just a code-project member as you. :)

Aarti Meswania 4-Apr-14 1:11am View

welcome :)
didn't get you please give an example

Aarti Meswania 3-Apr-14 7:35am View

ok I have not tried it but can suggest you how can you achieve this
take 2 detail sections as I told you
put sub report 1 n 2 in section A
put sub report 3 n 4 in section B

now right click section A -> tick "underlay following section" press formula button for that option write down condition that if sub report 2-3 is suppressed or 1 and 4 is suppressed is true then it should underlay section

Aarti Meswania 3-Apr-14 6:24am View

what do you mean by "If i place four sub report in single detail section, empty sub report will be suppress so the gap should be avoided."

can you show me design view how should it look
1. if sub report 2 and 3 is empty?
2. if sub report 1 and 4 is empty?
3. if sub report 1 and 3 is empty?

Aarti Meswania 3-Apr-14 4:21am View

okay then what o/p you want?
I think you want to display sub report one and four together in detail section a right?

Aarti Meswania 3-Apr-14 4:18am View

Deleted

do not write this "please reply fast" no one is 24x7 available
when some person will check notification he/she will reply.

Aarti Meswania 3-Apr-14 3:30am View

then move sub report three and four in detail section b
or
fix hieght and width of all sub reports

Aarti Meswania 3-Apr-14 0:14am View

Thank you! Maciej Los :)

Aarti Meswania 2-Apr-14 7:56am View

if you already know solution then why are you not using it, is there any reason?

Aarti Meswania 31-Mar-14 9:10am View

can you give format of Itemcode ?
like
item_001 or item001...

Aarti Meswania 31-Mar-14 3:06am View

Most welcome! :)

Aarti Meswania 31-Mar-14 3:06am View

Thank you! Maciej Los :)

Aarti Meswania 27-Mar-14 7:15am View

Andrius Leonavicius, thanks for upvoting! :)

Aarti Meswania 27-Mar-14 7:14am View

Thank you! Jas 24 :)

Aarti Meswania 27-Mar-14 7:14am View

Thank you! King_Fisher

Aarti Meswania 25-Mar-14 8:11am View

5+! :)

Aarti Meswania 25-Mar-14 6:12am View

5+! :)

Aarti Meswania 24-Mar-14 9:41am View

sorry but you should do it your self I have already given explaination why array is used and also given a link to see an example

Aarti Meswania 24-Mar-14 9:25am View

Welcome! :)

Aarti Meswania 24-Mar-14 9:22am View

Is your form have too many controls?
when you run app can you see there some extra unused space which you think you can utilized it then paste controls properly inside table layout panel

Aarti Meswania 24-Mar-14 9:11am View

5!+ :)

Aarti Meswania 24-Mar-14 9:00am View

I am just a code project member as you are, please do not use "sir" :)
have you put all controls properly in table layout panel?

Aarti Meswania 20-Mar-14 4:23am View

welcome :)

Aarti Meswania 20-Mar-14 4:22am View

to hide Total of Summarized Field just suppress it
right click cross tab report click "Cross-Tab Expert"
third tab, Customize Style, there are check boxes where you can suppress subtotals and grand totals.

Aarti Meswania 20-Mar-14 4:19am View

you should paste comment using "Have a Question or Comment?" button given under particular solution

Aarti Meswania 20-Mar-14 2:37am View

5+! :)

Aarti Meswania 19-Mar-14 7:35am View

when you click button page is getting refresh and asp table control is reset that's why it happen see solution 2 it is generating table when page is loaded first time

Aarti Meswania 19-Mar-14 4:25am View

are you opening form2 on Form1(buton click or grid view row click- inshort opening from2 from form1)?

Aarti Meswania 18-Mar-14 14:31pm View

you are welcome!
glad to help you! :)

Aarti Meswania 16-Mar-14 4:14am View

5+! :)

Aarti Meswania 3-Mar-14 23:41pm View

Thank you! Maciej Los :)

Aarti Meswania 12-Jan-14 8:34am View

do you mean in designer page it shows error, but if you run project it works perfectly?

Aarti Meswania 9-Jan-14 4:59am View

hi, Maciej Los
Happy new year!
thanks for upvoting :)

Aarti Meswania 9-Jan-14 3:43am View

provide sample table data and required o/p

Aarti Meswania 4-Jan-14 5:40am View

welcome :)

Aarti Meswania 4-Jan-14 5:36am View

5+ :)

Aarti Meswania 4-Jan-14 5:34am View

hmm it might be related to ie version don't know but it worked on my machine

Aarti Meswania 4-Jan-14 5:24am View

actually I goggled also if any issue like this to confirm but no one have problem like this "IE not support add word as function name"

Aarti Meswania 4-Jan-14 5:15am View

strange but it's working in IE too..

Aarti Meswania 4-Jan-14 4:58am View

hi I have tried with 'add' function name
it is working
go to link
http://www.w3schools.com/html/tryit.asp?filename=tryhtml_intro
and paste code run and check it is working
<!DOCTYPE html>
<html>
<script type="text/javascript">
function add()
{
alert(1);
}
</script>
<body>
<button type="button" önclick="add()">Click Me!</button>
</body>
</html>

Aarti Meswania 4-Jan-14 4:43am View

Thank u! :)

Aarti Meswania 3-Jan-14 3:09am View

Thank you! :)

Aarti Meswania 2-Jan-14 23:41pm View

It was for OriginalGriff
please use "Have a Question or Comment? " :)

Aarti Meswania 2-Jan-14 12:49pm View

short n simple
5!+ :)

Aarti Meswania 31-Dec-13 7:15am View

If you get solution then please mark it using "Accept Solution"

Aarti Meswania 31-Dec-13 6:21am View

Most welcome!
Glad to help you! :)

Aarti Meswania 31-Dec-13 2:40am View

do not write as just write alias

Aarti Meswania 31-Dec-13 0:50am View

welcome!
Glad to help you! :)

Aarti Meswania 30-Dec-13 8:19am View

Welcome!
Glad to help you! :)

Aarti Meswania 30-Dec-13 7:22am View

I have updated solution
please check again
hope this will work perfectly as your requirement :)

Aarti Meswania 30-Dec-13 3:54am View

not enough info. provided, debug and check which exception you are getting?

Aarti Meswania 30-Dec-13 2:31am View

5+! :)

Aarti Meswania 27-Dec-13 8:28am View

this will not work or may be very lengthy just search for recursive query,
you will get solution :)

Aarti Meswania 27-Dec-13 8:26am View

Thanks! :) loraloper_22

Aarti Meswania 27-Dec-13 8:26am View

Thank you! :) BillWoodruff

Aarti Meswania 27-Dec-13 8:07am View

ok then post new question with details
and you will require Recursive query for tree senerio

Aarti Meswania 27-Dec-13 8:02am View

Thank you! :)

Aarti Meswania 27-Dec-13 8:02am View

simply run this query
select create_by_user_id from tbl_advisor_registration where advisor_id = 37
this records will be displayed with comma in my query
you are writing some wrong condition
suppose I remove where condition then it will give all create_by_user_id from your table with comma separator
Select Stuff( ( Select ', ' + Convert(varchar(5),create_by_user_id) from tbl_advisor_registration For Xml Path('') ), 1, 2, '' )

Aarti Meswania 27-Dec-13 7:58am View

because you have only one record against advisor_id = 37 in your table

Aarti Meswania 27-Dec-13 7:47am View

yes
simply use this
Select Stuff(
(
Select ', ' + Convert(varchar(5),create_by_user_id)
from tbl_advisor_registration
where advisor_id = 17 --@intro_id
For Xml Path('')
), 1, 2, ''
)
you will get result

Aarti Meswania 27-Dec-13 6:21am View

Thank you! :)

Aarti Meswania 28-Nov-13 6:55am View

Thank you OriginalGriff for kind response
I want to search my project files that fulfill above criteria in visual studio 2010 using Find and replace window that we open using ctrl+f shortcut...
could you please suggest regex for that I have tried many regex but didn't worked

Aarti Meswania 11-Oct-13 8:17am View

easy Homework. try it your self :)

Aarti Meswania 4-Oct-13 2:52am View

welcome!
Glad to help you! :)

Aarti Meswania 4-Oct-13 2:10am View

var d = new Date();
write below code inside if condition

var curr_date = d.getDate();
var curr_month = d.getMonth() + 1; //Months are zero based
var curr_year = d.getFullYear();
passed.value = curr_date + "-" + curr_month + "-" + curr_year;

for set tetxbox empty then...
passed.value = "";

Aarti Meswania 26-Sep-13 1:09am View

when condition will be
where facid like '%1%'
it will show wrong data

Aarti Meswania 11-Sep-13 4:43am View

Thank you! :)

Aarti Meswania 30-Aug-13 9:12am View

are you using cross apply?

Aarti Meswania 28-Aug-13 14:15pm View

Welcome,
Glad to help you! :)

you should use "Have a Question or Comment?" button given below particular que-ans.

Aarti Meswania 26-Aug-13 12:24pm View

thank u!
:)

Aarti Meswania 26-Aug-13 12:24pm View

thank you! :)

Aarti Meswania 26-Aug-13 7:50am View

5+:)

Aarti Meswania 26-Aug-13 5:52am View

just remove order by clause

Aarti Meswania 26-Aug-13 5:39am View

check properly because I have wrote query that gives you sum of paidAmount only not total amount.
give an example input - output record so, it will easy to understand requirement.

Aarti Meswania 26-Aug-13 4:48am View

click on start button

now in search files & folders textbox write
services.msc
press enter

Aarti Meswania 26-Aug-13 4:07am View

yes it's giving same o/p as you described in quastion

Aarti Meswania 26-Aug-13 4:04am View

case "1"
report.Load(Server.MapPath("Reports/RepCompanyCod.rpt"))

Dim SConn As New System.Data.SqlClient.SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString)
report.DataSourceConnections(SConn.DataSource, SConn.InitialCatalog).SetConnection(SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password)

case "2" ....

CRptViewer.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None
CRptViewer.DisplayToolbar = False
Page.Title = "Company Reports"

Aarti Meswania 26-Aug-13 3:26am View

see second link write this code in button click or form load event

Aarti Meswania 26-Aug-13 2:47am View

yes it's just for information.

Aarti Meswania 26-Aug-13 2:01am View

I think you are not using google language tool...
then make your textbox's fonts marathi.

Aarti Meswania 26-Aug-13 1:32am View

yes it will show same data you stored
try this...
declare @demo nvarchar(100)
set @demo = N'विद्या' -- set / insert val.
select @demo -- select (retrive value)

Aarti Meswania 21-Aug-13 6:39am View

Thank you! :)

Aarti Meswania 21-Aug-13 5:10am View

Thanks for reply :)
if I split string by comma then it will result
@a = '1'
@b = 'hello@123.com
hi@123.com'

I don't want to split 'hello@123.com,hi@123.com'

Aarti Meswania 14-Aug-13 3:56am View

Thank you,ridoy
:)

Aarti Meswania 12-Aug-13 8:48am View

which form you have open first?
is form2 is opened on form1's button click?

Aarti Meswania 12-Aug-13 6:07am View

Thank you! :)

Aarti Meswania 4-Aug-13 3:40am View

Welcome!
Glad to help you!:)

Aarti Meswania 4-Aug-13 3:25am View

welcome :)
to convert code in c# just go to below site and copy paste my code, and convert it from vb to c#
http://converter.telerik.com/

Aarti Meswania 30-Jul-13 4:16am View

My guess,
If you have wrote code that use text/excel files, then make sure path is correctly fetched while running app from realease folder.

e.g.
you have wrote database connection string in text file? or using ms-access database, run time path of file should be correct for release folder

Aarti Meswania 26-Jul-13 8:46am View

give example.

Aarti Meswania 23-Jul-13 4:04am View

Welcome!
Glad to help you!:)

Aarti Meswania 17-Jul-13 9:55am View

Welcome!
Glad to help you! :)

Aarti Meswania 3-Jul-13 3:05am View

Welcome!
Glad to help you! :)

Aarti Meswania 28-Jun-13 4:55am View

Thank you! :)

Aarti Meswania 27-Jun-13 6:54am View

Welcome!
Glad to help you! :)

Aarti Meswania 27-Jun-13 6:54am View

Thank you! :)

Aarti Meswania 26-Jun-13 14:26pm View

Welcome :)

Aarti Meswania 26-Jun-13 14:24pm View

5!+ :)

Aarti Meswania 26-Jun-13 14:24pm View

Thank you!
:)

Aarti Meswania 20-Jun-13 6:26am View

not clear in any case you want to return t.year?
what is your actual query?

Aarti Meswania 20-Jun-13 4:18am View

Thank you! :)

Aarti Meswania 20-Jun-13 4:09am View

5! +

Aarti Meswania 19-Jun-13 6:19am View

Thank you! :)

Aarti Meswania 19-Jun-13 2:40am View

Thank you!
:)

Aarti Meswania 5-Jun-13 5:57am View

Welcome!
Glad to help you!: )

Aarti Meswania 4-Jun-13 13:10pm View

Welcome!
Glad to help you! :)

Aarti Meswania 4-Jun-13 9:37am View

5!+ :)

Aarti Meswania 4-Jun-13 8:57am View

yes it's example
make sure column name 'PName' is exist in 'DbPlayers.dbo.tbPlayers'

Aarti Meswania 4-Jun-13 7:39am View

Thank you!
:)

Aarti Meswania 4-Jun-13 7:00am View

SELECT DISTINCT [a.ID], [P.PName], dense_rank() OVER( ORDER BY [p.PName]) AS NewKeyID
FROM YourTableName a
Left Join DbPlayers.dbo.tbPlayers P on P.ID = a.ID
order by [a.ID];

Aarti Meswania 4-Jun-13 7:00am View

Deleted

SELECT DISTINCT [a.ID], [P.PName], dense_rank() OVER( ORDER BY [p.PName]) AS NewKeyID
FROM YourTableName a
Left Join DbPlayers.dbo.tbPlayers P on P.ID = a.ID
order by [a.ID];

Aarti Meswania 4-Jun-13 4:40am View

see updated solution

Aarti Meswania 4-Jun-13 4:32am View

last row o/p you want is
20009 2013 5 0 1

but check input last 2 line
1080 20009 24132 2013 5 13 18 19 48
1080 20009 24133 2013 5 13 18 28 36
if it's like this then
1080 20009 24132 2013 5 13 18 19 48
1080 20009 24133 2013 5 16 18 28 36

then I could change my query

Aarti Meswania 4-Jun-13 2:46am View

Welcome!
Glad to help you! :)

Aarti Meswania 4-Jun-13 2:11am View

visit link http://msdn.microsoft.com/en-IN/library/aa288411(v=vs.71).aspx

Note ignore merge module
but add prerequiites
http://www.codeproject.com/Questions/444825/In-my-windows-application-I-need-to-install-crysta

and use Add file option by right click on setup project then Add all .rpt files you created

then build

in setup project debug folder you will see setup file and folders which was selected for prerequisite

Aarti Meswania 4-Jun-13 0:54am View

No it's not CTE,
I have just use WITH as table you have create temp table I just use with it's not CTE
Rounding function is sql's default function,
in your query if you will replace cases with "round(packetsNumbers,-1,1)" then it will also work
so, I don't think I should improve my answer

Aarti Meswania 3-Jun-13 10:07am View

Thank you! :)
Sorry didn't get you, in that query of "Common Table Expressions on msdn" how could I use it?

Aarti Meswania 3-Jun-13 8:24am View

please check solution to avoid lot of select cases...

Aarti Meswania 31-May-13 9:39am View

welcome

Aarti Meswania 31-May-13 9:35am View

for(i=0;i<=dt.rows.count-1;i++)
{
var items = checkedListBox1.Items;
items.Add(dt.rows[i]["colName"]); //replace colName with the name of column you want to display data in checkbox
// items.Add("Checked", true);
}

Aarti Meswania 31-May-13 9:29am View

do you know how to get data in dtatable using sqladapter?

Aarti Meswania 31-May-13 9:27am View

establish connection...
thaen using sql dataadapter fill data in datatable
for loop for all datatable row and add item to checklistbox

Aarti Meswania 31-May-13 9:22am View

yes say

Aarti Meswania 31-May-13 9:22am View

Welcome! :)

Aarti Meswania 31-May-13 9:15am View

i can't code i don't know database and credentials table etc
i can just suggest a way...
fetch that time from database and then keep in variable now you can compare that variable value with time control's timing inside tick event

Aarti Meswania 29-May-13 8:10am View

Welcome! :)

Aarti Meswania 29-May-13 8:02am View

right 5!+ :)

Aarti Meswania 29-May-13 7:06am View

have you read note?
about case-sensetiveness of tablename?

Aarti Meswania 29-May-13 7:05am View

if you have events validating / velidated then inside them

Aarti Meswania 29-May-13 6:26am View

see updated soulution...

Aarti Meswania 29-May-13 6:16am View

how you decide grp for employee ?

Comments by Aarti Meswania (Top 200 by date)