Query a dataset - Database Discussion Boards

Re: error adding variable using INSERT INTO

Nino_113-Jun-03 17:52

13-Jun-03 17:52

SomeOne_SurVive wrote:
Open("INSERT INTO moshtarayat1(elsanf) VALUES(mon)",m_pConn.GetInterfacePt

Are you using a stored procedure to add this value?

Or, are you using a form field within an ASP.NET, or ASP page?

How are you getting the value of this variable?

If using a stored proc, the variable should be declared as @mon.

Please post more details !!!!

HTH

Tony

Re: error adding variable using INSERT INTO

Ahmed Galal13-Jun-03 18:02

Ahmed Galal

13-Jun-03 18:02

after alot of tries, i got an clue as below :

CString mon;
lCommand.Format("INSERT INTO moshtarayat1(dates) VALUES('%s')",(CString)mon);
pRs.CreateInstance(__uuidof(Recordset));
pRs->Open((variant_t)lCommand,m_pConn.GetInterfacePtr(),adOpenForwardOnly,adLockOptimistic,adCmdText);
pRs->Update();

----------------------------------
i didn't try ur way yet, but i'll.

thanks for response.

Re: error adding variable using INSERT INTO

Arjan Einbu14-Jun-03 15:17

Arjan Einbu

14-Jun-03 15:17

Sure it will...
If I read this C++ code right, you're sending the following string to the DB:

INSERT INTO moshtarayat1(elsanf) VALUES(mon)

Aren't you trying to send the contents of the mon variable into the DB?
Copy the value of mon into the SQL string, so that it would look like:

INSERT INTO moshtarayat1(elsanf) VALUES(value_of_mon)

where value_of_mon represents the value of

mon<code>.<br />
<br />
(I'm not sure how you combine strings in C++, so no actual sample code...)

Re: error adding variable using INSERT INTO

Ahmed Galal14-Jun-03 19:25

Ahmed Galal

14-Jun-03 19:25

yea, thats right if i'm adding the contents from the code by myself.
but what about if the user is the one who gonna enters it ?
like i copy the contents from and editbox or somthin.

thanks for response

unable to detect primary key

Itanium13-Jun-03 6:02

Itanium

13-Jun-03 6:02

Hi All!!
I m making a generalized class which can handle all type of databases
like Access , SQLServer etc.
So i m using static interaces to declare DataConnection and DataAdapter.
Problem is that i can't get the PrimarKey of DataTable.
PrimaryKey.Length always returns '0'.
any suggestions....

Thanx in advance

sorry for my bad English.

Retrieving sql-queries from a database

Anders Sandberg13-Jun-03 4:26

Anders Sandberg

13-Jun-03 4:26

Hi!

I'm writing an app in VC++ 6 that uses ADO through the #import directive.

There are an unknown number of predefined queries in the database (access)
witch I need to execute and I wonder if there's a way of retrieving the
names of those queries using ADO.

I'm using a Connection Object and a RecordSet Object to obtain the results
of the queries but how can I obtain the queries?

thanks
/Anders

Re: Retrieving sql-queries from a database

basementman13-Jun-03 5:12

basementman

13-Jun-03 5:12

See the replies in the VC forum

<marquee scrollamount="3" scrolldelay="80" direction="right" width="40%" style="border: 2px inset silver;background-color:yellow;color:green;font-family:Verdana,Arial;font-size:8pt;font-style:italic">onwards and upwards...

Query a dataset

Mike Osbahr12-Jun-03 10:48

Mike Osbahr

12-Jun-03 10:48

I have a table that's being populated by a stored procedure. Once the table is populated I need to know the distinct values in some of its columns. I can use foreach loops, but this seems like it would be slow. Is there any way to query a table in a dataset and place the results into another table or an array?

>>>-----> MikeO

Re: Query a dataset

Rocky Moore16-Jun-03 0:58

Rocky Moore

16-Jun-03 0:58

Don't know of any other method. Microsoft does have ADO.NET HELP extention class that is interesting.

http://support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=&KeywordType=any&Titles=false&numDays=&maxResults=25&withinResults=&Queryl=datasethelper&Query=datasethelper&QuerySource=gsfxSearch_Query[^]

Rocky Moore <><

Sql Server registeration error

shalender10-Jun-03 19:21

shalender

10-Jun-03 19:21

Hello All,

I am stuck with sql server my friends. The situation is i am installing sql server 7.0 desktop edition on windows 98 on laptop.i installing the sql server it hanged in between the process.After that i am not able to register my server.

Please any body can help me in this situation.

Thanx & Regards,
Shalender Gandhi.

Help with SQL Server permissions

Tony Truong10-Jun-03 7:37

Tony Truong

10-Jun-03 7:37

We're running mixed mode authentication on our sql server. The SQL server grants access to everyone on the domain. What I'd like to do is restrict table drop access on all accounts except sa. Is there a way to do this? If not, is there a way to restrict table drop access on certain tables to so that no one can ever drop these tables?

Re: Help with SQL Server permissions

Nino_110-Jun-03 17:38

Nino_1

10-Jun-03 17:38

USE DATABASENAME<br />
<br />
GRANT SELECT, UPDATE ON TABLENAME<br />
<br />
TO [DOMAINNAME\useraccount]<br />
<br />
GO<br />
<br />
USE DATABASENAME<br />
<br />
DENY DROP TABLE ON TABLENAME<br />
<br />
TO [DOMAINNAME\useraccount]<br />
<br />
GO

Tony

Re: Help with SQL Server permissions

Tony Truong11-Jun-03 8:40

Tony Truong

11-Jun-03 8:40

I tried the 2nd statement, but get the following error:

Privilege DROP <object> may not be granted or revoked.

I then tried the following command to allow create access which should implicitly deny drop access, however I can't seem to modify the views/tables in design mode because it doesn't have the privledges:

USE DATABASENAME
GRANT CREATE FUNCTION, CREATE PROCEDURE, CREATE VIEW
TO [DOMAINNAME\useraccount]
GO

Anyone have any other ideas/workarounds to deny drop table access for all users except sa (but still allow modify and create access)

Re: Help with SQL Server permissions

Nino_112-Jun-03 13:24

Nino_1

12-Jun-03 13:24

T,
I would then look into the ALTER TABLE T-SQL statement.

I have used this many times on permissions and views and it has saved my a.. more than once.

Sorry couldn't be more helpful !

Tony

AcceptChanges for DataRow

DionChen9-Jun-03 8:35

DionChen

9-Jun-03 8:35

Hi, all:

After I made the update to the database with ONLY the RowState = Deleted rows, I 'd like to AcceptChanges to those deleted row in my datatable. I used the following code to do that. Obviously, this code HAS problem, it changes the Collection while iterating through the collection. Does anyone know a way to AcceptChanges ONLY for rows with Deleted RowState?

**************

foreach( DataRow dr in dsMain1.Tables["LMCables"].Rows )
{
if ( dr.RowState.ToString() == "Deleted" )
{
dr.AcceptChanges();
}
}

****************

Re: AcceptChanges for DataRow

bof16-Jun-03 9:54

bof

16-Jun-03 9:54

The quick answer is to use the DataAdaptor as follows:

myDataAdaptor.Update(myDataSet.myTable.Select(null, null, DataViewRowState.Deleted));

DataViewRowState.Deleted can of course also be changed for other rowstate based selections such as added/modified.

If you end up using these in a sequence and have related tables then note that you should also do the updates in a specific order between parent and child tables: delete child rows, add parent rows, modify parent rows, add child rows, modify child row etc.

It gets more fun if you have a whole hiearchy of tables....

Hope this helps.

arabic data in database

Sarvesvara (BVKS) Dasa8-Jun-03 22:19

Sarvesvara (BVKS) Dasa

8-Jun-03 22:19

Hi,

I want to store in database (ms-access), and display some non-English content in the web site (Arabic). The database stores the english and arabic contents in it. It will pick the respective contents on the user's selection policy.

I made changes at the ASP to make language charset as follows...

ARABIC -
ENGLISH -

And the fonts looks fine when it is seen from MS access. But when I show that in the web-site, it JUST shows as ?????.

What can be the 'missing factor' to make the arabic text look on the site.

Any tag to be added at the asp page to make the site show good with the arabic fonts from the ms-access?

Thanks in advance!

I was born intelligent
Education ruined me!.

Designing a SourceCode Database

Bo Hunter8-Jun-03 9:03

Bo Hunter

8-Jun-03 9:03

I am tring to develope a source code storage app and I can't
figure out how to design the db so that code belongs to a category
of a category. Nested I guess is the word I am looking for.

If I add a category on a tree view and then add a subcategory
how do I create the db and also adding and updating.

This is my first try
one table named sourcecodeinfo and second table named sourcecode
sourcecodeinfo columns
id
category
created
updated

sourcecode columns
id
code
notes
type

the category column has one to many relation like dataaccesscode
then a bunch of code snippets that relate to dataaccess.

But what if I have a category named DataAccess and subcategory
named updates or whatever?

How is this done?

I don't want someone to do the work for me I would like to learn how
myself. I hate it when someone says provide code and thats all they
want and then someone does and then they say I need it in VB or C#.
They want people to do the work for them.

Thank You
Bo Hunter

Re: Designing a SourceCode Database

ZoogieZork8-Jun-03 11:06

ZoogieZork

8-Jun-03 11:06

You can create another table that describes categories, for example:

id        - category id
parent_id - the parent category
name      - the name of the category

Your sourcecodeinfo table would then reference a category ID.

- Mike

Re: Designing a SourceCode Database

Bo Hunter8-Jun-03 18:21

Bo Hunter

8-Jun-03 18:21

Well Mike I feal dummer than dumb. That is too easy.
Thank You very much.

I have done alot of sql and none of oledb
even though they are somewhat the same there
are some differences. Not that has anything
to do with this.

Bo Hunter

When I have not connect to a SQL Server, how can I get a default database name in a DSN?

Peter Keung7-Jun-03 21:54

Peter Keung

7-Jun-03 21:54

As Title

Re: When I have not connect to a SQL Server, how can I get a default database name in a DSN?

basementman9-Jun-03 5:21

basementman

9-Jun-03 5:21

Assuming that this is a SYSTEM DSN, you can look up the registry value named Database under the key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\{DSN_NAME}

If it has been defined, the DSN DB will be stored under this value.

IRowsetIndex on SQLOLEDB

mike martinh6-Jun-03 13:34

mike martinh

6-Jun-03 13:34

Hi,

I was trying to open the IRowsetIndex interface with
OpenRowset function.

The code I have used is similar to the example
in "Chapter 11: Integrated Indexes" in MSDN Library.

With Jet4.0 it works fine.

On SQL Server 2000, next functions returns DB_E_NOINDEX.

hr = pOpenRowset-OpenRowset(
NULL,
&TableID,
&IndexID,
IID_IRowsetIndex,
1,
rgPropSet,
(IUnknown **)&pRowsetIndex);

The index was verified and it exists attached to the SQL
Server table.

How can I work with indexes on SQL Server?

I can create and drop indexes with OLE DB technology but I cannot use them.

Any idea will be appreciated.

Thanks in advance.
Mike Martin

DataSet binding

haimon156-Jun-03 4:09

haimon15

6-Jun-03 4:09

hi
i have binded a set of textboxes to a DataSet and when i change the value in the textbox the value in the dataset also updating but the RowSate remains 'Unchanged' so when i invoke the OleDbAdapter.Update method it doesn't recognize any changes so the meta data in the datasource remains unchanged

maybe the DataSet do AcceptChanges() Automaticly when i change the value of the binded textbox?

can you help? Roll eyes | :rolleyes:

-- Directly From Zion --
------ Haimon15 ------

Re: DataSet binding

John Kuhn6-Jun-03 9:31

John Kuhn

6-Jun-03 9:31

Are you working in Web Forms or in Windows Forms?

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.