Comments by Rajesh waran (Top 200 by date)

try this,
dr["AverageMarks"] =(float.Parse(dr["TotalMarks"].ToString())/3).ToString();

Thank you Maciej.

Yes I too have same opinion. But there are thousands of record so I can't change the design now.

Thank u I'll try this and come back to u.

Can you show your code for binding grid also with query? It may be useful to help you.

Yes, you see another solution from him is also driving to his blog.
http://www.codeproject.com/Answers/892059/How-to-Export-data-from-Gridview-into-PDF-file#answer3

Thank you.

How is it possible by using Union? If you use union then there will be two columns as Output. But see the Op's expecting output, test1 from first query and test2 from second query. So have to use joins.

Can you show what you have tried?

Sorry little bit confused i'll delete my solution.

Please do not answer for very old questions.

Actually I too try to explain what you have said in your solution, that's why i have provide a link to him for further reference.

You mention that "If i select Sam and Save the form" then sam should remove.
Are you storing that selected(Sam) value to another table. If yes it is possible to load Checkbox without "Sam".

Debug your code and check the parameters value for that columns.

Are you sure, Is this your complete query? or Did you use any Convert() or Cast() with this?

Try to post it as comment, not as an Answer.

Yes you're right.Already i have notice him

I have edited your question, not posted it again.

Stop reposting.

5*

Yes you are right. And your solution looking Good.

Your @post Sqldbtype is varchar,but you are passing integer value to it. Check it out.
Also you have to check textbox value. Bcoz you are using Convert.Int32() so you have to check that textbox values is in integer or not?

Please Check your column 7 is ActualWt or not? and also to have to cast it in your correct format. So check that ActualWt datatype is float or double or int etc.,
select row.Field<double>, Here you have to change your datatype. If your column is in int, change field to int.

If you got solution from me, just accecpt the answer as solution in order to remove this question from unanswered queue.

Now i have updated my solution, Check it out.

In your Html page make this changes, Add ShowFooter="true" here,
<asp:GridView runat="server" ID="gvrecords" AutoGenerateColumns="false" ShowFooter="true" HeaderStyle-BackColor="#7779AF" HeaderStyle-ForeColor="White" DataKeyNames="DocketNo" Width="80px">

Yes, you're right. I'll change it.

Thank you for the wounderful links, I have referred Griff's tips/trics, and it was very helpful to me. I got solution from Jofn C Rayan with little modifications.

My Final query is edited from your solution (Just added max recursion),
DECLARE @String NVARCHAR(MAX)
SET @String=''

SELECT @String = @String + replace(Tree+',' ,',', '$'+cast(User_Id AS varchar) +',')
FROM tbl_treeIntro

SELECT @String = LEFT(@String,LEN(@String)-1)

SELECT * FROM dbo.Split2(@string, ',')


option(maxrecursion 1000)
go
Thanks for the reply.

5*.

Thanks it was working. But got message like this "The statement terminated. The maximum recursion 100 has been exhausted before statement completion". So i have added a line at last like "option(maxrecursion 1000)" Now it's working fine. Thanks for the reply.

You may start from here,There are so many links available.
https://www.google.co.in/?gfe_rd=cr&ei=7zz4VPCsPIPV8geZtIHQCw&gws_rd=ssl#q=asp.net+tutorial+for+beginners[^]

No need to post solution for very old question.

I have updated my solution.Have a look.

Cool.

5+. But OP's required output is starting from D05503. So i think have to change "VARCHAR, 5503" to "VARCHAR, 5502".

Now i have updated my solution. Have a look

Sorry Just remove ORDER BY Clause from both query.It works fine.Now updated. Have a look

Not Clear.Do you want to delete records which is repeated less than or equal to 2?
but your query returns repeated records greater than 2. Can you explain it clearly with sample data's?

You're Welcome.

If you want to calculate Years of experience from Hiredate to Current date, try like this,
select DATEDIFF(YEAR,hiredate,GETDATE()) from emp

Posting Answer to very old question is not a good idea.

What is your expecting output? i think you are in need of Joins. Can you show some table records?

Do you need all data without status=9

Don't post your Question as Comments.Just edit you question.

Not clear. Do you mean two Columns? If you have two columns(order and Status), then try this query "Select order,status from Table_Name where status=8" or provide more info about table records and Required output.

Refer this for Pivot,
http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[^]

In Sql you may try Convert().

Try like this,
insert into Database1.dbo.Table1(Column1,Column2) select Column1,Column2 from Database2.dbo.Table2

5*

5*

But you didn't mention that you are merging two tables together.And also forgot to provide both table design. Be clear with your question. Provide correct info about your question.

