Comments by Pradeep Shukla

Pradeep Shukla 23-Oct-13 22:35pm View

What exactly happens that you call as "every thing goes to hell".. please post the exception detail.. that may help to identify and isolate the issue.

Pradeep Shukla 23-Oct-13 22:30pm View

you should post this question to Winsql forum: http://web.synametrics.com/WinSQL.htm

Pradeep Shukla 7-Oct-13 23:21pm View

you have not mentioned what is the issue you are facing...

Pradeep Shukla 6-Oct-13 23:31pm View

There is no ready made solution for your project. If you have tried something you can share the code here and if you have any specific issues... I would be happy to help.
BTW follow the guidelines http://www.codeproject.com/Articles/18654/Some-guidelines-for-posting-questions-in-the-forum

Pradeep Shukla 6-Oct-13 20:48pm View

What have you tried till now.. which column \ cell of the grid you want to get the updates from the text box. Its not clear from the question above. It needs to have more info if you want more help.

Pradeep Shukla 6-Oct-13 7:31am View

Your welcome..I have updated it as solution.

Pradeep Shukla 5-Oct-13 22:37pm View

I would agree you should check with Janus support...

Pradeep Shukla 5-Oct-13 22:32pm View

It seems improbable to have duplicate records out of this query, you are already using DISTINCT keyword to filter duplicates.. provide example of data ...

Pradeep Shukla 5-Oct-13 22:09pm View

The datetime field in db is of datetime type. Convert the data you are passing in datetime for comparison with the field.

Pradeep Shukla 5-Oct-13 15:59pm View

Check if the "ribbon from the Janus tool kit" is supported on Win8. you can remove this control and see if the form loads without this control.

Pradeep Shukla 5-Oct-13 15:56pm View

you can try any of these.. it may solve your problem:
listBox1.Refresh()
OR
bs.ResetBindings(false)

Pradeep Shukla 5-Oct-13 15:20pm View

You need to re-define \ explain your question properly...

Pradeep Shukla 5-Oct-13 11:34am View

You have not mentioned what is the problem you are facing in the CRUD process.. can you be specific...

Pradeep Shukla 1-Oct-13 10:36am View

It's not about the ColumnName (ApprovalId), the data you are inserting as ApprovalID in the table Approval does not match with any of the values in the ApprovalType table.

Pradeep Shukla 29-Sep-13 11:23am View

The exception says it all, remove the DataSourceID and there won't be any exception.

Pradeep Shukla 28-Sep-13 15:42pm View

You have to customize the print properties to fix the size to match the paper size as fit to paper. In order to customize what prints and what not.. is a tricky one. You have to actually send a modified screen for printing if that is what you want...

Pradeep Shukla 28-Sep-13 13:23pm View

The report URL may not be a trusted URL for IE that could be hindering in execution of scripts..Look for an eye icon or warning to fix it.

Pradeep Shukla 26-Sep-13 22:22pm View

I hope you have sysadmin role if that is true try any of these:
1- Right click SSMS and run as Admin.
or
2- Turn off UAC:
http://windows.microsoft.com/en-us/windows-vista/turn-user-account-control-on-or-off

Pradeep Shukla 26-Sep-13 12:01pm View

Have you set the bindingsource for the DataGridViewComboBoxColumn that you using?

Pradeep Shukla 26-Sep-13 8:51am View

It's repeat of another question by you..http://www.codeproject.com/Questions/659460/How-to-filter-the-blanks-in-the-datatable-using-da

Pradeep Shukla 26-Sep-13 1:04am View

I am NOT asking Ravndra22 to use any of those products, I asked if he is using any of those? I liked your answer (+5) and agree VSS is not very reliable but every org uses some kind of source control for maintaining code. By using source control If someone does modify his code he would always know who did it and he can revert if he wants to.

Pradeep Shukla 26-Sep-13 0:05am View

Is there any source control software is being used that stores the code like VSS, TFS.
If that is the case, Admin can restrict the code editing by using privileges.

Pradeep Shukla 25-Sep-13 23:15pm View

I am little confused.. can you clearly state where the checkbox & textbox are.. inside the grid or out of grid?

Pradeep Shukla 25-Sep-13 22:55pm View

Why you want to pass the values (Faculty ID) as array, you can use IN operator and add a sub query that lists the Faculty ID. It would keep all this code at a single place in a stored proc.

Pradeep Shukla 25-Sep-13 12:49pm View

Do you want to concatenate the strings or add (sum) the two numbers and then convert it back to string...

