Comments by Charlemagne Gustilo

Charlemagne Gustilo 30-Sep-15 2:10am View

Hi, are you collecting the list of records as a single record? Check COALESCE function to handle that. Below is a sample.

DECLARE @SQL VARCHAR(8000)

SELECT @SQL=COALESCE(@SQL,'')+' '+RTRIM(FIELD)+ ', '
FROM TABLE

SELECT @SQL

Charlemagne Gustilo 14-Mar-14 6:34am View

Do you have an identity column? If so, you can simply get the last row by selecting MAX(FieldName).

Charlemagne Gustilo 13-Mar-14 21:17pm View

Have you tried changing the AND conditions to OR?

Charlemagne Gustilo 3-Mar-14 3:04am View

Hi sanjaysgh,
This error occurs when you pass a non-numeric value to a parameter that is numeric. Have you tried checking values that are passed as your parameter?

Charlemagne Gustilo 6-Feb-14 4:25am View

Hi, you can try using the following scripts to read items from the database:

select * from sys.tables
select * from sys.views
select * from sys.procedures
select * from sys.triggers

Then you can try adding nodes from the treeview following the sample in http://msdn.microsoft.com/en-us/library/system.windows.forms.treeview(v=vs.110).aspx

Hope this helps.

Charlemagne Gustilo 8-Mar-12 22:44pm View

Hi, have you tried changing the target framework to .NET Framework 4? You can do this by right-clicking the project -> properties -> compile tab -> advance compile options button.

Charlemagne Gustilo 6-Mar-12 2:09am View

Hi, i think this is related to this post:
http://www.codeproject.com/Questions/340942/solving-a-problem-query-related

Charlemagne Gustilo 6-Mar-12 0:44am View

Hi, can you specify what kind of asp.net control are you referring to? i.e., datagrid, textbox, etc.

Charlemagne Gustilo 6-Mar-12 0:34am View

Hi! Are you trying to create applications that communicate with each other on the network, where in the workstation asks the brain it's sql server connection and the brain sends back the information? You can try System.Net.Sockets. As for sql server connection, both needs to have SQL Client in order for them to connect on the same server.

Charlemagne Gustilo 6-Mar-12 0:18am View

Hi, are you trying to sort a listview by a clicked column? If so, you can look at the ListViewItemSorter on http://www.microsoft.com/china/MSDN/library/enterprisedevelopment/softwaredev/dnwinforms.mspx?mfr=true

Charlemagne Gustilo 5-Mar-12 22:38pm View

Oh hi Dave! thanks for correcting me. I forgot to mention how to build the exe. I focused only on how to create a program to connect to a database. As you have mentioned, we can create a new setup and deployment project, or by right-clicking the project -> properties -> publish tab -> publish wizard button. Thanks Dave!

Comments by Charlemagne Gustilo (Top 11 by date)