I have updated my solution, Hope it may help you.

Not so Clear with you question. If this is your table design can you tell about your expecting output result ?

I can't understand your Question. Try to post it as new question.bcoz if you ask new question in your old question,it will not visible soon to all.then you may not get good solution here. So post your full table design and provide more info about your question in new question session.

Error ??? What exception you got? Debug your code and check what exception is showing?

Posting solution to old question will not be a good idea.This one is your third count of posting solution to old question

Already he has been reported.This is second count of posting old question

No need to answer very old question.This is more than 3 years old.

Thanks,Let me try and tell you.

I go through your solution, Is this applicable for all languages. I'm in need of Tamil language to insert in Sql server 2008 R2.That's why i'm asking.

This one is more than 3 years old question no need to answer it.

Do not answer for very old question.

This is a very old question(nearly 2 years old). no need to answer.

Yes,passing parameterised Query is right one.

Just now saw your updated answer

This may leads to sql injection.Have a look at this link.
http://www.w3schools.com/sql/sql_injection.asp[^][^]

Then what is your problem? Label1 is showing error msg or not?

It's almost 3 years old question.No need answer

What you have tried? Try to google it.Check here:
https://www.google.co.in/?gfe_rd=cr&ei=34bIVLuFEq7M8gfE3YDYDg&gws_rd=ssl#q=how+to+create+pdf+file+in+asp.net

Welcome.

Start searching it from Google is a Good Solution.

My +5.Good one.

Thank you My Lord

Nice Try.If you try like this,you will get some new idea about your concept.

So you don't try anything.try Same process by using pivot,Use count to get how many items for each doctors. I won't do your home work. Try same concept as i told you.
Try it yourself so that you'll get some errors and you can clarify.After getting issue you may ask here.we'll help you.

I have used CTE(Common Table Expression). Google it to know more information about CTE,you will get more idea than i explained here.

My +5

Now I have updated my solution again.Check edit3 in my solution.For one information I'm using sql server 2008 R2.

it's working fine.can you check it again?

I have updated my solution check it now

what order do you need? you can change column here

You're welcome.If my solution is correct to you, just accept my solution using "Accept Answer" button.In order to remove this question from Unanswered Queue.

I have Updated my Solution.You can Refer now.

I have updated my solution .Refer it now

My +5

I suggest you to follow this link.[^]

Cool !!! I'm just adding some links with u I didn't comment ur solution... Cool

No need to answer for very old question.

What you have tried? Paste your code and tell us where you have struck?

I updated my solution. Check it out.if you need list of names don't go with scalar.Try Dataset,DataTable and SqlDataAdapter

you told that u want to retrive list of image_name from your table where your id is equal.but u are using ExecuteScalar.if you use scalar it returns only one row with first column,but u want list of images.Refer this link,you get an idea about scalar.
http://www.aspsnippets.com/Articles/Difference-between-ExecuteReader-ExecuteScalar-and-ExecuteNonQuery.aspx
And do some research about Dataset and Datatable.

tell me what you want to do? you try to retrive imagename from table.where u want to bind it?

May i know you are using scalar? do u know what are the uses of scalar?

Rohan,you are right.but not yet understand what OP want? i think he is not clear with his question? bcoz it tends to SQL injection.

can you post your code? by using Improve Question. bcoz this is not so clear.If you want to use find control,you have to tell about your parent controls.

you're welcome

My +5.Good idea

My +5. Merry Christmas

Thanks Tomas

Dude He want to add identity to ID2 not ID1.

Dude! may i know why you are using stuff() here? OP didn't mention that he want comma seperated output.

I read all comments.But i don't know about his control.Also he need query, So that i posted query. He's not clear with his question.

Your post is not so clear.Please use Improve Question widget and update your question.
Try to provide your code what you have tried? and tell us what you want to do?

Please do not pass values like this.Try to use parameterised query.

So what output you are getting ? and tell us what is your expecting output? also share your complete table design.All queries are looking similar,where you are passing RbnFilter value?

Make a break point and debug your code then find where you are struck with that "msg" and tell us .bcoz we can't find your screen.

what do you mean by specific text?

which db you are using? try to bind ddlArea in ddlCity_selectedindexChanged event by passing city id.If you provide more info we can help help you.

Can you provide more info about your problem? and please provide your code that what you have tried?

Can you provide you table design with sample data's,also please provide what o/p you are expecting?

This place is used to post solution,don't forget!

My +5

Thank you

Thanks for intimating me,forgot to set limit. Now i updated my solution

Dude It's an old question(crossed nearly more than 1 year), which is already have a solution.No need to reply now.

