Comments by bluesathish

bluesathish 6-Apr-16 10:44am View

assign this validationGroup="cats" into your button control's property.

bluesathish 20-Jan-15 3:49am View

I'm just post the sample code, you just go through it. Learning is the first step to becoming master of a specified field. So just try it by yourself. :-)

bluesathish 20-Jan-15 2:09am View

check the link I've posted in my updated solution. Hope it'll help you.

bluesathish 14-May-14 3:18am View

Yes Nicholas was correct, Check my solution No:4.

bluesathish 14-May-14 3:12am View

Your question was not clear, use improve question option to update your question along with your error details.

bluesathish 12-May-14 6:09am View

Firewall port should open between the Gmail server and your server. Go to command Prompt and type telnet 192.168.0.99 25, Then if you get blank screen you've the firewall else port should be open.

bluesathish 30-Apr-14 6:22am View

No no, my solution was not well enough i agreed that. I'm looking forward the solution from others/you, thats what i mentioned it in comment.

bluesathish 30-Apr-14 6:20am View

Thumbs Up :-)

bluesathish 30-Apr-14 6:16am View

Yes, but the OP problem is different. Read carefully, He wrote "when i click button the Page is Getting Post back to top of the page.its look terrible.how do i solve this " This happends in Gridview, i think he has the big gridview in his page or his page contains only a gridview!

bluesathish 30-Apr-14 6:05am View

Did you give permission to that page for the user IIS_Users?

bluesathish 30-Apr-14 5:49am View

This is not a solution he is looking for, its better to keep away(omit question) instead of posting a comment like this.

bluesathish 22-Apr-14 2:06am View

Did you use RDLC reports?

bluesathish 19-Apr-14 0:40am View

Yes, its restricts Ctrl+S in IE 7.

bluesathish 19-Apr-14 0:37am View

Is my solution 3 meets your requirements?

bluesathish 17-Apr-14 6:51am View

Its working well in IE, you need to check for the rest of the browsers.

bluesathish 17-Apr-14 6:41am View

Hi SA, there is a solution for this questioner! we can use the javascript to disable the menus. Check my solution.

bluesathish 17-Apr-14 6:10am View

Use inner join instead of left join, since you're using left join, you'll get the results from left table ie., your Preg_cohort3 table.

bluesathish 17-Apr-14 6:02am View

Post your codes using improve question option!, here its difficult to read.

bluesathish 17-Apr-14 5:45am View

Post the two table's sample data along with its columns as a tabler representation, then we can able to help you.

bluesathish 17-Jan-14 8:42am View

Thank you so much. :-)

bluesathish 17-Jan-14 8:19am View

If you're using default login control in your asp.net application it'll fetch the current system login name. So you should check with your web.config file. Else post your web.config, we'll try to help you.

bluesathish 1-Jan-14 5:30am View

Thanks for your suggestion, i'll check it out and revert you.

bluesathish 1-Jan-14 5:20am View

LDAP server located in one location, we've the connection to connect it for authenticate users using their domain.

bluesathish 19-Dec-13 8:46am View

Have you tried to use different application pools for those two applications in IIS?

bluesathish 19-Dec-13 8:38am View

Have you include runat="server" property in your checkbox?

bluesathish 19-Dec-13 8:35am View

Go to administrator login and giving its rights to the user you want.

bluesathish 19-Dec-13 4:28am View

Increasing the width of the page was not a good thing to do, the idea page has the fixed width and the n-size of height. so your website should go with vertically(in user point of view) rather than horizontal.

bluesathish 19-Dec-13 4:09am View

Thank you, I've posted the same as a Solution.

bluesathish 19-Dec-13 4:07am View

Yes Thanks @Bill.

bluesathish 19-Dec-13 2:30am View

Go through this link you'll get some idea,
http://stackoverflow.com/questions/2584680/wcf-define-multiple-services-in-a-single-app-config-file

bluesathish 13-Dec-13 7:16am View

Then what else you got? post the errors using improve question option!

bluesathish 3-Dec-13 2:10am View

Then your error got resolved?

bluesathish 29-Nov-13 23:35pm View

