Comments by Varun Sareen

Varun Sareen 14-Mar-23 1:24am View

Thanks Graeme. Appreciate your effort.

Regards
Varun

Varun Sareen 13-Mar-23 23:51pm View

Updated the question.

Varun Sareen 13-Mar-23 23:44pm View

It is not that what I meant. My bad for not adding much details. I have updated my question.

Varun Sareen 13-Mar-23 8:32am View

Hi,

I understand that GanttProvider reference is not found that is why the issue is coming. My query is not able to find the DLL which will help me resolve the issue. I searched on google but couldn't succeed.

Thanks

Varun Sareen 4-Jun-20 6:30am View

Thanks for the link(s) but i have already gone through them but it weren't of any help either.

Varun Sareen 4-Jun-20 3:50am View

ohh!!! why?

Varun Sareen 24-May-20 23:41pm View

Absolutely

Varun Sareen 20-May-20 5:56am View

I believe the credentials for DB are not correct due to which the connection is not being set. Kindly verify your DB credentials and they try again.

Varun Sareen 20-May-20 5:49am View

what have you tried so far friend?

Varun Sareen 22-Apr-20 12:37pm View

Ok Richard noted.

Thanks
Varun

Varun Sareen 19-Apr-20 8:13am View

ok thanks. But i assured that the file is actually not corrupted and the same code is running on different page.

Varun Sareen 27-Dec-19 4:54am View

No dear

Varun Sareen 28-Jan-19 7:02am View

thanks

Varun Sareen 21-Nov-18 4:40am View

I agree to what you have written on this but my requirement is like this only. I am not able to come up with a solution to this. Quiet frustrated till now. Thanks for the effort.

Varun Sareen 6-Jun-18 3:05am View

Why do you want to do this? If you can tell your problem then we can suggest better.

Varun Sareen 27-Apr-18 4:59am View

ok thanks..but i wanted atleast dont give him/her the option to right click on PDF in embed tag. If you can provide some solution, then please let me know.

Varun Sareen 14-May-17 1:11am View

Yes we can do as in bank sites for example.

Varun Sareen 13-May-17 23:54pm View

I respect your answer but have you ever tried the bank site in different tabs?

Varun Sareen 13-May-17 23:49pm View

I respect your answer but have you ever opened a Bank site with multiple tabs?

Varun Sareen 2-May-17 0:20am View

sorry dear, i have no idea in php language..but still if i found any solution; i will definitely get it back to you.

Regards
Varun

Varun Sareen 1-May-17 4:39am View

Try this:-

Select GroupID,SUM(CreditAllowed) [Sub Total],T.[Grand Total]
from Customer
Outer apply
(
Select SUM(CreditAllowed) [Grand Total] from Customer
) T
group by GroupID,T.[Grand Total]

Varun Sareen 3-Jul-16 7:53am View

yes i did the same. but now i got stuck with something else. I am sending a table to the response object so i am getting the data as required but as the table is rendered on the screen the moment i select the option from autocomplete then the table is shown in the text box rather only the data. could you help..??

Varun Sareen 3-Jul-16 4:49am View

that was for what i have tried, means i searched the net and found the above link as per my need but not able to execute the same with or without DB

Varun Sareen 3-Jul-16 4:30am View

that i know..but how to link the same with database is the problem.

Varun Sareen 13-Jan-16 7:11am View

What have you tried so far? And have you searched google?

Varun Sareen 5-Aug-15 5:33am View

I have tried everything in this link; but still not able to get the actual record count. In one of my page the same concept is giving the correct record count but when i am running in my current page it showing as -1.

Kindly refer the link:- http://www.geeksengine.com/article/recordcount-ado-recordset-vba.html

i have tried all what is specified in this link.

Varun Sareen 5-Aug-15 2:22am View

I have updated the question.

Varun Sareen 3-Jun-15 5:47am View

what you want to show then in the text box if not replacing the old value.?

Varun Sareen 3-Jun-15 0:34am View

have you searched google?

Varun Sareen 24-Apr-15 8:56am View

http://stackoverflow.com/questions/452004/c-sharp-configurationmanager-getsection-could-not-load-file-or-assembly

Varun Sareen 24-Apr-15 8:56am View