Pradeep Shukla 23-Sep-13 16:19pm View

I used a similar code in my project but did not face any such issue. Only thing that is different here is that I use only Adobe Reader 9.5. As Adobe has enabled document security from ver.10 onwards it prevents loading the document via this mechanism unless you modify the settings.

Pradeep Shukla 23-Sep-13 13:11pm View

what control are you using? you can always use group by to achieve the desired result.

Pradeep Shukla 23-Sep-13 12:18pm View

I know, I was also skeptical prior to adding my solution..but if someone else stumbles for the same question he should have a definitive answer.If I am spending my time on CP I would like it to be used to help others to the best of my knowledge.

Pradeep Shukla 23-Sep-13 0:07am View

What are the options you have tried till now? What is the format of invoice? Do you want to generate the format of invoice from db or only data from db? All these questions need to be answered before you can formulate a solution.

Pradeep Shukla 22-Sep-13 11:10am View

Buy a book on ASP.Net or visit wrox.com for sample projects. Reference books are there for providing the basics..that would really help to build your knowledge base.

Pradeep Shukla 21-Sep-13 18:11pm View

Provide more details, you can attain the same feature by via mater - detail view or use a container control to contain another grid view. There are multiple ways to achieve it.

Pradeep Shukla 13-Jul-13 12:35pm View

you can do that using:

byte[] bytes = System.IO.File.ReadAllBytes(wordDocumentFilePath)

afterwards the byte array can be converted to jpeg..

Pradeep Shukla 19-Jan-13 0:15am View

wow..it seems like everyone is here to write code for you...post specific questions if you need any help.

Pradeep Shukla 11-Jan-13 13:04pm View

From question I guess it is related to the Db not with C#. More details needed.

Pradeep Shukla 31-Dec-12 23:40pm View

I do not see the <Form> tag in the code...make sure you have that tag in the code..

Pradeep Shukla 1-Apr-12 22:13pm View

What is the error you got?

Pradeep Shukla 1-Apr-12 10:03am View

welcome...mark it as an answer if it solves your question.

Pradeep Shukla 7-Oct-11 15:44pm View

Can you give an example what you want to do here...

Pradeep Shukla 4-Oct-11 20:00pm View

Do you still have it installed..you can verify the location whether the exe is there or not...

Pradeep Shukla 4-Oct-11 16:19pm View

Based on what criteria you would split the data in 2 grids or you just want to repeat data in both of them..be specific...

Pradeep Shukla 1-Oct-11 17:54pm View

thanks simon..

Pradeep Shukla 1-Oct-11 15:51pm View

what is the config setting you are using to connect to the Db?

Pradeep Shukla 1-Oct-11 15:49pm View

Do you want to fetch the demand quantity from Db using the demandno and display it on the flexgrid? Clearly define what you want to do here.

Pradeep Shukla 1-Oct-11 13:20pm View

import the namespace: System.Diagnostics
and use following code where you are showing messagebox:

EventLog ev = new EventLog("System", System.Environment.MachineName, "MySystemSource");
ev.WriteEntry("Warning is written to system Log", EventLogEntryType.Warning, 10001);
ev.Close();

Pradeep Shukla 1-Oct-11 1:00am View

Go through this: http://support.microsoft.com/kb/815314

Pradeep Shukla 30-Sep-11 14:11pm View

use the new InstanceId as the earlier property is obsolete..nothing to bother.
change the for loop like this:
for ( i = 0; i>= LastLogToShow - 1; i++) and read through all the logs...

Pradeep Shukla 30-Sep-11 13:00pm View

Please do not repost...http://www.codeproject.com/Questions/262295/double-click-on-border-of-wpf

Pradeep Shukla 30-Sep-11 12:20pm View

C'mon..use a for loop....where do you want to show...on a form..or console...

Pradeep Shukla 29-Sep-11 23:23pm View

cool..you got it...

Pradeep Shukla 29-Sep-11 23:15pm View

Try to understand here...this replacement is done because "objCommand" object has no where been declared....If that applies to the "Insert" code, you should replace that too...

Pradeep Shukla 29-Sep-11 22:32pm View

your current code is all good, just replace the "objCommand" with "SQLCmd". This would help you to gear up...http://www.startvbdotnet.com/

Pradeep Shukla 29-Sep-11 16:36pm View

What's the question ?

Pradeep Shukla 29-Sep-11 14:31pm View

How the style elements are part of the data table...it can be part of datview not for datatable....