Post the Exception details clearly using improve question option!

bluesathish 29-Nov-13 5:22am View

Thank you so much. :-)

bluesathish 29-Nov-13 5:15am View

I think your sql command string was the problem, sometimes calendar control cause this error, In your code Calendar332.SelectedDate done this (my guess). Try to check the selecteddate value before you assigning it in a sqlcommand string.

bluesathish 29-Nov-13 4:09am View

Try to add reportViewer1.DocumentMapCollapsed = True before reportViewer1.RefreshReport();

bluesathish 29-Nov-13 1:47am View

No you've to create Dataset file(xsd) file before assigning your dataset. ie., rdlc report = dataset(xsd) + reportviewer. Post your codes in question section by using improve question option.

bluesathish 29-Nov-13 1:45am View

Have you tried to get your active directory records into datatable? if you can, assigning that datatable to your rdlc report datasource. But make sure you've create a dataset(xsd) file before.

bluesathish 25-Nov-13 7:39am View

so you want to add embedded images in base64 format right?

bluesathish 20-Nov-13 2:32am View

Post your codes, so that we can analyze what causes this error!

bluesathish 20-Nov-13 2:27am View

Have you tried to append your lines (using some writer methods) before export the data from datatable?

bluesathish 14-Nov-13 5:44am View

Yes you can create procedure instead of function, by assigning your output to the refcursor variable and returning it as a output variable.

bluesathish 13-Nov-13 5:36am View

Change all px value into interm of % values. for (ex) style .stripe
{
width: 100%;
height: 25%;
}

bluesathish 13-Nov-13 5:17am View

Have you place script manager before the update panel?

bluesathish 13-Nov-13 2:12am View

My vote +5.

bluesathish 13-Nov-13 2:10am View

Try this, In your IIS application pool -> Goto advanced property -> set enable 32 bit application to True. Defaultly its set to false. Try this and revert.

bluesathish 13-Nov-13 1:54am View

@Vishal: update panel does postbacks partially. But it doesn't postback the entire page, so the redirection looks not happened but it does.

bluesathish 11-Nov-13 8:37am View

Is there three tab panels available? If No, try to change the property ActiveTabIndex="0" and revert.

bluesathish 7-Nov-13 0:03am View

You can use Count(ur_column_name) instead of count(*). Here ur_column_name is any unique indexed column for your table, it'll retreived quickly.

bluesathish 31-Oct-13 5:17am View

Try to Update Service Reference from Solution explorer of your project, then deploy this updated files in IIS and Restart the IIS.

bluesathish 31-Oct-13 3:23am View

Whats the error you've got? How did you check that your sessions are disappeared?

bluesathish 31-Oct-13 3:17am View

what is the runtime value you're getting ReportFileName variable?

bluesathish 31-Oct-13 3:12am View

Have you check your firewall port is enabled? Try this step go to cmd prompt, type telnet smtp.webmail.itfusion.in 25 and press enter then you may get like empty screen or smtp message. If not shown like that then check open port for the same too.

bluesathish 30-Oct-13 6:16am View

You should open the Firewall port(user defined) to access your WCF service which is hosted in IIS.

bluesathish 30-Oct-13 6:12am View

@SA :-D :-D

bluesathish 30-Oct-13 6:09am View

Yes, this is a right solution for this case.

bluesathish 26-Oct-13 1:46am View

Whats the problem you've facing? can you post your errors by using your improve question section.

bluesathish 26-Oct-13 1:26am View

I think this is what the enquirer need, good.

bluesathish 26-Oct-13 1:23am View

Great solution Griff, superb explanation. :-) My vote +5.

bluesathish 9-Oct-13 9:15am View

I got some results from google search, go through the following links you'll get some ideas,
http://avinashsing.sunkur.com/2011/07/11/give-write-permission-to-worker-process-on-iis-7/
http://stackoverflow.com/questions/16677887/how-to-set-correct-file-permissions-for-asp-net-on-iis
http://forums.iis.net/t/1173065.aspx

bluesathish 9-Oct-13 0:09am View

