|
That would make sense. I tried the code you supplied, but had an error, those three objects are not declared. I assume I need to add a reference. I am using Visual Studios 2005. Any idea which reference it is? Or how to declare "adOpenDynamic,adLockOptimistic,adCmdText" ? - Thanks again.
|
|
|
|
|
If you are using .Net, you should use System.Data.OleDb class, rather than the "old" ado stuff.
I suspect you must have added a reference to msado.dll in order to get the Ado classes, probably need some of the other dlls to get the enumerations exposed( or they're there but need the enumeration prefix - CursorType.adDynamic, etc.)
Use SqlClient classes for SQL Server, they're much faster than the OleDb (although you can use either for SQL, just a bit more overhead in the oleDb.
We need to graduate from the ridiculous notion that greed is some kind of elixir for capitalism - it's the downfall of capitalism. Self-interest, maybe, but self-interest run amok does not serve anyone. The core value of conscious capitalism is enlightened self-interest.
Patricia Aburdene
|
|
|
|
|
hi all,
i want to take backup my database with query. pls help
and give me query
vipin
|
|
|
|
|
I assume your using SQL Server 2000
Construct a DTS package that will do the backup.
This can be run with TSQL
Example below of running a DTS package via TSQL
exec master.dbo.xp_cmdshell 'dtsrun -E -Sserver1 -N"Export Invoices"'
Google has lots of examples on how to do this.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
You can use BACKUP[^]
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Hi
I want to use a blank (empty string but not null) as a default value for varchar column in SQL server 2000. Is this possible and if it is, how do I do it (in Enterprise Manager if possible)?
Just so that I don’t get a lot of why do you want to do that answers. The underlying data access layer I use need blank values or it won’t create a correct xml files.
Thanks
Johan
|
|
|
|
|
Simply use "Create table Table1(col1 int, col2 varchar default ' ')
Ramya
-- modified at 5:53 Friday 12th May, 2006
|
|
|
|
|
hertz_j wrote: in Enterprise Manager if possible)
In the Columns Property Page put SPACE(0) as the Default Value.
----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin
|
|
|
|
|
Hi Eric,
I'll try that, thank you.
|
|
|
|
|
I want to use a dataset that can work with different database(Access, Sql Server, MySql, Postegre etc..) using an ODBC connection. My application must be database indipendent. If it's possibile, how can I do?
|
|
|
|
|
armax75 wrote: I want to use a dataset that can work with different database
DataSets are database agnostic. That means they don't care what the database is. In fact, they don't know anything about the database. It is the job of the DataAdapter to marshal data between the database and the DataSet.
armax75 wrote: My application must be database indipendent.
Yes, you can use the solution I proposed to you below. There an example of something quite similar in DotNetNuke if you want to see the idea in practice.
An alternative would be to look in to something like NHibernate[^]
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
I enter an error(deliberate) in a connection string like a missing password for non-windows logon to SQL 2005 in my VB.NET program.
No matter I set the FireInfoMessageEventOnUserErrors to true or false and add
a handler to handle the SQLClnt's InfoMessage. But this procedure never gets
fired, only the SQLClient's SQLException error is picked up in the try--catch block and the ExceptionAssistnat shows up.
When does the
FireInfoMessageEventOnUserError really gets to be evaluated?
|
|
|
|
|
It is only fired for informational or warning messages, not errors.
We need to graduate from the ridiculous notion that greed is some kind of elixir for capitalism - it's the downfall of capitalism. Self-interest, maybe, but self-interest run amok does not serve anyone. The core value of conscious capitalism is enlightened self-interest.
Patricia Aburdene
|
|
|
|
|
Is it not true that it is related to the severity of errors, exception reporting taking over in exceptionally severe cases?
|
|
|
|
|
No, it is used only for informational or warning messages. All errors will raise an exception.
We need to graduate from the ridiculous notion that greed is some kind of elixir for capitalism - it's the downfall of capitalism. Self-interest, maybe, but self-interest run amok does not serve anyone. The core value of conscious capitalism is enlightened self-interest.
Patricia Aburdene
|
|
|
|
|
Hey...In my coding...
I need a randomalphanumeric generator code...for a field in form1.aspx..This will be inserted as a primary key information in my database table...
If i implement randomalphanumeric generator it should be unique value..Plz help as soon as possible
the generated random alphanumeric string should be something like
TX12YZ57 format...
|
|
|
|
|
You can use GUID.NewGuid() if you are using c#/Vb.net
or
If you use sql server,GUID data type can be used
|
|
|
|
|
|
Hi,
Does anyone know how to return muliple tables from a stored procedure to an .Net Application.
For example if my sp has 3 separate select statements I want to return a dataset containing 3 tables with the results of the 3 select statements.
Any help would be greatly appreciated.
Cheers,
Craig
** I'd rather try and fail than fail to try **
|
|
|
|
|
Hi
Create a SP that contains 3 SP (all there should return out put)
generate typed dataset and drag and leave the SP on the data set
you can see the three tables created on the typed dataset.
Or else if you are not using typed dataset. and you are filling to simple data set, after filling data set
use like
someDataSet.Tables(0)
someDataSet.Tables(1)
someDataSet.Tables(2)
to access the tables data
Chinna Srihari
Tech Lead, Capgemini
|
|
|
|
|
DataSets are perfectly capable of handling multiple tables. There is no difference in acquiring multiple tables from a stored proc as there is in acquiring one table. In your case:
DataSet ds = new DataSet();
Console.WriteLine("Table 1 Rows: " + ds.Tables[0].Rows.Count().ToString();
Console.WriteLine("Table 2 Rows: " + ds.Tables[1].Rows.Count().ToString();
Console.WriteLine("Table 3 Rows: " + ds.Tab;es[2].Rows.Count().ToString();
|
|
|
|
|
The following would return three RESULTSETS from sql server:
SELECT * FROM CUSTOMER
SELECT * FROM INVOICE
SELECT * FROM INVOICE_DETAIL
through a SqlCommand object and a SqlDataAdapter you can fill a dataset with the resultset. If you're using a strongly-typed dataset, make sure to set the table mappings.
I could have been a little more detailed, but it's all in the MSDN help.
|
|
|
|
|
Hi Guys,
Im trying to modify a program that will run and can switch into two back-ends(MSSQL and MSACCESS) and initially it is working and with no issues using the MS SQL server side. But when I'm switching the connection into MSACCESS with same tables as with the MSSQL, some of the SQL command is not working. My question is, "Is it possible to switch into a differrent back-end such as SQL to access without changing any SQL commands ? "
|
|
|
|
|
armax75 wrote: My question is, "Is it possible to switch into a differrent back-end such as SQL to access without changing any SQL commands ? "
Generally, no!
As a possible suggestion:
You should create an abstract class that will handle data access. The interface (i.e. the public methods/properties) of the class should be database neutral. You can then create two inherited classes, one for Access specific things and one for SQL Server specific things. You then have some code (a factory method) that decides which of the derived classes to instantiate. The rest of your application only ever refers to the abstract base class.
public abstract class DataAccessObject
{
public abstract DataSet RunSomeQuery(string param1, int param2);
}
public class DataAccessObjectSqlServer : DataAccessObject
{
public override DataSet RunSomeQuery(string param1, int param2)
{
}
}
public class DataAccessObjectMSAccess : DataAccessObject
{
public override DataSet RunSomeQuery(string param1, int param2)
{
}
}
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Thank you Colin,
but my application uses a dataset, built by dataset wizard (Add datasource)from an Access db, what I want to do is to find a way to switch to SQL server at runtime using the same dataset. Changing the connection string the dataset's query don't function. I've used standard sql. There's a way to use an xml file that can change the query in dataset (according to the rigth database)set designer at compile time.
Best regards
Armando
|
|
|
|