|
DanielLopez wrote:
Public Function GetTeam(TeamID As Integer) As String
Dim sql As String
sql = "SELECT Name FROM Teams WHERE TeamID = " & TeamID
GetTeam = ExecuteQuery(sql, True)(0)
End Function
Rewrite the above function as ...
Public Function GetTeam(TeamID As Integer) As String
Dim sql As String
Dim rs as ADODB.Recordset
sql = "SELECT Name FROM Teams WHERE TeamID = " & TeamID
set rs = ExecuteQuery(sql, True)
GetTeam = rs.Fields(0)
End Function
Grant @ Loki
|
|
|
|
|
I have a datagrid and its connected to database ,I use this funcion to save changes to
datasource from datagrid:
private void btnSave_Click(object sender, System.EventArgs e)
{
deletedRows=null;
updatedRows=null;
insertedRows=null;
try
{
deletedRows =myDataSet.GetChanges(System.Data.DataRowState.Deleted);
if (((deletedRows) != (null)))
{
myOleDbAdapter.Update(deletedRows,"Companies");
}
updatedRows = myDataSet.GetChanges(System.Data.DataRowState.Modified);
if (((updatedRows) != (null)))
{
myOleDbAdapter.Update(updatedRows,"Companies");
}
insertedRows =myDataSet.GetChanges(System.Data.DataRowState.Added);
if (((insertedRows) != (null)))
{
myOleDbAdapter.Update(insertedRows,"Companies");
}
myDataGrid.ReadOnly=true;
}
catch(Exception myE)
{
MessageBox.Show("Problem!!" + myE.ToString());
}
}
For the first time it works ok but second time I unhandle error thrown:
---------------------------
---------------------------
System.Data.OleDb.OleDbException: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
at WindowsApplication3.Form1.btnSave_Click(Object sender, EventArgs e) in f:\visual studio projects\projectc#\windowsapplication3\form1.cs:line 219
---------------------------
OK
---------------------------
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
I want to check if my connection is close or not but Close() does not return any value.
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
Do you mean, check if Close() has REALLY closed the connection, or check at any given time if a particular connection object is open ?
in the latter, what about setting the connection object to null after calling Close(), and then check if the object is null when you are about to use it ?
Andres Manggini.
Buenos Aires - Argentina.
|
|
|
|
|
Andres Manggini wrote:
Do you mean, check if Close() has REALLY closed the connection, or check at any given time if a particular connection object is open ?
No,I want to open it if I close it in another places in my program.
Andres Manggini wrote:
in the latter, what about setting the connection object to null after calling Close(), and then check if the object is null when you are about to use it ?
This is good idea.
I looked into MDSN and found ConnectionState ,but I couldn't find out how to work with it,the example in MSDN is not good one,like always;)
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
Yeah, that work too..
That property can take to values:
The allowed state changes are:
Property Value
A bitwise combination of the ConnectionState values. The default is Closed.
From Closed to Open, using the Open method of the connnection object.
From Open to Closed, using either the Close method or the Dispose method of the connection object.
[C#]
public void createOleDbConnection()
{
OleDbConnection myConnection = new OleDbConnection();
myConnection.ConnectionString = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;";
myConnection.Open();
MessageBox.Show("Connection State: " + myConnection.State.ToString());
myConnection.Close();
}
this helps ?
Andres Manggini.
Buenos Aires - Argentina.
|
|
|
|
|
Andres Manggini wrote:
public void createOleDbConnection()
{
OleDbConnection myConnection = new OleDbConnection();
myConnection.ConnectionString = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;";
myConnection.Open();
MessageBox.Show("Connection State: " + myConnection.State.ToString());
myConnection.Close();
}
This is the one MSDN,and I said I see this before,the problem is that how to check the condition state not convert to string.
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
I think you're looking for the System.Data.ConnectionState enum.
Andy Gaskell, MCSD MCDBA
|
|
|
|
|
AndyG wrote:
I think you're looking for the System.Data.ConnectionState enum.
Yes,If you read all the thread you figure out that the problem is that I need an example for that.
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
Sure....
OleDbConnection thisIsNotRocketScience = new OleDbConnection();
if(thisIsNotRocketScience.State == System.Data.ConnectionState.Closed)
WriteTehL33tC0des();
else
WriteEv3nl33t3rC0dez();
Andy Gaskell, MCSD MCDBA
|
|
|
|
|
Thanks Andy,
AndyG wrote:
WriteTehL33tC0des();
I could not find it in MSDN,Is that somrthing in your codes?
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
I have been reading up on the various ways of installing the actual database on client's SQL servers.
What methods are you using? What did you consider to be the best way?
Michael
|
|
|
|
|
You are talking about your Database or the Server?
Regards
Carlos Antollini.
Sonork ID 100.10529 cantollini
|
|
|
|
|
Installing the database (its tables, stored procedures) onto an already existing SQL Server 2000.
Michael
|
|
|
|
|
Michael:
I always prepare a SQL Script, with the creation of the Tables, Stored Procedures, Views, Groups, minimal Users if is necessary, Permits by Group, etc....
Then I prepeare another script with the initial data if that is required.
And Ready...
I work for A Very Important Bank in the World, when I need to implement a new Application we make That, because I have no Access to Production, And those Scripts are run by the operators of the data center...
Carlos Antollini.
Sonork ID 100.10529 cantollini
|
|
|
|
|
Thats the method I'm thinking of using. I was just interested to know how everybody else does it. First time I've deployed an SQL server app since the days of SQL Server 6.5.
Michael
|
|
|
|
|
Yes is the more common method... I travel for all the world and I know that the developer use the scripts to implment the SQL Databases....
I make that from SQL Server 4.0 or 4.2 I don't remember the version..
Regards
Carlos Antollini.
Sonork ID 100.10529 cantollini
|
|
|
|
|
hi all,
I want to using .cdb file in the PocketPC.(ADO using in the Windows CE 3.0). if anyone know please send samples me..
thanks .
MFC
|
|
|
|
|
I am working on a small application server for updating customer orders. Multiple clients (in sales department) can be connected to the server do create orders, and browse the orders.
I used conventional TCP/IP way to send data back to client. I created a ADO Recordset in my application, and pass the first 50 rows to the client, so the client can navigate the rows. However, when it beyongs the first 50, i have to do MoveNext() in the server. I doubt that my manipulation will fail in maintaining a row_no in the client where the client navigated up to. Can someone tell me a better way to handle the client side cache issue, and make it *current *position synchronized with the application server's Ado Recordset position.
By the way, I'm using VC++ 6.0 , SP5. Oracle 8i
|
|
|
|
|
When your client has 50 record the cursor can only move up to 50 rows,Your client does not any more thing to navigate in it.
Your cursor can not be in both server and client ,it is placed in one of them.(Check adUseClient and adUseServer for that.) so you can move in one of them,so what's your problem now?
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
Hi, I'm pretty new on this.
I created a SDI application and used database support.
When then my workspace is created I put on my CFormView derived class some edit controls and then I want to call with SQL statements my database (Acces database) so it can retreve data from column Age. There is 4 columns but thats not the problem how to write the SQL statement. The problem is HOW to call, which method??
In class Cdatabase there is a method called ExecuteSQL but I only have a CRecordset derived class in my workspace... how to use that ExecuteSQL?? or does CRecordset have a similary method???
Do you understand me?
------------------------------------
Rickard Andersson, Suza Computing
ICQ#: 50302279
I'm from the winter country SWEDEN!
------------------------------------
|
|
|
|
|
This is one of my codes that read records from database and check records,if you have any problem with this code just ask
CDatabase aDB;
try
{
aDB.OpenEx(_T("DSN=test"),CDatabase::openReadOnly | CDatabase::noOdbcDialog);
CRecordset aRS(&aDB);
aRS.Open(CRecordset::forwardOnly,"SELECT *from Table1");
while(!aRS.IsEOF())
{
CString strValue;
aRS.GetFieldValue(1,strValue);
if(strValue=="Mazdak")
{
CString str;
aRS.GetFieldValue(2,str);
m_rich.SetSel(0,-1);
m_rich.ReplaceSel(str,true);
return;
}
aRS.MoveNext();
}
aRS.Close();
aDB.Close();
}
catch(CDBException *ex)
{
TCHAR buf[255];
ex->GetErrorMessage(buf,255);
CString strPrompt(buf);
AfxMessageBox(strPrompt);
}
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
This should work in a dialog based app, shouldn't it?
If yes, You're an angel!!
------------------------------------
Rickard Andersson, Suza Computing
ICQ#: 50302279
I'm from the winter country SWEDEN!
------------------------------------
|
|
|
|
|
Rickard Andersson wrote:
This should work in a dialog based app, shouldn't it?
This will work anywhere you want not only in dialog based app.
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
hm... if I want two buttons on my dialog, button 1 is gonna "send" a different SELECT to the database then button 2. Can I just close it and the open again or is it a bad way? If yes, I can't find any other solution for that.
And how can I do so that my users of my application not need to make a DSN in the Controlpanel by their own??
------------------------------------
Rickard Andersson, Suza Computing
ICQ#: 50302279
I'm from the winter country SWEDEN!
------------------------------------
|
|
|
|
|