:-D :-D, your reply itself indicates how much experience you've got, (you've joined just 11months before in this codeproject :-D)

bluesathish 8-Oct-13 8:45am View

Yes you've to give the full control rights permission for "Network service" becas in IIS, requests are running as a worker process so u've to give the rights for the same.

bluesathish 8-Oct-13 8:43am View

To Rohan@;
Dont scold others, Even you also one of the beginer of sometime for some new technologies, better you try to skip the question which you dont want to give the solutions. ;-)

bluesathish 8-Oct-13 8:42am View

Deleted

Dont scold others, Even you also one of the beginer of sometime for some new technologies, better you try to skip the question which you dont want to give the solutions. ;-)

bluesathish 7-Oct-13 7:32am View

Thank you, i've posted my comment into the solution section for your question.

bluesathish 7-Oct-13 5:08am View

Ok, how did u check that your Bios timing is different from OS timing?

bluesathish 7-Oct-13 4:48am View

OG is correct. The system timing and the bios timings are same.

bluesathish 7-Oct-13 4:45am View

Try this, Go to Build menu and Click clean solution and Click Rebuild solution.

bluesathish 7-Oct-13 3:15am View

Try to Click the reference from Solution explorer and press delete button from your keyboard. I'm not sure this is available in VS2008, since i'm using vs2010. Jusy try and revert.

bluesathish 7-Oct-13 2:32am View

Go through the below link, u'll get some ideas.
http://stackoverflow.com/questions/11229582/will-web-deployment-projects-still-be-available-in-visual-studio-2012

bluesathish 7-Oct-13 2:26am View

Try to improve your question!

bluesathish 7-Oct-13 2:20am View

@SA, Good thinking SA :-)

bluesathish 7-Oct-13 2:12am View

Go to Solution explorer and remove all 'Microsoft.ReportViewer.WebForms references. Then Add the references from your latest directory (VS2008). Go to Build menu and Click clean solution and Click Rebuild solution.

bluesathish 7-Oct-13 2:05am View

Deleted

try to add First(Fields!busno.Value) instead of Fields!busno.Value

bluesathish 3-Oct-13 1:08am View

Page report!, what do you mean to say?

bluesathish 30-Sep-13 3:47am View

create a index on designation column would reduce the retreiving time.

bluesathish 30-Sep-13 3:46am View

Bind your datas in Gridview.

bluesathish 30-Sep-13 3:40am View

@OriginalGriff, Good solution griff keep it up. :-) My vote 5!.

bluesathish 27-Sep-13 4:18am View

if my control is a checkboxlist then you're code will works?

bluesathish 27-Sep-13 4:16am View

@CRDave1988:
The link you're provided was not found Mr.Dave (may be its considered to be a older post), One one more thing google result came based on several scenarios like user frequently searched tags and may vary by location you're searching. My vote 0!, oops 0 was not available ;-) Take 1!. :-)

bluesathish 24-Aug-13 2:34am View

can you post the exception details? so that we can able to solve ur problem.

bluesathish 19-Aug-13 2:34am View

Its seems to be your framework corrupts, Reinstall Framework and try again.

bluesathish 19-Aug-13 2:21am View

I've post all the possiblities i knew, If the url asking credential for the particular user then it seems to be some configuration problem in that user's pc, check that out.

bluesathish 19-Aug-13 1:36am View

Is my posted solution is not a solution you looking for?

bluesathish 16-Aug-13 9:14am View

I'll check it and revert you. Thanks for help ryan, i really thankful to you. :-)

bluesathish 16-Aug-13 9:03am View

I've tried that too. Its also having the same problem.

bluesathish 16-Aug-13 9:00am View

so you mean to say i've to remove ~ symbol from property as follows FolderUrl="/Images/Events/"
isn't it?

bluesathish 16-Aug-13 8:56am View

Thats fine, its privacy i know. Thanks.

bluesathish 16-Aug-13 8:55am View

have u got any idea about this error in that control i've posted?

bluesathish 16-Aug-13 8:50am View

Add the application url in proxy settings exception list and try.

bluesathish 16-Aug-13 8:47am View

