If I use this class to do a
SELECT * FROM ...
statement against a database, what method or variable of this class should I use just to give me a dump of the output from the SQL statement?
I know my SQL safety isn't up to par. I've read on this site that PHP PDO would be a good first step, and while I did take a look at the PDO Manual it's a bit daunting. Is there somewhere I can find a tutorial on the basics of using PDO rather then straight MySQL calls?
I have a Setup Project in my solution in Visual Studio 2008 SP1. The application installs fine but it is not loading my prerequisite of SQL Server CE.
I have the following configurations set:
Do I need to do anything else, like with a Custom Action or anything like that? Thanks.
For example, the users of our app want to search products by entering a keyword of productName.
The Products table of the sql server database contains about 10 million records.
Is there any better and higher-performance search method implement instead of productName.Contains("keyword") using asp.net C# ?
SQL Server doesn't allow creating an view with schema binding where the view query uses OpenQuery as shown below.
Is there a way or a walk-around to create an index on such a view?
I am trying to force user to enter username and password when they run my C#/SQL web application. This was developed in VS 2008 on a 32-bit XP. The current connection string I'm using in my web.config file is:
But it still doesn't prompt for a username and password. What am I missing?
Hello
I've a string @mainString = 'CATCH ME IF YOU CAN'. I want to check whether the word 'ME' inside @mainString.
So how to check if a string has a substring in sql?
Thank you
Regards
NLV
I am creating an application where I am generating pins dynamically based on user's input and storing them into mySql database.
$sql = "INSERT INTO tblpin ('pinId', 'ownerId', 'usedby', 'status')
VALUES
for($i=0;$i<$npin;$i++)
{
('$pin[$i]','$ownerid', 'Free', '1');
}
;";
how can I do that?
How can I refresh the tab in Visual Studio for a database table? Currently I re-open the table but I would think there is a way to refresh the table. I am referring to tables opened via the Server Explorer/SQL Express.
The clear results does not seem to refresh.
We want to use the Entity Framework (.NET 4.0) to build applications that can deal with Sql Server, MySQL and Oracle. And maybe Sqlite too.
It should be easy to switch the db vendor by some setting in a config file.
Is this possible? I prefer real life examples!
What kind of providers did you use?
is there some standard about how to graphically represent database schemas? Is UML a defacto standard for this?
Also, is there some free tool that can help me convert an sql file (basically bunch of CREATE TABLE queries) into some nice graph (UML or not UML)?
Please help...
I am so confused, how to set Crystal Report 10 data source at runtime
using VB 6.0. I am using SQL SERVER 2005 for database and I create
the reports using stored procedure..
do You have any idea to solve my problem ?
thanks before..
Like index maintenance we have index reorganize/rebuild, update stats, shrink database log files , database backup/restore in MS SQL server, What are maintenance steps and performance steps for Mysql server/database ?
I have a wiki system where there is a central table, Article, that has many Revisions in their own table. The Revisions each contain a created_at time and date column.
I want to update the Articles to contain a denormalized field sort_name from the most recent Revision's name field.
What SQL command can I issue to fill in each Article's sort_name field with its most recent Revision's name field?
For what it's worth, I'm on PostgreSQL.
I'm finding it very hard to estimate how much my web application might cost running in Amazon's cloud? My app is similar to stackoverflow.com - asp.net, ajaz, sql database. Can anyone estimate how much it might cost to run stackoverflow in Amazon's cloud?
How would I Populate a DataSet with ALL the Tables from a SQLCE DB. Is this possible in ONE SQL select statement?
I know that I can call seperate select statements with the names of the table I need data from but I need a generic solution that just dumps all the tables from the SQLCE DB into a Dataset.
Thanks
I have a Browser and I want to display history & favorites of user on webbrowser on button_Click event. Can I accomplish this by using treeview in my form? if not what other way i can use. Data about History and Favorites is stored in SQL server database.
Thanks,
Ani
How do I dump the data, and only the data, not the schema, of some SQLite3 tables of a database (not all the tables)?
The dump should be in SQL format, as it should be easily re-entered into the database latter and should be done from the command line. Something like
sqlite3 db .dump
but without dumping the schema and selecting which tables to dump.
I'm building a very simple ASP.NET MVC site that doesn't require a database and doesn't have user accounts or any other special ASP.NET stuff. When I first created the site with the ASP.NET MVC 1.0 site template in Visual Studio, the web.config page was configured to automatically connect to SQL Server Express as a User Instance.
Can I completely remove this dependency? If so, how do I get rid of all this database stuff?
Please tell me what is difference
== if i write query directly in storedprocedure
== and write query in string variable and than run it in exec in stored procedure.
i am using ms sql server 2005
I am working on a Incoming and outgoing messages webform, I would like to show the users the only messages in their INBOX of one day behind. I have a dropdown where I'm giving the selection of All and Pending messages. But if the users have any pending messages in INBOX of just one day behind ,they have to choose All to retrieve the messages.
So how do I retrieve messages from message table of just one day behind ? I am using SQL 2000 vb.net web application.