Pradeep Shukla 29-Sep-11 12:51pm View

Updated the solution...have a look

Pradeep Shukla 29-Sep-11 12:47pm View

There is no error mentioned in your question.

Pradeep Shukla 28-Sep-11 20:20pm View

you got it right..my 5+

Pradeep Shukla 28-Sep-11 20:20pm View

yes..you are right..I didn't notice the format in the question. It takes the default format based on the regional settings...

Pradeep Shukla 28-Sep-11 1:26am View

added sql tags..

Pradeep Shukla 27-Sep-11 10:44am View

You can use SSIS packages to move data around from one Db to another...

Pradeep Shukla 27-Sep-11 0:16am View

re-install audio drivers..

Pradeep Shukla 26-Sep-11 10:06am View

Have you defined a valid parameter in the rdl as "courseId" ?

Pradeep Shukla 21-Sep-11 0:02am View

What do you mean? The header is always fixed in grid view..

Pradeep Shukla 20-Sep-11 23:15pm View

There can be several different issues around it...IIS 7 page has more details:
http://blogs.iis.net/webtopics/archive/2010/03/08/troubleshooting-http-500-19-errors-in-iis-7.aspx

Pradeep Shukla 20-Sep-11 14:43pm View

What is the error that you got? Your question is not clear.

Pradeep Shukla 20-Sep-11 14:29pm View

What object is ClassDropDownList? a CombobBox or ListBox.

Pradeep Shukla 20-Sep-11 14:15pm View

Hi,
Classic ASP script error messages are no longer shown in a Web browser by default. Make sure the "Send Errors To Browser" attribute is set to True(IIS Manager->Click your website->Click ASP icon in the Home page->Expand the list of ASP features), then reproduce this issue. There should be some meaningful error message in the browser which can help us determine the root cause.
The following article contains more information, for your reference:
Running Classic ASP Applications on IIS 7.0 and IIS 7.5
http://learn.iis.net/page.aspx/559/running-classic-asp-applications-on-iis-70-and-iis-75/

Pradeep Shukla 20-Sep-11 8:05am View

ur welcome..

Pradeep Shukla 19-Sep-11 17:23pm View

Where is the question..what are you looking for ????

Pradeep Shukla 18-Sep-11 23:26pm View

your welcome...

Pradeep Shukla 18-Sep-11 23:10pm View

Yes..you can generate a report using Crystal Report and export it to pdf..but that would not let you edit the pdf file...

Pradeep Shukla 18-Sep-11 22:49pm View

In which format the data is, you can use DocumentViewer control to load .doc \ .pdf files to show..

Pradeep Shukla 18-Sep-11 12:44pm View

Are you trying to generate a string of length 4 in which first 3 are alphabets and 4th is a numeric ?

Pradeep Shukla 18-Sep-11 11:54am View

gr8..good to hear :-)

Pradeep Shukla 18-Sep-11 0:48am View

thanks simon :-)

Pradeep Shukla 17-Sep-11 23:47pm View

Please be specific with your question..are you trying to find duplicate record before entering them in the DB?

Pradeep Shukla 17-Sep-11 17:21pm View

It's not clear what you exactly want to ask...can you be precise with your question...

Pradeep Shukla 17-Sep-11 16:02pm View

May be you can ask your friend to re-install SP3, some how wbemcore.dll got corrupted resulting in the issue.

Pradeep Shukla 17-Sep-11 2:35am View

Why are you trying to pass 2 datetime value in one column.

trndate is going in '" & DateTime.Today().ToString("MM/dd/yyyy") & "','" & Format(Me.dtp_srv.Value, "MM/dd/yyyy") & "'

Either enter the current date or Format(Me.dtp_srv.Value, "MM/dd/yyyy").

Pradeep Shukla 17-Sep-11 2:22am View

What is the question here?

Pradeep Shukla 16-Sep-11 9:31am View

you can make this function a recursive function and it would traverse through all the containers within the form too....

Pradeep Shukla 16-Sep-11 1:59am View

Yes..that's right because in SQL unless you detach the .mdf and .ldf the database files would always be in use.

Pradeep Shukla 16-Sep-11 1:35am View

Deleted

Forward compatibilty is always provided in MS products and you can fairly easily use 2003 pst in 2007 outlook. Please post specific error or issues you may be facing. This link would provide the list of changes being made between these versions: http://office.microsoft.com/en-us/outlook-help/discontinued-features-and-modified-functionality-in-outlook-2007-HA010092683.aspx?pid=CH101535021033