https://msdn.microsoft.com/en-us/en-en/library/2tw134k3.aspx

go to this link for correction

Varun Sareen 24-Mar-15 3:24am View

Don't repaet questions. the same you have posted two days ago.

Varun Sareen 24-Mar-15 3:19am View

http://www.codeproject.com/Articles/19752/WCF-WPF-Chat-Application

Varun Sareen 24-Mar-15 3:18am View

https://msdn.microsoft.com/en-us/library/vstudio/ms771542(v=vs.90).aspx

Varun Sareen 24-Mar-15 3:16am View

I am not been sarcastic dear. wait let me send you some of the best links

Varun Sareen 24-Mar-15 3:13am View

go for the link that i have sent you. Also MSDN and CodeProject are the best sites to get what you want.

Regards

Varun Sareen

Varun Sareen 24-Mar-15 3:08am View

Search google first

Varun Sareen 24-Mar-15 3:02am View

have you searched google for the same?

Varun Sareen 16-Mar-15 8:54am View

very nice link with complete details. I am accepting this as solution.

Varun Sareen 23-Jul-14 6:13am View

what have you tried so far?

Varun Sareen 25-Jun-14 9:38am View

Thanks Nathan, BTW I also found the same on some site..but cannot check here in office so will check at home.

Varun Sareen 25-Jun-14 6:58am View

Hiding the columns is not required dear friend. There is a functionality on Open XML of doing it that i know but how to do that i want to know.

Thanks
Varun

Varun Sareen 7-May-14 8:07am View

Dear Sanket,

This is what i require. The Session("BaseCurrency") to be initialized the moment the WebService gets a hit.

Regards

Varun

Varun Sareen 7-May-14 7:58am View

Added

Varun Sareen 7-May-14 7:58am View

added.

Varun Sareen 29-Apr-14 1:57am View

Deleted

This link might help you out in creating the dynamic controls.

http://www.codeproject.com/Articles/17269/Reflection-in-C-Tutorial

Varun Sareen 28-Nov-13 5:47am View

You will get answer to your question in the same. In one or two links i found the solution.

Kindly check and see if it is helpful.

Varun Sareen 27-Nov-13 23:40pm View

right

Varun Sareen 27-Nov-13 23:34pm View

what have you tried so far in it? And have you searched google for the same?

Varun Sareen 18-Oct-13 7:54am View

have you searched google?

Varun Sareen 18-Oct-13 7:51am View

Some error is coming or not??

Varun Sareen 10-Sep-13 4:44am View

Deleted

Thanks dear. Sorry to mention here the above code is working for Excel and PDF export.

Varun Sareen 10-Sep-13 4:41am View

Thanks dear. Sorry to mention here the above code is working for Excel and PDF export.

Varun Sareen 7-Aug-13 0:40am View

yes

Varun Sareen 10-Jul-13 7:49am View