you need to create search box,it's ok? but what details you want to search? what you have tried? can you paste your code?

can you provide your table design with sample entries?

What you have tried? and where you have struck?

Reposting quetion will not provide you a good solution.Search it on google.

ok sir, i can understand.i'll take this on mind when posting next solution in CP. Thank you for the valuable advise.

Ok sir,let me continue my further solution with your suggestion. Thank you sir.

can u provide your full table stucture and sample data's? and pls provide your expecting output.

you're Welcome.

see the OP,your solution will provide output like this,
1493 3 A-307 1012 1 NULL NULL NULL NULL NULL
1493 3 A-307 1013 1 NULL NULL NULL NULL NULL
1493 3 A-307 1014 1 NULL NULL NULL NULL NULL
1493 3 B-405 1145 1 NULL NULL NULL NULL NULL
1493 3 B-405 1146 1 NULL NULL NULL NULL NULL

but he need like this stucture,

1493 3 A-307 1012 1493 3 B-405 1145
1493 3 A-307 1013 1493 3 B-405 1146
1493 3 A-307 1014

Thank you. Good one got solution.

Thank you.Got solution.My +5

Great! working good.This what i need.
using sql server it's fine,but i have one doubt,if i want to show next 45 days date what can i do?

Hi @King_fisher it's fine.but your solution shows output like this,
2014-11-15 18:05:07.143 1
2014-11-16 18:05:07.143 2
2014-11-17 18:05:07.143 3
2014-11-18 18:05:07.143 4
2014-11-19 18:05:07.143 5
2014-11-20 18:05:07.143 6
2014-11-21 18:05:07.143 7
2014-11-22 18:05:07.143 8
2014-11-23 18:05:07.143 9
2014-11-24 18:05:07.143 10
2014-11-25 18:05:07.143 11
2014-11-26 18:05:07.143 12
2014-11-27 18:05:07.143 13
2014-11-28 18:05:07.143 14
2014-11-29 18:05:07.143 15
2014-11-30 18:05:07.143 16
2014-12-01 18:05:07.143 17
2014-12-02 18:05:07.143 18
2014-12-03 18:05:07.143 19
2014-12-04 18:05:07.143 20
2014-12-05 18:05:07.143 21
2014-12-06 18:05:07.143 22
2014-12-07 18:05:07.143 23
2014-12-08 18:05:07.143 24
2014-12-09 18:05:07.143 25
2014-12-10 18:05:07.143 26
2014-12-11 18:05:07.143 27
2014-12-12 18:05:07.143 28
2014-12-13 18:05:07.143 29
2014-12-14 18:05:07.143 30
2014-12-15 18:05:07.143 31

but what i want is, dropdownlist should show next 30 days date from the date selected which means if i select 15/11/2014,then dropdown should start from 16/11/2014 and end with 15/12/2014 like this order,

2014-11-16 18:05:07.143
2014-11-17 18:05:07.143
2014-11-18 18:05:07.143
2014-11-19 18:05:07.143
2014-11-20 18:05:07.143
2014-11-21 18:05:07.143
2014-11-22 18:05:07.143
2014-11-23 18:05:07.143
2014-11-24 18:05:07.143
2014-11-25 18:05:07.143
2014-11-26 18:05:07.143
2014-11-27 18:05:07.143
2014-11-28 18:05:07.143
2014-11-29 18:05:07.143
2014-11-30 18:05:07.143
2014-12-01 18:05:07.143
2014-12-02 18:05:07.143
2014-12-03 18:05:07.143
2014-12-04 18:05:07.143
2014-12-05 18:05:07.143
2014-12-06 18:05:07.143
2014-12-07 18:05:07.143
2014-12-08 18:05:07.143
2014-12-09 18:05:07.143
2014-12-10 18:05:07.143
2014-12-11 18:05:07.143
2014-12-12 18:05:07.143
2014-12-13 18:05:07.143
2014-12-14 18:05:07.143
2014-12-15 18:05:07.143

sorry sir, i forgot to tag sql-server-R2-2008.Now i have updated my question.
and thank you for the link that you have provided here.

Good one. But some text error,you posted
SELECT DATEADD(MONTH,-1,GEDATE())
correct it to
SELECT DATEADD(MONTH,-1,GETDATE())
(just one "T" is missing in GETDATE() )

can u provide your table structure with some sample entries?

Hey @MohamedEliyas ,you are checking textbox text with your database values,but here the question is set to get validation to check all the textboxe's text should not have duplicate text.But he notice that similar text with exclamation mark (!) is allowed.So try to make correction in your solution.

what you are expecting,your question is not clear. your limit size is 10 but you are expecting output as only 8. here, what do you mean by "without break the words"

