|
|
Hey,
Anyone knows where the databases/tables, created on SQL Server2000, are located.I mean the actual path to which I can navigate to from windows browser.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
In Query Analyzer type the following in, while connected to the master database:
select name, filename FROM sysdatabases This will give you the operating-system path and name for the database's primary file.
Alternatively, you can connect to a specific database and perform
SELECT * FROM sysfiles This will get the details of the files for the current database.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
Hi Colin,
Thanx 4 ur qik response.
I'll definetely try and let u know.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
Go to Enterprise Manager and navigate to database folder. Right click on any database that you want to know its path and choose Properties command from the context menu. The database property dialog box appear and navigate to the Data Files tab and you will see the Location property and you will see the full path of the database file.
|
|
|
|
|
Hi,
Working with OleDB (MS Access db).
I need to round the result of a SELECT SUM(this * that).
I've tried SELECT SUM(ROUND(this * that)) and ROUND(SUM(this * that))
but it doesn't seem to work. I've been able to use FORMAT though...
Is it possible to use ROUND with a SUM?
If all I can use is FORMAT, can someone point me to the list of options I can use with FORMAT... all I know is 'Standard'.
thanks for your help,
Ron
|
|
|
|
|
HI,
Well as for a change and problem reduction solving i will use the following:
SELECT SUM(this)
//and store it in
Decimal first_result;
//then
SELECT SUM(that)
//and store it in
Decimal Second_result;
//then the result
Decimal result = Decimal.Multiply(first_result,Second_result);
I hope this can be of use...
|
|
|
|
|
Can any one plz tell me why we do not use new keyword in oracledataReader
that is why this gives error
OracleDataReader objectDR=new OracleDataReader();
Thanks In advance
|
|
|
|
|
Hi,
if you want to use the datereader then usually you use to get all the results of the query so basically it's read the result of a query from the DB.
Below you can find a sample code that will use a query text to put it in the Oracle Command and then Retrive the results with the use of Datareaer Where a DataReader Return the resulted rows one by one each time it Uses .Read() Method wich return a bool with false if all the rows are all ready readed.
//code sample to use DataReader class
oracleConnection1.Open();<br />
<br />
string query_txt = "Select * from any_table";<br />
<br />
OracleDataReader ordr1 = new OracleCommand(query_txt,oracleConnection1).ExecuteReader();<br />
<br />
while( ordr1.Read())<br />
{<br />
MessageBox.Show(ordr1[0].ToString();<br />
}<br />
<br />
oracleConnection1.Close();
//where ordr1[0].ToString() 0 is the first column in the select statement
|
|
|
|
|
Thanx for your interest in my query but what i want to know is
why have u done
OracleDataReader ordr1 = new OracleCommand(query_txt,oracleConnection1).ExecuteReader();
instead why u did not do this
OracleDataReader ordr1 = new OracleDataReader();
// that is why we do not use new keyword with darareader
Thanxs in Advance
|
|
|
|
|
okay, usually if you use the new command it will give u an Error ("No Constructors Defined") right and cuz it was ment basically for reading the date from a Command (at least this is what i Know!)so if you just want to initilaize it then make it
OracleDataReader ordr1 = null;
//or with out Intilaizing it
OracleDataReader ordr1;
thnx.
|
|
|
|
|
HOW TO PLACE CHECK BOX IN GRID AND HOW TO DISPLAY RESPECTIVE VALUES IN ANOTHER GRID IF I SELECTED AN ITEM FROM CHECKBOX
HAI THIS IS HARI PLZ HELP ME IF I GET ANY PROBLEM WHILE PROGRAMMING.
|
|
|
|
|
Please don't write in all caps; it is irritating.
ADO.NET knows nothing about checkboxes. ADO.NET is a mechanism for transferring information in and out of databases. There are no user interface components.
If you are developing a web application you may like to try the ASP.NET forum, if you are developing a Windows Forms application you may like to try the C# or VB.NET forum.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
I have just put together a Windows 2003 x64 Server for a client. Our intent is to move an application that is currently on a Windows 2000 server. It uses an Access 2003 front end and connects via ODBC to a mysql database. When we go to the 64 bit server everything is screwed up.
mysql finally released mysql 5.0 binaries for Windows x64. However, after creating an ODBC datasource we get "Access encountered an unexpected error and shutdown...." this happens if both Access and mysql are on the 64 bit machine or if only mysql is on 64 bit and Access and ODBC datasource is on 32 bit Win 2000.
I also tried using Maxdb. I got that installed and it works from the command line. However none of the GUI tools work on 64 bit Windows. Furthermore, I can put a few records into a table to test. Opening the table via Access and ODBC is ok but if you try to delete a record Access just hangs. When you force a shutdown of Access and reopen the desired record has been deleted. Again this happens if everything is on 64 bit machine or 64 bit for backend and 32 bit for front end.
Help! and Thanks!
Scott
|
|
|
|
|
 Hi, I am using ADO 2.81 with C++ 6.
In my program I have a datagrid which is filled with data from adodatacontrol. Whenever i select a different row, my app needs to display information about it. The problem is, I can't find in which row the user clicked...
Is there any code that can help me?
i am trying to put it in the function:
void CMyDlg::RowColChangeDatagrid(VARIANT* LastRow, short LastCol)
here lastRow shows the last row clicked not the present.
I tried with dataGrid.get_Row();
this works fine if I dont scrool the data grid. But if I do so, it gives me the same informations (like I am not scrolling)
PLS help
|
|
|
|
|
hi ,
i want ot update multiple rows in the sqlserver2005 database by calling a single procedure from the frontend (ASP.NET). I m passing an xml string to stored procedure for that.
Table name is UnicomUser, UnicomUserId is rowID for which updation is to be done, status is the column to be updated
The procedure written is:
CREATE PROC UnicomUI_DistrubutionGroupAdmin_ApproveUser
@UnicomUserId varchar(500)-- string containing xml tags passed as parameters
AS
DECLARE @hDoc int
exec sp_xml_preparedocument @hDoc OUTPUT,@UnicomUserId
UPDATE UnicomUser
SET
UnicomUser.status = 4
FROM OPENXML(@hDoc,'/items/item')
WITH UnicomUser XMLUser
WHERE UnicomUser.UnicomUserId = XMLUser.UnicomUserId
EXEC sp_xml_removedocument @hDoc
It is executing but not updating.
Another thing, it it runs ok, then will it update all the rows at one hit or cursors is required to navigate thru the rows.
Is there anyother way to achieve the target
thanx
sandeep
|
|
|
|
|
 hai guys,
in my webform contains two textboxs(TexBox1,TexBox2)and a button also.
when i click a button that input will add to my dabase's table.
i am using c# coding in asp.net.my backend is sqlserver?
i am using ado.net to connect the databse to open.it's fine.
but how can i add/insert the input data to the table by c# progrmming?
i need the code
solv my probs...
vm.kumaar
|
|
|
|
|
SqlCommand InsertCommand = new SqlCommand();
InsertCommand.Connection = cnn;//ur SqlConnection;
string sql;
sql = "INSERT INTO TABLE VALUES ('"+textbox1.text + "','" +"+textbox2.text +"')";
InsertCommand.CommandText = sql;
try
{
cnn.Open();
InsertCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
cnn.Close();
}
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Hi, I'm using Visio, used "Reverse Engineering" to generate an ERD diagram from database. I edited the diagram and wanted to generate C# code. For instance, I want table "User" maps to "User.cs", how can I do this? Thanks.
|
|
|
|
|
I use CodeSmith[^] to do that type of thing in one step. If you use the .Netiers template, it will generate all of your code and NUnit tests for it all too.
Steve Maier, MCSD MCAD
|
|
|
|
|
Thanks, but I just want to generate setters/getters from ERD or database schema, no DAL needed:
class User {<br />
<br />
protected int _UIN;<br />
...<br />
<br />
public void SetUIN(int value) {<br />
_UIN = value;<br />
);<br />
<br />
public int GetUIN() {<br />
return _UIN;<br />
}<br />
<br />
... more getters/setters ...<br />
<br />
}
Is there such tools?
Norman Fung
|
|
|
|
|
You're just writing your own DAL... I find having it generated for me easier.
Steve Maier, MCSD MCAD
|
|
|
|
|
Thanks Steve. I asked this only because my client demands Enterprise Framework be used for DAL.
Norman Fung
|
|
|
|
|
Hi friends
I have two tables and i want to link them by veiw i am not sure that i can do that in my case so here is example;
table1
CREATE TABLE [book] (
[id_book] [int] IDENTITY (1, 1) NOT NULL ,
[title] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[author] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[publishing] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[discription] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[category_id] [int] NOT NULL ,
[rating] [int] NOT NULL CONSTRAINT [DF__book__rating__2F10007B] DEFAULT (5),
PRIMARY KEY CLUSTERED
(
[id_book]
) ON [PRIMARY] ,
CONSTRAINT [FK_book_category] FOREIGN KEY
(
[category_id]
) REFERENCES [category] (
[id_category]
),
CONSTRAINT [CK__book__rating__300424B4] CHECK ([rating] >= 0 and [rating] <= 10)
) ON [PRIMARY]
GO
table 2
CREATE TABLE [borrow] (
[id_borrow] [int] IDENTITY (1, 1) NOT NULL ,
[book_id] [int] NOT NULL ,
[user_inf_id] [int] NOT NULL ,
[borrow_date] [datetime] NOT NULL ,
[return_date] [datetime] NULL CONSTRAINT [DF__borrow__return_d__36B12243] DEFAULT (null),
[note] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[status] [tinyint] NOT NULL ,
PRIMARY KEY CLUSTERED
(
[id_borrow]
) ON [PRIMARY] ,
CONSTRAINT [FK_borrow_book] FOREIGN KEY
(
[book_id]
) REFERENCES [book] (
[id_book]
),
CONSTRAINT [FK_borrow_user_inf] FOREIGN KEY
(
[user_inf_id]
) REFERENCES [user_inf] (
[id_user]
),
CHECK ([status] >= 0 and [status] <= 1)
) ON [PRIMARY]
GO
example
SELECT TOP 100 PERCENT dbo.book.title, dbo.book.author, dbo.book.publishing, dbo.book.discription, dbo.book.rating, dbo.borrow.status
FROM dbo.book LEFT OUTER JOIN
dbo.borrow ON dbo.book.id_book = dbo.borrow.book_id
The problem is because i want to show only current status of book not all statuses so how to do that.If i use view i get all status of book for example
if i borrow book befour one week and now i take both??
How i can get only the current status ???
Thank u have a nice day
best regards
|
|
|
|
|
Hi,
I am struggling to create a new user in SQL Server 2005. I created a database MyDatabase, and made sa the owner. Was this the correctr decision?
Now I need to create a different login name and password to access the same database. Where do I do this? Do I navigate down the database treeview:
MyDatabase --> Security --> Users
..and then create the user here? When I upload the database and web application to the hosting company I want the web application to use this login information, and not the login for sa.
Please let me know.
Regards,
ma se
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