Thanks rohan friend, But no help :(

Varun Sareen 10-Jul-13 7:17am View

no cookies. please give me some another solution. As i can't change my whole application. And do let me know how it can be done.

Varun Sareen 26-Jun-13 10:37am View

thanks dear

Varun Sareen 26-Jun-13 10:37am View

thanks dear

Varun Sareen 17-Jun-13 8:28am View

yes around 7000 or it could be more. The size of the file being generated is around 21 to 23 MB

Varun Sareen 6-Jun-13 2:04am View

where is the problem??

Varun Sareen 29-May-13 6:14am View

Please don't post same question again and again. Kindly use Comment section for your query.

Varun Sareen 29-May-13 0:37am View

your welcome dear

Varun Sareen 28-May-13 8:25am View

Dear Viva,

The column which you are saying is blank is not ta column. But yes if you want such column in your table then you need to define that column while making the table.

ALTER [TABLE NAME] ADD [COLUMN NAME] [DATA TYPE] [NULL]

Regards

Varun Sareen

Varun Sareen 28-May-13 8:19am View

Always comment if some one asks you some query regarding your question.

Varun Sareen 28-May-13 8:19am View

for given example2 at http://www.dotnetperls.com/datatable

if you see form1 cat and dog are 2nd and 3rd column header but 1st column header is blank.and that 1 st column only shows arrow at 2nd row and star at 4th row............ actully that 1st column is in grey color.

I do not want that blank 1st column...how to remove that or how to add text considering it is a 1st column.

thanks
viva

Varun Sareen 28-May-13 6:13am View

yea i got that dear that's why i said Good :-)

Varun Sareen 28-May-13 4:09am View

Good one dear but not the answer which the user is looking for.

Varun Sareen 28-May-13 4:08am View

5+

Varun Sareen 28-May-13 3:36am View

thanks dear Harsha

Varun Sareen 28-May-13 2:34am View

Please paste the actual code in which you are facing error.

Varun Sareen 28-May-13 2:30am View

Please give more clarity on this. And be specific, which datatable your are talking about?

Varun Sareen 28-May-13 2:30am View

Dear Mahnooosh,

Try to restart your VS.Net 2010 IDE or restart your PC again. It will get corrected.

Regards

Varun Sareen

Varun Sareen 28-May-13 2:05am View

Dear Harsha,

I have made the changes as per your request. Don't forget to mark this as your answer if your problem is resolved.

Regards

Varun

Varun Sareen 28-May-13 0:08am View

exactly the same i was trying to say 5!

Varun Sareen 27-May-13 8:18am View

what have you tried so far??

Varun Sareen 27-May-13 6:32am View

exactly David 5!

Varun Sareen 27-May-13 6:28am View

What is your requirement??

Varun Sareen 27-May-13 6:23am View

thanks anurag

Varun Sareen 27-May-13 6:23am View

why??

Varun Sareen 27-May-13 4:34am View

Okays dear i am glad that you got the answer though not from mine.

Varun Sareen 27-May-13 4:31am View

What is the length of return value of the string (code) which you are getting from the RandomNumberGenerator() method?

Varun Sareen 27-May-13 3:24am View

Please post some relevant code.

Varun Sareen 27-May-13 3:22am View

what have you tried so far in your question context? where have you stuck??

Search google first and then try yourself then when you face problem then let us know

Varun Sareen 27-May-13 3:20am View

Please post some relevant code here so that we can see what is wrong with your code.

Thanks

Varun

Varun Sareen 27-May-13 3:19am View

Dear Friend,

Before sending the code to bulk copy you can loop on the datatable rows for checking the Person column for numeric. if the person name is in numeric format then you can delete the concerned row from the datatable.

Regards

Varun Sareen

Varun Sareen 27-May-13 3:15am View

Dear Friend,

Your code seems fine to me. Have you checked the return value for your code through debugging? If not then kindly check it. If still the problem persists. Then reply to this.

Regards

Varun

Varun Sareen 27-May-13 2:56am View

Dear Kalai,

If you see all the links, there are links for win application also.

http://www.codeproject.com/Articles/23640/How-to-send-DataGridView-contents-by-email

My intention was to tell you that if you search google everything can be find out.

I hope that if you look at my link once again you will get the answer.

Regards

Varun

Varun Sareen 27-May-13 2:00am View

Deleted

Dear Friend,

What have you tried so far? Have you searched google for the same.??

Varun Sareen 27-May-13 1:25am View

Dear Friend,

As per your code it seems to me that you are doing the right way. For your clear understanding for the concept of sending a Mail from the girdview to email. I am posting an answer.

Kindly check.

Regards

Varun Sareen

Varun Sareen 27-May-13 1:16am View

Good answer 5+

Varun Sareen 27-May-13 1:14am View

Please state the question clearly.

Varun Sareen 24-May-13 5:06am View

Please post some data as to what you need to convert.

Varun Sareen 24-May-13 5:05am View

Search google.

Varun Sareen 24-May-13 0:32am View

yes it could be done dear friend. But have you searched for the topic on internet?

Varun Sareen 23-May-13 7:46am View

try to use the debug mode and see what actually is happening with your code. And you can take reference from this link:-

http://www.dotnetperls.com/sqldataadapter

Please let me know if it helps you out or not.

Varun Sareen 23-May-13 6:35am View

you have to search google for the same. If then you face problem then let us know. Still for your reference giving you the solution.

Varun Sareen 23-May-13 5:43am View

What error is coming?

Varun Sareen 23-May-13 5:38am View

try google. If not clear from there then post here your question elaborating it.

Varun Sareen 23-May-13 5:13am View

I couldn't get you here dear friend. Please elaborate.

Varun Sareen 22-May-13 3:16am View

Dear Friend,

Please let us know have you tried searching google for the same.?

Regards

Varun Sareen

Varun Sareen 20-May-13 7:15am View

thanks dear :-) its glad that you remember me.

