Database Discussion Boards

First Prev Next

Re: DataTable > DataView > ComboBox?

work_to_live27-Jan-05 13:18

work_to_live

27-Jan-05 13:18

I ended up handling the Underlying DataTable RowChanged event, and as you suggested, re-bound the combobox to the DataView. It seemed so cumbersomb that I thought there must have been a better way.

Thanks for the reply.

Re: DataTable > DataView > ComboBox?

work_to_live27-Jan-05 13:22

work_to_live

27-Jan-05 13:22

Oops... I hope I didn't mislead you... I'm not changing the column names, I'm changing the content of a column in one of the rows of the DataTable. When I do that, the new value doesn't propogate to the combobox. If I add a new row to the DataTable, everything propogates as I expected.

connecting to the data source

Civic0624-Jan-05 1:38

Civic06

24-Jan-05 1:38

I have a VC++ application when executed gives the following message "[Microsoft][ODBC Microsoft Acess Driver]'(unknown)'". How do I fix this?

Re: connecting to the data source

David Salter24-Jan-05 10:26

David Salter

24-Jan-05 10:26

Looks like your ODBC connection string may be incorrect. What is it set to?

Affordable and reliable hosting? Click here!

Re: connecting to the data source

Civic0624-Jan-05 11:58

Civic06

24-Jan-05 11:58

below is the part where it tries to connect to the data source...and fails to connect
nConnect = SQLDriverConnect( m_hDBC, NULL, psvSource, SQL_NTS, szConnectOutput, sizeof(szConnectOutput), &nResult, SQL_DRIVER_NOPROMPT);

Re: connecting to the data source

David Salter24-Jan-05 22:20

David Salter

24-Jan-05 22:20

That looks OK. What is psvSource set to?

Affordable and reliable hosting? Click here!

Re: connecting to the data source

Civic0625-Jan-05 16:25

Civic06

25-Jan-05 16:25

_TUCHAR *psvSource=new _TUCHAR[ strlen( svSource )+1 ];

It is really weird. I've also checked in the control panel to see if the MS Access driver was listed as a data source.

May be i can email you the files? I am new to this site. Is there a way to attach the files on this site so u don't have to give your email address to me?

Re: connecting to the data source

David Salter28-Jan-05 5:39

David Salter

28-Jan-05 5:39

psvSource needs to be set to a DSN that you have registered in ODBC administrator. If you haven't specified one, that is probablky why you can't connect.

Database FAQ

Add store procedure to database

El'Cachubrey23-Jan-05 19:43

El'Cachubrey

23-Jan-05 19:43

Hi all

Please delight me how add store procedure file (*.sql) to my database.
Only way what i find out to add stored procedures is through Server Explorer window, but i yet had an file with ones (been generated third-part tool) and now i want to get acess to procedures which allocated in this file.

Thank.

Re: Add store procedure to database

Mike Dimmick24-Jan-05 1:23

Mike Dimmick

24-Jan-05 1:23

Use Query Analyzer to run the script.

Stability. What an interesting concept. -- Chris Maunder

ADO Connection to an Access 2000 DB with a DB password?

Mike the Red21-Jan-05 4:39

Mike the Red

21-Jan-05 4:39

I'm using ASP on a IIS server, trying to connect to a MS Access 2000 database.

All is fine until I set a database password, and then IIS tells me "Not a valid password."

I've tried using "PWD=<password>" in the ConnectionString, but the PWD key is for a user password. I found something in the microsoft KB that suggested "DATABASE PWD=<password>" might be the answer, but, alas, IIS still replies "Not a valid password."

Has anyone faced this problem before? Anyone know how to overcome it? (Other than removing the db password)

Thanks in advance for any help.

Re: ADO Connection to an Access 2000 DB with a DB password?

David Salter22-Jan-05 1:36

David Salter

22-Jan-05 1:36

Have you tries this:

http://www.asp101.com/tips/index.asp?id=98[^]

Affordable and reliable hosting? Click here!

Moving data

Member 23350920-Jan-05 23:19

Member 233509

20-Jan-05 23:19

Hi,
I have a problem, I need to move large numbers of data/multiple tables from a Mainframe DB/2 to a SQL server.
What is the best possible way?
Can I use VB.NET and dataadapers to do this? The larger tables consists of more than 25 milj. rows.

Happy to get any kind of help

Regards
JPalm

Re: Moving data

Colin Angus Mackay20-Jan-05 23:49

Colin Angus Mackay

20-Jan-05 23:49

I don't know anything about DB2, but if you have an ODBC driver for it you can do the whole thing in SQL Server using DTS (Data Transformation Services).

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

Searching in a disconnected dataset

hendriks20-Jan-05 4:50

hendriks

20-Jan-05 4:50

Hi,

In a disconnected dataset (dsAdressen) I have to search for a specific record. I want to do this with it's Primary Key (PK).
At designtime I created a connection (cn), dataadapter (daPersonen) and dataset (dsAdressen)
When loading the form I do the following

cn.open
daPersonen.Fill(dsAdressen)
cn.close

When I try to search for a specific record with it's primary key I use code like

dsAdressen.Personen.FindByPersoonsID(1)

When I show the found value in a messagebox it's showing the right record

MsgBox(dsAdressen.Personen.FindByPersoonsID(1).Voornaam)

