For some reason the insert statement is adding between 2 and 3 records each time. I've check the string and it looks good. I've put counters in and the code doesn't appear to be hit twice. This is ...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_23087250.html
Zones:
C#,
SQL SyntaxDate Answered: 01/16/2008 Grade: A Views: 4
Hi all,
I am moving some code from one of my SP's to my app code and I am not quite sure how to accomplish the same thing in C#. here is what I am trying to do ("Get ONLY the first name (and pre...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_23157551.html
Hi Experts!
I would like to get some "programmers with experience" input on this.
Basically I have a form that represents user properties with 20-25 text boxes such as First name,Last name. etc.....
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_23199513.html
Zones:
C#Date Answered: 03/12/2008 Grade: A Views: 17
I need to create an audit trail for some information in my application and I've thought of two different ways to do this.
The first way is I can create an audit handler class using generics and ...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_23223161.html
Is there a way to execute a stored procedure securely if the server connection uses SQL authentication (not integrated security)? By securely I mean that the server username and password can't be f...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23258291.html
We have a SQL Server 2000 database and we want to copy the schema only but not through Enterprise Manager. We want to automate this process. I have seen that SQL Server 2005 has SMO but migrating...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_23264401.html
I am trying to do a SQL JOIN in C# but I can't seem to get the propper SQL statement.
I have 2 tables:
tblClient - ClientIndex, LastName, FirstName
tblCase - ClientIndex, Worker
I have 2 te...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23293212.html
Excel file to SQL DB Table
The excel file must be parsed for CheckSums and then transfer columns to a table representation in SQL
The destination has different column names than present within ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2329...
Ah yes as of more questions. This one hopfully should be easy for you guys. I have a sql database and i have information getting pumped into it from a web service. Every time an entry goes into it ...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_23364104.html
This seemed simple enough at first glance, but then got more complicated the more I looked at it. The question simply is, how do I pass a null into a SELECT stored procedure? I have a stored proc...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23365767.html