Varun Sareen 18-May-13 8:36am View

i think the link below

http://www.trirand.net/examples/grid/treegrid/loadallrowsexpanded/default.aspx[^]

is the answer to the problem by you.

Nice answer JSM.

Varun Sareen 18-May-13 8:25am View

Deleted

can you please post some snapshot of the thing you want...i am not able top visualize what exactly you want to show or how to in data list or grid?

That will be helpful in giving you the answer.

Regards

Varun Sareen

Varun Sareen 17-May-13 2:17am View

May be the access to the folder at new path not have the privileges or permission.

Please try to give the permission to specified folder and then try it again.

Regards

Varun Sareen

Varun Sareen 17-May-13 2:15am View

have you tried something yet. The below link might help you out.

http://forums.asp.net/t/1414616.aspx/1

Regards

Varun Sareen

Varun Sareen 17-May-13 2:07am View

Have you tried something till now or have you searched google for the same?

Please try first then if you face some problem then post your problem here.

Regards

Varun Sareen

Varun Sareen 17-May-13 2:05am View

your welcome dear. Please don't forget to mark this as your answer if it helps you out.

Varun Sareen 17-May-13 1:46am View

what have you tried so far.? Have you tried searching google for the same.

Always try first then if you face some problem then post it here.

Regards

Varun Sareen

Varun Sareen 17-May-13 1:28am View

try to debug and see whether your dataset is getting filled or not.

Regards

Varun Sareen

Varun Sareen 17-May-13 1:25am View

try to fetch the data from database by using the "ORDER BY [Column Name]" clause where [Column Name] will be the name of the column according to which you want to filter the data and then bind the fetched data to the datagrid.

Thanks & Regards

Varun Sareen

Varun Sareen 17-May-13 1:05am View

gud reply :-)

Varun Sareen 1-May-13 2:44am View

Rohan Leuva 5+

Varun Sareen 24-Apr-13 8:35am View

thanks dear :-)

Varun Sareen 10-Apr-13 1:24am View

thanks dear Sergey for such a good explanation to my question.

Though i tried it myself and found the answer.

Thanks once again

Varun Sareen 4-Apr-13 1:42am View

Edo:- thanks

Varun Sareen 20-Jan-13 12:02pm View

thanks original griff I was expecting an answer from you only.

Regards

Varun

Varun Sareen 20-Jan-13 11:54am View

Thanks zoltan for your time..actually i was thinking also the same that there is no way to tackle this problem of working in disconnected environment as this is not feasible in this case as the outing may last up to several minutes.

Varun Sareen 22-Oct-12 3:19am View

Check security settings/permissions

Varun Sareen 22-Oct-12 3:17am View

What have you tried so far? Try to search google first

Varun Sareen 22-Oct-12 3:12am View

Is there some error prompt coming or what? Clean all the temporary file from your computer, restart the SQL server Engine and try to restore it again.

If it doesn't help then may be the DB which you are restoring is corrupt or may be the backup of your DB is not correctly done. So take another backup correctly and then try again to restore it.

Regards

Varun Sareen

Varun Sareen 22-Oct-12 3:09am View

All the DB's exist on the same server? If yes then you just have to add [DBNAME].dbo.[TableName] in order to fetch the data from different Databases.

And If DB's doesn't exist on the same server then in that case you have to use the Linked Server for extracting the data from different DB's in batch.

For more help in case of linked server. Search google.

Varun Sareen 22-Oct-12 2:59am View

Dear Friend,

In order to show the images from the database you can't put them into a dataset object as that works in disconnected mode but for a image data type (which is is a stream); you have to use the datareader object and then converting the byte form into image you can then bind it to your image control.

Regards

Varun Sareen

Varun Sareen 17-Oct-12 2:10am View

your welcome friend

Varun Sareen 9-Oct-12 6:57am View

what have you tried till now?

Varun Sareen 9-Oct-12 6:53am View

Search google

