Comments by Goutam Patra (Top 83 by date)

[i tried to change extension]: What? Did you really? awful.

It wont. So you are trying to search using (username + ' ' + usertype) = 'avinash Admin'? Take a look at the edited part of my answer.

To [hopingToCode]: Take a look at the question again. Dont you think OP needs a very simple solution? I hope you understand what i mean.

What you have asked for just a beginin. You have to go a long way to get the actual data. Actually you are not trying. Try youself. Map those structures as per the document. thats all i can help you.

Dont post your email address to avoid spam. If anyone replies then you will get a email notification.

Post a new question and ask for twiddling. Someone will help you out in that regard or may be i will be ther.

See my Edited answer.

[did you mean NYSE?] NSE->National Stock Exchange (India)

See my edited answer.

It should, at least its working for me for last 10 yrs.

Check my answer modified.

Good link

Repost

Check my answer again i have edited the same.

First dont push answer to add a comment. Use add comment instead. Now as per your requirment see my answer. I have edited the same.

VB6 is history.

Is this a AD of the site?

Will you care to use your head and some googling? This was a suggestion how you can do it. Just putting the error message shows that you have not worked anything out.

Why don't you try yourself
create table STUPIDTEST ( FIELD1 INT IDENTITY(0, 1), FIELD2 VARCHAR(10) NOT NULL)
GO
INSERT INTO STUPIDTEST(FIELD2) VALUES('TEST1')
SELECT @@IDENTITY
GO
INSERT INTO STUPIDTEST(FIELD2) VALUES(NULL)
SELECT @@IDENTITY
GO
INSERT INTO STUPIDTEST(FIELD2) VALUES('TEST3')
SELECT @@IDENTITY
GO

and try google for more

What you are trying to do? Reading a Word document as text?

Thats a new window link

In India? Google for sms service providers in india

Dont push answer. Use Add comment instead. And for query there are no provider who are going to provide some service for free and any case. You need to pay.

Remove one field from your query and try to execute it. If does not run correctly then remove another field and try again. This way you will find the exact field where you are getting the error.

[We want video recording using IP cameras through c#.net] Why so demanding? What SQL tag is doing here? Who are WE? Try yourself.

Yes, I have edited the answer, Please check it. And moreover SelectedText gives the Text of the Highlighted Selection ie the text you select by pressing Shift key.

Google for A generic error occurred in GDI+, You will find reasons for the error.

Dont push answer to update your question use the improve button and edit your original question. Like OriginalGriff said [Edit your question]

OK I didnt notice that one. Take a look at this link below may be useful.

http://msdn.microsoft.com/en-us/library/ms913863.aspx

Update your question to show what coding have you done for that so that some one can help you to find out what wrong with your code.

Thank you Ankur for your comment and vote. I am not at all worried about any point. But a correct answer doesnt deserve a downvote. Its odd. and have a 5 from me.

Dont push answer. Add comment to reply a specific answer or update your original question.

Exactly, someone randomly downvoted all the answers. Even when all the answers are correct.

Dont push answer to reply a specific answer. Use add comment instead.

Anyway check those links

http://www.dbforums.com/microsoft-sql-server/1633187-translate-pivot-query-into-sql-server-2000-compatible-query.html

http://www.ozgrid.com/forum/showthread.php?t=77395&page=1

http://stackoverflow.com/questions/312861/pivot-using-sql-server-2000

or try google.

So, what’s your problem?

It would be better if you use a meaningful subject of your question.

You will get help if you give a proper subject of your question.

Urgent to you may be

You are so lazy that you cannot even write a question.

Dont puch answer. Use add comment link to reply to a specific answer.

You should change your table structure.

Does Access support stored procedures?

Homework, no effort.

The in condition will not work.

I am not very sure sut take a look at
http://stackoverflow.com/questions/649802/how-to-pivot-a-mysql-entity-attribute-value-schema

http://search.mysql.com/search/query/search?q=pivot&group=refman-50

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html

You dont need to pass a parameter. "Load the application by clicking [OpenWith]" display the "Environment.CommandLine" using a message box and your find the answer yourself.

I think OP forgot the sum operation :)

I said WebRequest. System.Net.WebRequest. I think this will solve your purpose. Just go through the link specified.

See this link http://www.adobe.com/devnet/pdf/pdfs/PDFReference16.pdf

Duplicate of http://www.codeproject.com/Questions/105810/want-to-help-for-crystal-report.aspx