can you share your email id? i can send my error snapshot for your reference.

bluesathish 16-Aug-13 8:46am View

It doesn't shows any error lines, but it throws inner exceptions from one component called Notes.For Gallery tool in which i mentioned image path to display images as a Thumbnail view. The following code for your reference,
<cc1:Gallery ID="Gallery1" runat="server" FolderUrl="~/Images/Events/" AlbumTitle="Photostream" ImageText="Photo" Size="150" Width="100%" />

bluesathish 16-Aug-13 8:26am View

I thought i've missed something in Virtual directory configuration part. Because the same configuration works great if i configured as a website. could u help?

bluesathish 16-Aug-13 8:22am View

it shows the errors(when i browse through virtual directory) with the header as like i mentioned the last posted comment.

bluesathish 16-Aug-13 8:19am View

If you use IE, then go to internet options in IE tools menu, then disable proxy settings from Connection->LAN Settings menu. Try this and revert. (May be the user trying to connect the application through proxy).

bluesathish 16-Aug-13 8:17am View

No problems with database connection. I thought i've missed something in Virtual directory configuration part.

bluesathish 16-Aug-13 8:16am View

I didnot got any errors and browse successfully if i browse the page from website in IIS, but I got the below error when i browse the page from virtual directory
"StartIndex cannot be less than zero. Parameter name: startIndex".

bluesathish 16-Aug-13 6:59am View

Check your proxy settings in that user's system(internet options) whome the system ask for the credentials.

bluesathish 20-Jul-13 1:07am View

Try to enable Gridview paging. And allow page size is equal to your required number of rows to be displayed.

bluesathish 10-Jul-13 6:08am View

Don't post your credential here, actually it doesn't need. ok, what is the backend you're using? oracle, sql server or something else?

bluesathish 13-Jun-13 2:02am View

its a component provided by ajaxcontrol toolkit for calender control.@SA

bluesathish 13-Jun-13 1:58am View

Its possible only if we export the rdlc report result to excel file, while at the runtime rdlc report is not allow the user to edit its contents.

bluesathish 13-Jun-13 1:47am View

you asking how to display the rdlc report to another(new) form, isn't it?

bluesathish 13-Jun-13 1:44am View

Set the AutoPostBack="true" in tab container property.

bluesathish 11-Jun-13 8:21am View

whether the service is displayed get method when its browsed in IIS?

bluesathish 11-Jun-13 8:17am View

how do u pass the datasource for rdlc report, whether it is a datatable from frontend or what?

bluesathish 11-Jun-13 8:15am View

post your selected index change event code. Then only we can identify the issue.

bluesathish 11-Jun-13 8:12am View

check out the link http://forums.asp.net/t/1884671.aspx/1

bluesathish 11-Jun-13 7:16am View

Good work :-) @Bernhard

bluesathish 11-Jun-13 7:13am View

Its possible only at design time, RDLC report will not automatically merging horizontally at runtime.

bluesathish 11-Jun-13 7:01am View

Good Comment :-) @OriginalGriff

bluesathish 30-Apr-13 1:39am View

Hi Sergey, I've posted the following question 4 days before, but still i didn't got any responses, will you help me? link is below http://www.codeproject.com/Questions/583411/HostingplusWindowsplusWCFplusServiceplusinplusIISp

bluesathish 25-Apr-13 10:09am View

OfCourse you're right, you should probably post that in the comment section rather than the solution. Thats what i'm commenting like that. :-) @SA.

bluesathish 25-Apr-13 8:57am View

This is not a solution buddy :-) @Sergey Alexandrovich Kryukov

bluesathish 10-Apr-13 5:28am View

Good suggestion @ OriginalGriff.

bluesathish 10-Apr-13 5:25am View

Deleted

Are you initialize your datatable before? else try to initialize as below
DataTable dt = new DataTable();
dt = dbClass.ConnectDataBaseReturnDT(getUserScraps);

bluesathish 10-Apr-13 4:40am View

post your full exception details.

bluesathish 26-Mar-13 4:57am View

Sorry i've shares all the possiblities from my knowledge, you can search for the alternatives.

