|
Hi there!
I have a activex dll written in vc++ 6.0
There is one function that needs to receive a Ado Recordset from a VBasic application. It seems that after the VB does the call to the function, the ADORecordset loses at least one property: Sort.
The function is receiving the ADORecordset as an IDispatch.
Any ideia is a good idea to this problem...
Thanks in advance.
António Carvalho
|
|
|
|
|
Hey guys, how do I:
SELECT AVG(SomeDateTimeColumn) FROM TimeLog WHERE EMPID=12345
Any useful script for lazy me? Thanks in advance.
Norman Fung
|
|
|
|
|
i don't understand neither your question nor your explaining sql query...
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
You can't AVG a datetime. I am not sure what you are getting at.
|
|
|
|
|
hi
i need code 4 currency convertor
automatic convert the currency
4 payment in online hotel reservation
thanx
viren
|
|
|
|
|
virendra kumar wrote:
i need code 4 currency convertor
 It is a simple multiplication or division. Also, this question does not seem to have anything to do with databases.
Source currency * or / exchange rate = destination currency.
e.g. Pounds Sterling to US Dollars. Exchange rate: £1 == $1.87
£5 * 1.87 = $9.35
or US Dollars to Pounds Sterling
$10 / 1.87 = £5.34
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
virendra kumar wrote:
online hotel reservation
Maybe you need this.[^]
<italic>Work hard, Work effectively.
|
|
|
|
|
|
In my database i got:
ID, Name, Type, Comment
But when i fill to grid. my Columns reorder:
Comment, ID, Name, Type
But i want to have an ordier like in database. How can be done.
I used the tutorial on web:
http://www.c-sharpcorner.com/Tutorials/OleDbDataAdapterDesign.asp
I am using Jet 4.0 as connection
I have noticed if i change select statment, but there isn't any effect.
I hope i dit posted this on correct forum.
Can anybody help me. Thanks in advance.
|
|
|
|
|
I think the problem is in your grid. How do you fill the grid?
<italic>Work hard, Work effectively.
|
|
|
|
|
dgCDList->DataSource = core->databaseDataSet->CD;
core->oleDbCDData->Fill(core->databaseDataSet);
|
|
|
|
|
I need to set up a mail account for reporting services in SQL 2k
can anyone point me to some information
Thanks Paul
|
|
|
|
|
Hi all,
I would be most grateful of some help !!!!
I have a number of Text boxes (including a rich text box) and I simply want to insert the data into an access DB.
I have made a ADO.net connection, adapter and then it has generated a dataset (using GUI not code). I can display the data but just can’t find a good explanation of the statement needed to insert into DB
Any Help would be fantastic !!!!
Thanks
Martin
|
|
|
|
|
|
Hi,
Sorry to bother you but i am unfamiliar with C# and am still having big difficulty.
I need a very basic step by step help.
Would be most grateful
Thanks
Martin 
|
|
|
|
|
C# uses the .NET framework, as does VB.NET. The API calls will be the same. Perhaps if you could break down exactly what you're finding hard - do you know anything about SQL to start with ? Do you know anything about how ADO.NET works ? Did you know how to bind a data source to a data grid, or did you copy the code from somewhere ?
If I have an idea of your skill level, and what bits you're struggling with, perhaps I can be more specific.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi,
I have no SQL experience !
I know the basics of ADO.NET i.e. create a connection adapter and dataset this can then be used to bind to datagrid, listbox ...
However i have no idea about how to work with connections.
Thanks for all your help !
Martin
|
|
|
|
|
Try this[^] as an intro into the overall code you need, and the SQL Insert page I linked you to before for info on the Insert statement generally. So long as you have a database already that expects the values you want to write, you should be fine. Make sure you're providing a value for each column in the row you're creating, unless a default value exists.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hye There
I have created one user in SQL Server and it has rights in two different databases at a time. Now I want to script the user. the option available is to script with in database by right clicking on the database then script. I want to scrip the user to get rights on all the databases togather.
Any Comments
|
|
|
|
|
|
Hi All,
When bound datagrid to some table, edit a cell in a row and press SAVE button(on my toolbar) to update it. it doesn't update the row being edited, until we focus on row below it or above it.
Regards,
sorry for my bad English.
|
|
|
|
|
hi, i have a code works with oracle sql i want to change the problem in it that doesn't work with sql2000 soplease any one help me
the sql statement is:
select folderindex, NAME, PARENTFOLDERINDEX from pdbfolder
connect by prior FOLDERINDEX=PARENTFOLDERINDEX
start with PARENTFOLDERINDEX = " + indexx + "
order by(PARENTFOLDERINDEX)
it gives me an error on line to when i test it on the sql 2000 query analyzer so what is the solution :->
Thanks alot
Mohammad Daba'an
|
|
|
|
|
Hi,
Anybody knows if it's better in an application to do a "for {}" statement and so segment, for example, 30000 results in 1500 parts (+ or - don't mind, it's the idea) to do an sql insert or doing a unique process witch treat all the results ??
for example
for (int myI = 0; myI < 30000; myI += 1500)
{
here storedprocedure in wich i take items between myI and myI +1500) and so use a portion of these items
...
SqlDataReader dr = MaCommande.ExecuteReader(CommandBehavior.CloseConnection);
(1500 items are read)
while ( dr.Read()) {process action}
}
or directy use all results classically (stored procedure without between)
...
SqlDataReader dr = MaCommande.ExecuteReader(CommandBehavior.CloseConnection);
(30000 items are read)
while ( dr.Read()) {process action}
Witch solution is better ?
Thanks for your reply
Christophe
Christophe
|
|
|
|
|
|
thank you very much Colin
Christophe
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
