sql server 3.5

[lankaudaranga]

con.Open(); string select = "select * from main_stock where stockid='" + comboBox1.Text + "'"; SqlCeCommand selcom = new SqlCeCommand(select, con); SqlCeDataReader reader = selcom.ExecuteReader(); reader.Read(); if (reader.HasRows == true) { MessageBox.Show("error"); } con.Close(); this code work access databse but sql server 3.5 compact server notwork

[Colin Angus Mackay]

lankaudaranga wrote:

this code work access databse but sql server 3.5 compact server notwork

What do you mean by "not work". Exactly, how does it not work? What is the error you get?

Recent blog posts: *SQL Server / Visual Studio install order *Installing SQL Server 2005 on Vista *Crazy Extension Methods Redux * Mixins My Blog

[lankaudaranga]

EROOR massege display "hasrow" not supports

[AhsanS]

You should had posted the full error description. Any hows do it this way if(dr.Read()) { //your code here }

Ahsan Ullah Senior Software Engineer

[lankaudaranga]

YES reader.Read(); if (reader.HasRows == true) { MessageBox.Show("STOCK ID ALREADY EXITS", "ERROR", MessageBoxButton.OK, MessageBoxImage.Error); comboBox1.Text = ""; comboBox1.Focus(); } BUT ITS NOT WORK :(

[Colin Angus Mackay]

lankaudaranga wrote:

reader.Read(); if (reader.HasRows == true)

NO! That is not what was told to you.

if(reader.Read()) // Doesn't require HasRows
{
// your code here
}

Recent blog posts: *SQL Server / Visual Studio install order *Installing SQL Server 2005 on Vista *Crazy Extension Methods Redux * Mixins My Blog

[lankaudaranga]

i want to send data to database but data not duplicate(hasraw==true) if (reader.HasRows == true) { //data already exite no data insert.display massege ..... } else { enter data(insert data } {you undastand this)

[Colin Angus Mackay]

Yes, I understand you. However, you don't seem to understand me. To spell it out:

if (reader.Read())
{
// There is data - do something
}
else
{
// There is no data - do something else.
}

So, as you can see, and as I explained earlier, you do not need HasRows.

Recent blog posts: *SQL Server / Visual Studio install order *Installing SQL Server 2005 on Vista *Crazy Extension Methods Redux * Mixins My Blog