bluesathish 25-Mar-13 5:14am View

Check this out too
http://social.msdn.microsoft.com/Forums/en-US/wcf/thread/23c28d52-4a42-4785-970e-dd77c5c64f1d

bluesathish 25-Mar-13 5:04am View

Check this out
http://www.codeproject.com/Articles/169928/WCF-Service-returns-400-Bad-Request

bluesathish 25-Mar-13 4:01am View

have you tried, i'm looking fwd your reply.

bluesathish 25-Mar-13 3:14am View

Your appconfig was the problem, i found where you're missing and i posted the solution. check it out.

bluesathish 25-Mar-13 3:14am View

Deleted

Your appconfig was the problem, i found where you're missing and i posted the solution. check it out.

bluesathish 25-Mar-13 2:47am View

I thought your parameters in webconfig are fine. Everything has some limits, if you upload beyond the limit of the acceptable size means how the system can able to handle that? so my point is better you try to compress your inputs if it thorws errors.

bluesathish 25-Mar-13 1:43am View

what kind of data you're uploading? whether it is a block of records to be inserted into the table or what?

bluesathish 22-Mar-13 6:09am View

do you got any errors while upload large files? if yes, what it is?

bluesathish 28-Feb-13 9:06am View

finally i remembered the solution, when i got this same kind of problem. This time i got the solution as follows, Goto build->clean solution then Again goto Build->Rebuild solution. Then i successfully run the application. Hope this will help you. i posted this same as a solution below. Regards,Bluesathish

bluesathish 16-Jan-13 7:09am View

hi aarti, alluvialdeposit's solution was almost meet my needs. Thanks for your sharing too.

bluesathish 16-Jan-13 7:06am View

Deleted

I've fixed the above error with myself by addinig the reference DocumentFormat.OpenXml.dll in my solution. Thanks much alluvialdeposit.

bluesathish 16-Jan-13 7:05am View

I've solved the above error with myself, for this above error we've to add another dll file DocumentFormat.OpenXml.dll into our solution.
Thanks much alluvialdeposit.

bluesathish 16-Jan-13 5:10am View