In which part do you want help? Loop through the grid or saving it into text file?

<has been="" insane="" enough="" to="" split="" data="" between="" two="" databases="">
Thats right. I was just trying to answer the question. I really don’t bother about OP’s DB design

I only use this to import data from Access, Excel files.

Try adding a valid Subject

VB5/6 is history. If you cannt upgrade your VB version why do you want to upgrade the Windows version. Use Windows 95,98.

No just joking....

No, I was just joking that time, everybody in here replies in there spare time voluntarily. So don’t expect anyone to do your job here ever.

Never post your email address to aviod spam

Does it make any sense?

You are so lazy even you can’t put some effort to explain your question.

OK, I overlooked the situation. Its because you are using the same list for the both combobox.

It would be better if you change your user name. Remove your mail address.

Edited for Code block and link

Its better you read some books on crystal report and google for "crystal report for beginner"

Its just a error of missing Field. Type the fieldnames correctly.

Good, then go for it

Is there a MyEFAdapter.TLB file in your Debug Folder
Then You need to register it also
You can do it manually using
REGASM /unregister <dllname> /tlb <tlbname> in the command prompt
REGASM /register <dllname> /tlb <tlbname> in the command prompt

And then you can add referrence to your VB6 Project of that TLB file.

Hope this will help

Is all columns have identical values? If so then you cant.

Next time Add comment to reply a specific answer instead of adding a new answer.

Is your Schemes field contains "AG015#AX004#BB037"
If so then it will not work this way
Do it this way


Declare @Qry VARCHAR(1000)
Declare @Cond VARCHAR(1000)

SET @Cond = (SELECT '''' + replace(cast(Schemes as varchar(1000)),'#',''',''') + '''' FROM JM_DSS_Sets WHERE SetName = 'Institutional')
SET @Qry = '' +
'select shortname from scheme_info where sch_code in (' +
@Cond +
') Order by shortname'
exec (@Qry )

Clarify with more detail or put some code and the exact problem (like How you are printing and what layout). It should be the problem in your code. Same code does not give different output

Nuts, Its in the Strings Class

Public Function Chr(ByVal CharCode As Integer) As Char
Member of: Microsoft.VisualBasic.Strings
Summary:
Returns the character associated with the specified character code.

Parameters:
CharCode: Required. An Integer expression representing the code point, or character code, for the character. If CharCode is outside the valid range, an System.ArgumentException error occurs. The valid range for Chr is 0 through 255, and the valid range for ChrW is -32768 through 65535.

Return Values:
Returns the character associated with the specified character code.

Find the same and reply

No you dont need to purchase SQL Server lic cause it has been already purchased by your space provider

There are only 2 things you need to ckeck

1. Have you created the Report using the XML File as data source instead of setting it directly from server.
2. The name of the data set should be exactly the same specified in XSD file

<xs:element name="ACCLIST">

Data set name should be changed after feching data

ds.Tables(0).TableName = "ACCLIST"


If you did those 2 things there should not be any error.

It seems you created the report(RPT fle) setting database object directly.

Check in you server machines Task manager. There must be a Excel.Exe in your application tab.

Alernatively try

Dim ExcelApp As Object
ExcelApp = createobject("Excel.Application")
ExcelWorkbook = ExcelApp.Workbooks.Add();

and let me know

I did not understand your purpose of the while loop.

If i am not mistaking you are fetching data in a datareader object and copy it into a Dataset. Why dont you just fetch the data in a dataset may be like
Public Function FetchData(ByVal V_QRY As String) As DataSet
Dim oCon As OracleConnection
Dim ds As New DataSet
Try

Dim cmdData As New OracleCommand(V_QRY)
cmdData.CommandType = CommandType.Text
oCon = New OracleConnection(ConString)
oCon.Open()
cmdData.Connection = oCon
cmdData.ExecuteNonQuery()
Dim da As OracleDataAdapter = New OracleDataAdapter(cmdData)
da.SelectCommand = cmdData
da.Fill(ds)
da.Dispose()
cmdData.Dispose()
oCon.Dispose()
Return ds
Catch ex As Exception
Return AddError(ex.Source, 0, ex.Message)
End Try
Return ds
End Function

You can try it once

He has the problem to set diff db source in crystal report. In this Solution he dont need to worry about the diff data sorce for crystal report. He has to fetch the data in his main program only using diff data source. That he can control in his .Net code. Crystal report will work with pre-fetched data only. Thats how it will help him. i hope this will explain how it will help.

Nope not at all