Pradeep Shukla 15-Sep-11 17:45pm View

Thanks losmac ;-)

Pradeep Shukla 15-Sep-11 17:44pm View

Thanks Ravi ;-)

Pradeep Shukla 15-Sep-11 16:19pm View

The question is not clear.Do you want to update the data in SQL DB or in excel?

Pradeep Shukla 15-Sep-11 13:02pm View

I don't see any issue here, at which line you got this exception?

Pradeep Shukla 15-Sep-11 11:26am View

You have not mentioned the error that you are getting. Can you provide it with the line no on which you have the error?

Pradeep Shukla 15-Sep-11 11:24am View

Yes, you can have it, here is a link:
http://www.microsoft.com/download/en/details.aspx?id=21844

Pradeep Shukla 15-Sep-11 0:53am View

Do not use SqlCeDataReader, instead use SqlDataReader if your connection object is not created using an .sdf file. That would solve your issue.

Pradeep Shukla 14-Sep-11 22:21pm View

What kind of documentation you want to create? What kind of tool are using to create an ER diagram? Usually whatever tool you may be using they all have capability to extract the data model \ data dictionary information in either excel or pdf format. Be precise what you are looking for?

Pradeep Shukla 13-Sep-11 13:15pm View

Is it a windows application or a web application..the tabs are different tabs in a browser page or different tabs on the windows form?

Pradeep Shukla 13-Sep-11 10:37am View

your welcome ..;-)

Pradeep Shukla 12-Sep-11 23:31pm View

No, you don't need to remove it, you need to define it in a way so that its not related to the first datatable even though they have the same schema..you can fill both the tables like this:

da2.Fill(ds2, "PurchaseDB2")
da2.Fill(ds2, "PurchaseDB3")
ds.Tables(1).clear ' This would clear the contents

Pradeep Shukla 12-Sep-11 23:19pm View

da2.Fill(ds2, "PurchaseDB2") would create the first datatable in ds2 dataset, how the other datatable is created in ds2 ? The code should work depending if both the datatables in the dataset are independent of each other.

Pradeep Shukla 12-Sep-11 15:53pm View

It's a very basic stuff, go through this article: http://www.codeproject.com/KB/cs/simplecodeasp.aspx

Pradeep Shukla 12-Sep-11 15:41pm View

Thanks..

Pradeep Shukla 11-Sep-11 15:37pm View

Just put the report loading related code in page_init(), pass on the value of the text box during postback to the page..

Pradeep Shukla 10-Sep-11 19:11pm View

It's not very clear, do you want the data selected in the grid view to be displayed in the text boxes of the group box?

Pradeep Shukla 10-Sep-11 17:42pm View

The code seems to be correct, What is the exception you got?

Pradeep Shukla 10-Sep-11 16:21pm View

Thanks simon :-)

Pradeep Shukla 10-Sep-11 15:08pm View

ur welcome...:-)

Pradeep Shukla 9-Sep-11 1:59am View

I have updated the solution and post you responses as comments rather than as a separate solution.

Pradeep Shukla 9-Sep-11 1:18am View

There is no picture posted as you have mentioned in the question...

Pradeep Shukla 7-Sep-11 22:05pm View

There is no column as "fieldbankacc" in table1 as per your description...why is the condition added with this column..this query should not work at all..

Pradeep Shukla 7-Sep-11 10:47am View

Is it the code in the for loop that you need explanation:
Here the columns traversed are limited to 10 ( column A to column J ), you can change it to a different number. The method Get_Range() extracts the data and puts in an array.

Pradeep Shukla 7-Sep-11 10:20am View

You can iterate through the data table to get the values of the cell or transform the data into arrays to read through them..I have added small code snippet for that.

Pradeep Shukla 5-Sep-11 23:56pm View

Yes..thanks for sharing it...my 5 too

Pradeep Shukla 29-Jul-11 17:26pm View

What exception you are getting...

Pradeep Shukla 29-Jul-11 17:24pm View

What error you are getting? And the size and quality of the image matters too..
so take care of those things too...

Pradeep Shukla 29-Jul-11 17:12pm View

we can implement windows service which can connect to DB easily by using various ways...the question is very generic..can you detail what exactly you want to do....

Pradeep Shukla 29-Jul-11 11:21am View

Can you post the code where you are hitting this issue..that could help to find it...

Comments by Pradeep Shukla (Top 111 by date)