Varun Sareen 9-Oct-12 6:52am View

not a question. Have you not tried yourself? If not then first try and if you face problem then let us know :-)

Varun Sareen 9-Oct-12 6:51am View

please give more thing on this may be your table structure; so that we can make the same instance on our database in order to check whether your trigger in working correctly or not.

Varun Sareen 9-Oct-12 6:43am View

Please tell us your problem while running his code you are facing

Varun Sareen 9-Oct-12 6:41am View

you need it??? dear friend we are not here to do your homework or to do your task. We are here to help you resolve your problem. First attempt yourself then if you face problem then let us know.

Regards

Varun

Varun Sareen 9-Oct-12 6:40am View

not clear friend. Please elaborate on it

Varun Sareen 9-Oct-12 6:36am View

try to use a static variable by assigning the selected user id into it and then on the load event of using that static variable in the blocked form you can fetch all the details for that user id into the blocked page.

Varun Sareen 9-Oct-12 2:12am View

This link can give clear insight into what you are requiring:-

http://www.codeproject.com/Articles/31640/Basics-of-NET-Collections-in-C

Regards

Varun Sareen

Varun Sareen 9-Oct-12 2:11am View

this link might help you out:-

http://www.codeproject.com/Articles/31640/Basics-of-NET-Collections-in-C

Varun Sareen 9-Oct-12 1:36am View

not clear? what have you tried till now in this?

Varun Sareen 9-Oct-12 1:33am View

not clear :-) and what have you tried till now for this?

Varun Sareen 9-Oct-12 1:16am View

you cannot convert this string into two dimensional array. Try to put your question clearly here.

What is the issue your are facing?

Varun Sareen 23-Aug-12 2:03am View

true

Varun Sareen 22-Aug-12 1:21am View

have you tried this:- TextBox1.Text = "First line\r\nSecond line";

Varun Sareen 22-Aug-12 1:16am View

try to check the permission on the folder containing the file; I think the folder is not in share mode.

Varun Sareen 21-Aug-12 10:34am View

your welcome dear

Varun Sareen 21-Aug-12 7:24am View

Why are you looking for such functionality? Is this is your project requirement or what?. Please tell us about your actual requirement that why you require this.

Thanksq

Varun Sareen 21-Aug-12 7:14am View

true

Varun Sareen 21-Aug-12 7:13am View

Explain your query in brief..!!

From: Jitu8187

Varun Sareen 21-Aug-12 7:12am View

Always put your comment in comment section not in solution dear Jitu. I am adding your query in the comment. Please delete your comment from here.

Varun Sareen 21-Aug-12 7:06am View

Do you want to bind columns at design time to the two columns? Is that so?

Varun Sareen 4-Jun-12 1:15am View

have you tried debugging in this case??

Varun Sareen 4-Jun-12 1:09am View

what error is coming?

Varun Sareen 1-Jun-12 5:06am View

thanks amit..i found one solution to it. Working on it :-)

Varun Sareen 27-Apr-12 1:25am View

thanks

Varun Sareen 26-Apr-12 1:05am View

Reason for my vote of 1
not a question

Varun Sareen 26-Apr-12 1:05am View

Do you want us to do you homework?? is that so?? If yes then this is not the forum for you :-)

Varun Sareen 26-Apr-12 0:50am View

Read Book by BalaGuruSwamy for OOPS

Varun Sareen 25-Mar-12 20:47pm View

what error?

Varun Sareen 22-Mar-12 5:06am View

have you tried google before posting your question here?

Varun Sareen 20-Mar-12 4:57am View

Reason for my vote of 5
nice

Varun Sareen 19-Mar-12 0:04am View

have you tried something? what table; a DATATABLE or dB Table

Varun Sareen 12-Mar-12 0:32am View

show us the error

Varun Sareen 9-Mar-12 0:31am View

I think you have to close the connection each time you open it and dispose of the connection object. Your problem will be solved :)

Varun Sareen 8-Mar-12 22:54pm View

my 5: nice alternative

Varun Sareen 8-Mar-12 22:54pm View

my 5: good explanation :)

Varun Sareen 8-Mar-12 22:53pm View