but my textbox, for which I set the databindings property at designtime in the property pane (txtVoornaam=dsAdressen.Personen.Voornaam), does not show the found value. I thought that by setting this property my textbox should automatically show the found value in the dataset.

I can use code like this to show the value in the textbox, but I should say that is not the way

dim dr ad Datarow
dr = dsAdressen.personen.rows.find(1)
txtVoornaam.text = dr("Voornaam")

I do not understand

Thanks
Hendrik Jan

Re: Searching in a disconnected dataset

descola22-Jan-05 22:37

descola

22-Jan-05 22:37

Try using a CurrencyManager

Dim cm as CurrencyManager = CType(Me.BindingContext(table), CurrencyManager)

table.DefaultView.Sort = "PrimaryKey"

cm.Position = table.DefaultView.Find(PK)

This should cause value in the selected row to display in the databound TextBox

Darrell A Escola, MCDBA, MCAD

Generate Insert Statement

Sebastien Lachance20-Jan-05 3:18

Sebastien Lachance

20-Jan-05 3:18

Is someone know the way to generate Insert script of a couple of selected record in a databae ? To after execute to script on another databse/server ?

sebastien.lachance.blogspot.com

Re: Generate Insert Statement

Colin Angus Mackay20-Jan-05 22:42

Colin Angus Mackay

20-Jan-05 22:42

Sorry, but that makes no sense. Can you try describing your problem again?

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

Re: Generate Insert Statement

Sebastien Lachance21-Jan-05 3:45

Sebastien Lachance

21-Jan-05 3:45

Sorry, I will try again. I have a Select statement that select some records. Then I want to send those record on another database. So I wanted to generate a Insert Script, that "Insert" those record.

My english is not so great, but I try to become better. Sorry. OMG | :OMG:

sebastien.lachance.blogspot.com

Re: Generate Insert Statement

Colin Angus Mackay21-Jan-05 4:00

Colin Angus Mackay

21-Jan-05 4:00

Sebastien_Lachance wrote:
My english is not so great

That's okay - I read some of your blog and it looks like your English is very good. I guess you were just typing in a hurry.

Sebastien_Lachance wrote:
I have a Select statement that select some records. Then I want to send those record on another database. So I wanted to generate a Insert Script, that "Insert" those record.

If the two tables have the same columns then the easiest thing is:

INSERT INTO [DestinationDatabase].[dbo].[DestinationTableName]
SELECT *
FROM [SourceDatabase].[dbo].[SourceTableName]

You can, of course, use any select statement that returns the data you need.

Does this help?

Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.

Any tutorial/link on developing applications for Windows CE .NET using C#

amittinku19-Jan-05 18:44

amittinku

19-Jan-05 18:44

Any tutorial/link on developing applications for Windows CE .NET using C#

Query

Yulianto.19-Jan-05 16:31

Yulianto.

19-Jan-05 16:31

I have a table with:
partId, location, quantity.
1 ,a ,12
1 ,b ,10

What is the query to make :
partId, quantity a, quantity b.
1 ,12 ,10

There are only two location, a and b.
Do you get it?

<italic>Work hard and a bit of luck is the key to success.

You don`t need to be genius, to be rich.

Re: Query

Mike Ellison19-Jan-05 17:26

Mike Ellison

19-Jan-05 17:26

Hi there. It depends on the database you're using. Here's one way in SQL Server:

select partId, sum(quantityA) as a, sum(quantityB) as b
  from 
 (
  select partId
         ,case (when location='a' then quantity else 0) as quantityA
         ,case (when location='b' then quantity else 0) as quantityB
    from myTable
  ) x
  group by partId

Re: Query

Yulianto.19-Jan-05 18:00

Yulianto.

19-Jan-05 18:00

Thanks a lot

<italic>Work hard and a bit of luck is the key to success.

You don`t need to be genius, to be rich.

a problem about resultset from a procedure

luobo19-Jan-05 16:01

luobo

19-Jan-05 16:01

Hi,I have a problem when I try to get resultset from a procedure.
if there is only select statement in my procedure,it works fine.
but if I add a insert statement in procedure,pRst->GetState() will return adStateClosed

develop environment:
vc6+MDAC2.7
sql server 2000

here is the procedure code:

create table tem(t_id int,t_date datetime)
go
insert tem select 1,dateadd(minute,1,getdate())
go
drop proc pTest
go
create proc pTest
as begin
--insert tem select 2,dateadd(minute,2,getdate()) --if I add this line,it won't work
select * from tem
end
go

here is the ado code:

_ConnectionPtr pConn;
_RecordsetPtr pRst;
_CommandPtr pCmd;

pConn.CreateInstance(__uuidof(Connection));
pCmd.CreateInstance(__uuidof(Command));
pRst.CreateInstance(__uuidof(Recordset));
....
try
{
pCmd->CommandText = "pTest";
pRst = pCmd->Execute(NULL,NULL,adCmdStoredProc);
//pRst = pConn->Execute("pTest",NULL,adCmdText);
//both of above return adStateClosed
}
catch (_com_error &e)
{
....
}

thanks

Last Visit: 31-Dec-99 18:00 Last Update: 11-May-24 19:42

Refresh

ᐊ Prev 1...2154 2155 2156 215721582159 2160 2161 2162 2163 Next ᐅ

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