My source code was:
Private Sub DataTableToXLSX(ByVal dt As DataTable)
Try
Dim wb As New XLWorkbook()
wb.Worksheets.Add(dt, dt.TableName.ToString)
wb.SaveAs("E:\" + dt.TableName.ToString() + "xlsx")
Catch ex As Exception
MessageBox.Show(ex.ToString())
End Try
End Sub

bluesathish 16-Jan-13 5:09am View

hi alluvial, I've tried your idea by using closedxml concept, but i got the following error
System.TypeInitializationException was caught
Message=The type initializer for 'ClosedXML.Excel.XLWorkbook' threw an exception.
Source=ClosedXML
TypeName=ClosedXML.Excel.XLWorkbook

Plz help me.

bluesathish 28-Dec-12 6:15am View

thanks for your reply sampath, but your code returns ORA-01722: Invalid number error. any idea about this?

bluesathish 5-Sep-12 7:04am View

Two months before i've came across this same kind of error, then i did something like i've mentioned above, actually i've forgot what i did. But I'm sure its not happends due to rights privilages, ok try this last chance, Close your solution and Reopen it and then Build your solution, make sure you clear all temp files before you Reopen the solution.

bluesathish 5-Sep-12 6:51am View

ok then, clear all temp files in your system and Rebuild the solution.
For go to temp folder, Start -> Run -> %temp%.

bluesathish 5-Sep-12 6:46am View

Deleted

Try this, Goto Build menu and click "Clean Solution", then Click "Build Solution".

bluesathish 5-Sep-12 6:44am View

Deleted

Try this, Goto Build menu and click "Clean Solution", then Click "Build Solution".

bluesathish 5-Sep-12 6:43am View

Try this, Go to Build menu then click Clean solution, And then click Build solution.

bluesathish 31-Jul-12 0:41am View

yes, that he should realize that. Thanks for your comment...

bluesathish 27-Jul-12 7:13am View

did you try it while runtime? if no, try that you can definatly assign the breakpoint.

bluesathish 26-Jul-12 6:46am View

I agree with you :D, take 5! for your solution.

bluesathish 26-Jul-12 6:32am View

If you think this question is wasting your time means, you no need to answer for this. You're looking for points by posting solution,this is not fare.

bluesathish 26-Jul-12 6:10am View

@OriginalGriff: If you think this question is wasting your time means, you no need to answer for this. This will discourage somebody to posting their doubts.

bluesathish 25-Jul-12 6:36am View

Post your web.config entries, Let me check. This error may be occured due to the binding settings.

bluesathish 25-Jul-12 6:26am View

great! keep it up... sharing our experiences is a great thing, thanks to codeproject team

bluesathish 25-Jul-12 5:44am View

Its not possible to call the methods without the service reference, the purpose of Service is to provide the necessary functionality whenever it gets referenced, thats why Visual studio have the Service Reference option if the solution explorer.

bluesathish 25-Jul-12 3:41am View

have 5pt aarti!

bluesathish 23-Jul-12 7:48am View

This Microsoft.Office.Interop.Excel path will be available only if we install Msoffice, otherwise we don't have the path like this.

bluesathish 23-Jul-12 7:29am View

Deleted

i think its need Microsoft Excel COM reference.do u have any idea about this error?

bluesathish 23-Jul-12 7:25am View

thanks allu, i'll try this.

bluesathish 23-Jul-12 7:18am View

This is the error i've got while runtime
"Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154."

bluesathish 23-Jul-12 7:11am View

its successfully added to my project, but it needs Microsoft Excel COM reference. I got runtime errors.

bluesathish 23-Jul-12 7:06am View

yes, its not meet my needs.

bluesathish 23-Jul-12 7:05am View

Hi Aarti, Thanks for your reply,i don't have the excel in my pc. (read question clearly before you posting your solutions) Can you give me the idea to use by open office assemblies?

bluesathish 23-Jul-12 6:55am View

ok But i've Open Office software, how can i use its assemblies to export?, we usually doing using Microsoft.Office.Interop, in Open office do we've similar assemblies to do the same?

bluesathish 23-Jul-12 6:43am View

Hi AlluvialDeposit,
thanks for your reply, but i want to export it into .xls file only and also i dont want to add any external component like this ClosedXml, Is there any possibility to do this by vb.net codings?

bluesathish 25-Jun-12 7:23am View

post your question clearly.

bluesathish 18-Apr-12 1:03am View

Thanks nelek, I knew the oracle commands to do that, i need a vb.net solution to do the same. Can u give idea for that?

bluesathish 9-Mar-12 4:59am View

i think me and ganesansenthilvel posted the same at a same time, thats why i delete my posted solution.

bluesathish 9-Mar-12 4:45am View

nice, take 5!

bluesathish 9-Mar-12 4:38am View

Reason for my vote of 3
Need more explanation of your codes.

bluesathish 8-Mar-12 7:02am View

You can use, gridview rowediting event.

bluesathish 4-Mar-12 23:30pm View

Thats Good, thanks. :)

bluesathish 2-Mar-12 0:20am View

Don't post your comment like this, look his reputation points. He may be the beginner of this site, he may doesn't know how to post the question. so you can give your suggestion instead of discouraging like this.

bluesathish 1-Mar-12 8:13am View

good, Get 5 thatraja!

bluesathish 29-Feb-12 7:46am View

I thinks its no need, But make sure that you're using the licensed visual basic 2010 ultimate to develop your software.

bluesathish 29-Feb-12 7:13am View

post your question clearly.

bluesathish 7-Feb-12 0:01am View

good, all the best.

bluesathish 12-Jan-12 5:38am View

Hi manisha,
Refer this article, it'll give you some idea about how to tune the queries.

http://www.dba-oracle.com/art_sql_tune.htm

bluesathish 10-Jan-12 23:51pm View

Deleted

No, actually I didn't work with LINQ. But few months before i did the code which was the insertion of more than 50 lacks records to my sql server database from the vb.net Datatable, I've tried with basic for loop and insert the records one by one, on that time i've got timeout error. so I searched for the alternative and finally i got this sqlbulkcopy method as a better one for code.