Good try.

You're Welcome.

+5

Good one.My +5
solution 1 from the link that you have provided is simple and good.

which application are you using as front end?

Refer solution1 from @Schatak for further clarification

if (e.Row.RowType == DataControlRowType.Footer)
{
Label WORKHRS1= (Label)e.Row.FindControl("WORKHRS1");
WORKHRS1.Text = grand_total.ToString();
}

In footer You are taking WORKHRS1 label,But Check the footer it consists of label which is named as lblTotalhours, so finding WORKHRS1 is not a right way.

Can you provide your table design?
Or Try to debug your code, check the rows value here ( int rows = cmd.ExecuteNonQuery(); )
You should get 1 in rows,bcoz here you are going to affect only one row. then change the condition like if (rows > 0)

Rather than use SELECT DISTINCT, use GROUP BY to get the sort order.
I have updated my answer, please check out

Thank you @King_Fisher

Thank You.

Try this,
int retryattempts = Convert.ToInt32(dr["retryattempts"].ToString());
instead of
int retryattempts = Convert.ToInt32(dr["retryattempts"]);

try to get that 10 id value from your gridview datasource,in (next or prev)button click event,use Response.Redirect() function ,here u can provide Details.aspx with id values . Then use query string on Details.aspx page to get all id values,here you can bind your new grid with id values.

thank you,let me try

Ok,thank you sir.

don't post it again,this will not clear to all. Go with your old question session and ask corresponding experts who helped you yesterday

U right but the question he mentioned that bed_code should be 1 or 2 , so using identity for bed_code will not provide correct solution.

Just find the child grid properly and bind it.

Ok sir,Thank You.

How u think substring(employeeId ,5 , 5) is possible for multiple entries,it will shows the same result for every repetition of execution. if the id is FHMS10001 means, the result will be 1+1=2 for every execution of this query.

Welcome.

My 5

Try Solution 1,
if (e.Row.RowType == DataControlRowType.DataRow)
{
for loop here
}

Thank You @Tadit Dash.

Okies, then Sorry.

Also you can try this in sqlserver,by passing condition dynamically

hi,@NaibedyaKar (Mindfire),
@Madhuri Gamane wrote code on ddlGodownName_selectedindexchanged, so checking AutoPostBack property in ddlGodownName is right way,not to check ddllvlno.

check your ddlGodownName AutoPostBack property is set to true.

Not clear with ur question.

check ur query and table,that no of columns in both query and table are matching not? sometimes ur temp table have 4 column,but u are calling 5th column from ur table.just debug and check it.

it may be leads to sql injection as refer from, http://www.w3schools.com/sql/sql_injection.asp

Is this the way of asking question? U didn't mention that where u have struck & what is the issue u got?

Thank u.

U welcome

ok then try Union Concept as Bruno Sprecher said,

bcoz only 2 projNr are matching. i cant get ur idea, be clear with ur question

How could u get 5 records? if you use inner join with projNr, u will get only 2 records.then how it is possible by using inner join?

You are right,i have provided same solution for multiple column,the question is not yet corrected.

try solution 3, if u are trying to do like that

not yet clear with ur needs,Based on my observation,U tried to bring out the subquery columns to upper select column so that i corrected ur query as per ur needs,i'm not sure that u are be clear with ur question.

Thank you,Aarif moh shaikh

Ur Query will provide o/p like this,
E3 S
E3 D
E3
E2 S
E2 D
E2
E1 S
E1 D
E1

But u didn't mention that u have multiple condition,arora_ankit solution is right for the question that u have provided here.

his task is not to copy the old table values to new table in another database.
the problem is,he copied,but path is not updated correctly in new database.

try solution 1

Welcome.

My +5

s i agree,but i tried this query with my table simultaneously,it works,i can understand sometimes there will be some issues.

r u lokking for both process shuold insert? or first five is inserting and next 8 is Updating?
U can do this easily,so many ex available,just google it

s right,then y don't u go with ("or") case

try solution 3

what u have tried?

what's your error? where u struck?

Post your code your question is not clear,where is your add button?Is it in gridview?

This is my Nested Repeater, Edit this Parent and Child Repeater as per your needs.
In my Repeater i have used 1 parent and 1 Child Repeater,if you need more than 1,you can add as per your needs.
It's seems like a Datalist.

Refer this link,
http://asp-net-example.blogspot.in/2008/12/aspnet-boundfield-example-how-to-use.html

I think it should be helpful to you?

i can't read your mind.post the code and tell where you struck?

Try this,

checkbox_id.Items.FindByText(dt.Rows[0]["marital_status"].ToString()).Selected = true;