dear SAKryukov, the person has asked just that how to remove some of the characters from a string. So we gave him that solution. We know that strings are immutable and also the question is not about the performance factor here, its about to solve the problem OP has asked. If it would have been about the performance then i would have gone with your answer :).

I am not trying to say that you are wrong or something else as you are senior to me but i am saying that i am also not wrong :)

Varun Sareen 5-Mar-12 23:07pm View

correct

Varun Sareen 5-Mar-12 8:01am View

http://www.codeproject.com/Answers/340490/hi-how-to-import-sql-table-data-to-excel-sheet-in#answer3

Already answered

Varun Sareen 5-Mar-12 7:59am View

edit for: added pre tag

Varun Sareen 5-Mar-12 7:51am View

Please post some code

Varun Sareen 5-Mar-12 7:46am View

there must be some error your are facing...show us the error..otherwise the things will work

Varun Sareen 5-Mar-12 7:34am View

Please always do google search first and then try something and then when you face problem then post your question here

--Trying is to believing yourself...

Varun Sareen 5-Mar-12 7:28am View

your question is confusing? do you mean how to export sql data to excel sheet?

Varun Sareen 5-Mar-12 7:24am View

have you tried google?

Varun Sareen 5-Mar-12 7:23am View

Edit For: Removed unused bold tag

Varun Sareen 5-Mar-12 7:21am View

edit for: added pre tag

Varun Sareen 5-Mar-12 6:10am View

your welcome tushar

Varun Sareen 4-Mar-12 23:01pm View

not clear

Varun Sareen 4-Mar-12 22:59pm View

what error?

Varun Sareen 3-Mar-12 10:17am View

yea sathish :) i will take care from now

Varun Sareen 3-Mar-12 2:59am View

STARTTLS is a sendmail command to initiate a secure connection. So it looks like you need to do one of those.

Varun Sareen 3-Mar-12 2:53am View

edit for: removed pre tag

Varun Sareen 3-Mar-12 0:57am View

have updated my solution please check and see if it can help.

Varun Sareen 2-Mar-12 1:15am View

more code

Varun Sareen 2-Mar-12 0:46am View

have you searched google?

Varun Sareen 2-Mar-12 0:45am View

Edit For: Added pre tag

Varun Sareen 2-Mar-12 0:17am View

Dear Friend, you have to fill the data into your source table in order to copy the same into the destination table

Varun Sareen 2-Mar-12 0:16am View

where on earth such people exists :(. Please elaborate where are you facing problem. Please be more clear about your question

Varun Sareen 2-Mar-12 0:09am View

have you tried google? and why do you require it by query?

Varun Sareen 1-Mar-12 23:55pm View

try debugging. Is some error coming!!!?

Varun Sareen 1-Mar-12 23:53pm View

not a feasible approach. Please elaborate more on your problem :). May be we can provide you an alternate option.

Varun Sareen 1-Mar-12 23:44pm View

i have updated my solution.

Varun Sareen 1-Mar-12 3:54am View

are you getting any error?

Varun Sareen 1-Mar-12 3:49am View

Couldn't get you what you are trying to say but actually what i have understood from your explanation that the data is not getting filled up in the datatable and so it is not able to bind the combo box.

May be you are trying to fetch a column which is not present in the database or trying to bind a database column which you have not specified in the design time with the control :)

Try to correct that.

Varun Sareen 1-Mar-12 3:46am View

Search google, then try yourself and then when you face problem ask here

Varun Sareen 1-Mar-12 3:38am View

have you tried google?

Varun Sareen 1-Mar-12 3:35am View

Please check your function/method:-FetchCustomerType(), whether it is returning value or not.

Varun Sareen 1-Mar-12 3:29am View

not clear

Varun Sareen 1-Mar-12 3:28am View

absolutely right

Varun Sareen 1-Mar-12 3:27am View

always try google search dear.

Varun Sareen 1-Mar-12 3:24am View

Where are you stuck dear?

Varun Sareen 1-Mar-12 1:50am View

thanks espen

Varun Sareen 29-Feb-12 1:14am View

I am not able to get you sir. Please elaborate what you want to say?

Varun Sareen 29-Feb-12 1:12am View

edit for: removed unused pre tag

Varun Sareen 29-Feb-12 0:43am View

always search google first dear friend

Comments by Varun Sareen (Top 200 by date)