bluesathish 5-Jan-12 23:11pm View

hi vinay,
Thanks, i knew that you've made a mistake in string concatenation, thats why i keep indicating the same. Happy coding.

bluesathish 4-Jan-12 1:57am View

I'm just say it as an example to understand the usage of format method. Its not the matter you should use it only in where clause. the oledbcommand sholud be given as a string thats it. you can try this else search for the alternative.

bluesathish 4-Jan-12 1:43am View

hi vinay,
Format()method returns values as string, so while you use it in your oledbcommand string it should be like this "select from table where" & Format(exp, "dd/MM/yyyy") & "". That is you should add concatenate operator(&/+) before the format() method. Hope it'll help to you.

bluesathish 4-Jan-12 1:26am View

Hi vinay,
I think you've fail to pass the aftnam/aftdob parameter's values at runtime. Debug your program and watch its runtime values.

bluesathish 3-Jan-12 23:41pm View

yeah, its a good idea.but what is the upper limit to be given for the progress bar, because each time the SP returns different results.

bluesathish 3-Jan-12 5:35am View

dear Vinay,
Check this link.,
http://stackoverflow.com/questions/203807/csv-date-format-vba

bluesathish 2-Jan-12 7:16am View

Hi Raimis9,
Thanks for your reply, I knew about it. But my problem is i've to show the progressbar blocks while the procedure runs, it should gets its maximum when procedure returns the results. Can you give idea for this?

bluesathish 2-Jan-12 5:06am View

Hi synctor,
Check this link, it may helpful to you, http://stackoverflow.com/questions/6438079/hide-columns-dynamically-in-rdlc-report

bluesathish 31-Dec-11 1:12am View

Then try this one,
DataView view = new DataView(table);
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...);

ref: http://stackoverflow.com/questions/1199176/how-to-select-distinct-values-from-datatable

bluesathish 31-Dec-11 1:05am View

Hi devausha, Instead of assigning dataset to the reportdatasource, just try to do by adding reportdatasource.add() method. Which means, write the for loop as initialize one loop variable to 1 untill the dataset's tables count. And by calling the add() method you can assign the datasource one by one. Hope this will be helpful.

bluesathish 30-Dec-11 4:52am View

Hi dinesh,
Yes, I think you've to set the data source BEFORE you add the parameters. So First the set the datasource to the report and then set the parameters to pass.

bluesathish 30-Dec-11 4:07am View

Hi dinesh,
"MISSING PARAMETER VALUES" means you didn't pass the parameter value which you created in your report. Just verify that every parameters have got their curresponding values at runtime.

bluesathish 27-Dec-11 23:03pm View

Deleted

hi Member 8345599, You can use this oracle procedure results to the VB.NET by calling it. Thats why i put VB.NET tag too. Thanks for your comment. Regards, Bluesathish

bluesathish 24-Nov-11 7:47am View

oh ok thanks, then can you guess what will be the max file size if i run the application on the machine which has 2GB RAM, 2.85Ghz Processor and More than 5GB Page file Size.

bluesathish 24-Nov-11 7:40am View

Thanks for your reply, I dont want to use StreamReader due to some internal restriction. I'm asking the Maximum size of CSV file in which the Oledbconnection can process. Can you Give me the solution for it?

Regards,
bluesathish

bluesathish 24-Nov-11 7:00am View

Dear All,
I need to know the maximum size of the csv file in which Oledbconnection can process in VB.NET Application, I can tested with the csv file which has more than 12,00,000 records, its fine. but if i give the csv file which has 1crore records then i got the out of memory exception. Please anyone help me to do this.

Regards,
BlueSathish

bluesathish 23-Nov-11 4:04am View

No actuall i want to filter the input into two types, like datatable.select(column='value') this. Then the resultant datatables inserted to the database using sqlbulkcopy(). So i need to convert the input to the datatable. Please help me to do this.
I've tried StreamReader concept also the system getting hanging and went to not responding state. Please anyone help me to do this.

Regards,
Sathish

Comments by bluesathish (Top 187 by date)