Comments by codejet - CodeProject

codejet 19-May-20 10:43am View

I came across that code in a training kit for MCSD (VB 6.0 ) when I was still a student in 2006. I am not claiming to be the originator of the code. So because I am not the originator of the code that disqualifies it as a valid solution?

codejet 23-Mar-20 8:50am View

Sub ConTempOpen()
ConTemp.ConnectionString = "server=" & My.Settings.Host & "; user id=" & My.Settings.User & "; password=" & My.Settings.Pass & "; database= " & My.Settings.dbName & ";MultipleActiveResultSets=True"

'--It can be added anywhere in the connection string

codejet 18-Mar-20 7:37am View

Which report viewer are we talking about here Microsoft or Crystal?

codejet 13-Mar-20 19:41pm View

Winforms or what?

codejet 3-Feb-18 15:48pm View

Difficult to assist. How are you comparing the rows is there is there a primary key column?

codejet 20-Oct-17 15:20pm View

Are you getting nulls for all the columns or a particular column?

codejet 19-Oct-17 17:53pm View

Give us the exact error message. Usually such errors are in the form :
"the multipart identifier <column_name > could not be bound in SQL server stored procedure in select query"

codejet 7-Nov-14 1:02am View

Thank you. ( I am not being sarcastic)

codejet 5-Nov-14 11:01am View

Its working so I dont think I am doing it wrong maybe I am just doing it bad.

codejet 5-Nov-14 10:58am View

I have experienced it. My first my major project was converting VB6 code to VB.NET code. So I did away with ADO and replaced it with ADO.NET there is a huge difference in speed.

codejet 21-Aug-14 2:32am View

Please improve your question . You did not provide the structure of the tables.

codejet 14-Aug-14 3:34am View

Be more specific which report viewer ?

codejet 6-Aug-14 17:50pm View

When you say first row what do you mean? What is the ordering based timestamp, id etc?

codejet 6-Aug-14 17:20pm View

If you post your app.config file it might help

codejet 6-Aug-14 16:52pm View

Not enough information about the environment If the database is hosted on a remote server trying opening TCP 1433, 1434 and UDP port 1433, 1434

codejet 5-Aug-13 10:26am View

I Agree

codejet 29-Jan-13 2:25am View

Dim IsNum As Boolean

codejet 18-Jan-13 2:24am View

Code? I strongly suspect the data you enter in the datagridview is not persisted to the database. Snippets of your code would help .

codejet 18-Jan-13 2:11am View

How about giving us more info on what you are trying to do? Throw me a bone , I'm the boss, need the info .

codejet 5-Oct-12 11:30am View

Please elaborate. Give us a bit more code to work with.

codejet 31-Aug-12 4:41am View

change
con.ConnectionString = "Data Source=.\SQLEXPRESS;Initial Catalog=DATABASE.mdf

codejet 29-Aug-12 8:17am View

ExecuteNonQuery is ok. What errors are you getting now?

codejet 23-Aug-12 4:25am View

Sorry ignore that. Is it fine now ?

codejet 23-Aug-12 3:04am View

To remove double quotes use Regex.Replace Check http://msdn.microsoft.com/en-us/library/xwewhkd1.aspx. You are a bit unclearon setting pipe as the delimiter.

codejet 20-Aug-12 12:48pm View

Access does not use named parameters

codejet 7-Mar-12 9:25am View

There are so many ways of doing it its difficult to assist you when you have no provided any code. Just how are you accessing your data : DataSets , DataReaders and CommandObject, Linq etc........

codejet 12-Nov-11 4:03am View

I have tried restarting the service and OS to no avail. By the way I am having trouble logging in through Sql Server Management Studio.

codejet 11-Nov-11 17:50pm View

I agree with OriginalGriff.

codejet 11-Nov-11 17:39pm View

What criteria do you want to use for deleting the data

Comments by codejet (Top 29 by date)