Camner Nk Convert Oledb - Sql Command

[fieda 0]

A'kum dan slm sejahtera,

Saya nk mintak tlg pd sesape yg tau nk convertkan command dlm olDb ke sql.

Command ni sebenarnye nk select info dr database dan paparkan. cthnye bila select ID user akan dipaparkan Name, Add dll

cth codingnye dlm oleDb mcm kt bwh nih:

oleDbDataAdapter1.SelectCommand.Parameters["state"].Value = txtStateParameter.Text;

dsAuthors1.Clear();

oleDbDataAdapter1.Fill(dsAuthors1);

if(this.BindingContext[dsAuthors1, "query"].Count == 0)

{

MessageBox.Show("No authors found in " + txtStateParameter.Text);

txtStateParameter.Focus();

}

else

{

ShowPosition();

}

private void ShowPosition()

{

int iCnt;

int iPos;

iCnt = this.BindingContext[dsAuthors1, "query"].Count;

iPos = this.BindingContext[dsAuthors1, "query"].Position + 1;

if(iCnt == 0)

{

txtPosition.Text = "(No records)";

}

else

{

txtPosition.Text = iPos.ToString() + " of " + iCnt.ToString() ;

}

}

harap sgt ader yg sudi membantu........

-TQ-

[DevGuy 0]

ni sure C# or C++.net.

ok solution dia senang jer. just make sure taruk kat atas sekali

imports system.data.sqlclient

then tukar jerla..jadi macam ni

SQLDataAdapter1.SelectCommand.Parameters["state"].Value = txtStateParameter.Text;

tu jer. for ur references

oledbConnection - sqlConnection - ODBCConnection

oledbCommand - sqlCommand - ODBCCommand

oledbDataAdapter - sqlDataAdapter - ODBCDataAdapter

oledbDataReader - sqlDataReader - ODBCDataReader

ok this for u references.but remember in vs.net 2005 this thing was change to other method.BTW u still canuse this

ik good luck fieda

[fieda 0]

ni sure C# or C++.net.

ok solution dia senang jer. just make sure taruk kat atas sekali

imports system.data.sqlclient

then tukar jerla..jadi macam ni

SQLDataAdapter1.SelectCommand.Parameters["state"].Value = txtStateParameter.Text;

tu jer. for ur references

oledbConnection - sqlConnection - ODBCConnection

oledbCommand - sqlCommand - ODBCCommand

oledbDataAdapter - sqlDataAdapter - ODBCDataAdapter

oledbDataReader - sqlDataReader - ODBCDataReader

ok this for u references.but remember in vs.net 2005 this thing was change to other method.BTW u still canuse this

ik good luck fieda

←

[fieda 0]

Thanks a lot devguy...

saya dh cuba apa yg u explain but still cannot success.

dlm saya punye kod tu perlu ubah apa lagi agaknye?

[DevGuy 0]

cuba paste all code..

ok i try to fix it. but this one c# ker c++

oklah send k

[DevGuy 0]

jap this one u used coding ker u just drag n drop oledbdataadapter1.

tgk dari code ni sure u drag n drop dari tool tu kan. mmg la tak berjaya.except u buat bali tapi pilih sqldataadapter and drag kat form u tu..

faham tak. cuba try k..

i though u use coding tadi.

[fieda 0]

Utk pengetahuan sedara, saya guna C# dan memang saya drag sqldataadapter tu dari tools dan set coding dia.

actually, saya dh try tukar semua syntax oledadataadapter - sqldataadapter dan semua yang perlu diubah mcm dataset dr dsAuthors - dataSet11 dan sbgnya.

first error yg keluar

sqlDataAdapter1.SelectCommand.Parameters["ID"].Value = txtStateParameter.Text

pas tu saya tukar jadi cam nih

this.sqlConnection1.Open();

string select = "SELECT * FROM REGISTER WHERE ID = txtStateParameter.Text";

SqlCommand cmd = new SqlCommand(select, this.sqlConnection1);

dataSet11.Clear();

sqlDataAdapter1.Equals(dataSet11);

if(this.BindingContext[dataSet11, "query"].Count==0)

{

MessageBox.Show("No authors found in " + txtStateParameter.Text);

txtStateParameter.Focus();

}

else

{

ShowPosition();

}

pas tu keluar lak error kat sini if(this.BindingContext[dataSet11, "query"].Count==0)

so sedara...boleh tlg tak.. tak pun saya try attachkan cth projek saya tu tapi mintak le email

Anyway, TQ

[DevGuy 0]

Utk pengetahuan sedara, saya guna C# dan memang saya drag sqldataadapter tu dari tools dan set coding dia.

actually, saya dh try tukar semua syntax oledadataadapter - sqldataadapter dan semua yang perlu diubah mcm dataset dr dsAuthors - dataSet11 dan sbgnya.

first error yg keluar

sqlDataAdapter1.SelectCommand.Parameters["ID"].Value = txtStateParameter.Text

pas tu saya tukar jadi cam nih

this.sqlConnection1.Open();

string select = "SELECT * FROM REGISTER WHERE ID = txtStateParameter.Text";

SqlCommand cmd = new SqlCommand(select, this.sqlConnection1);

dataSet11.Clear();

sqlDataAdapter1.Equals(dataSet11);

if(this.BindingContext[dataSet11, "query"].Count==0)

{

MessageBox.Show("No authors found in " + txtStateParameter.Text);

txtStateParameter.Focus();

}

else

{

ShowPosition();

}

pas tu keluar lak error kat  sini  if(this.BindingContext[dataSet11, "query"].Count==0)

so sedara...boleh tlg tak.. tak pun saya try attachkan cth projek saya tu tapi mintak le email

Anyway, TQ

←

Edited October 4, 2004 by DevGuy