how to retreave data?

[enjoycrack]

it looks like ur datareader has no rows in there, you have to make sure the datareader has data before retrieving from it just try to debug and see which line causes this problem << >>

[pandapatin]

the line is: txtnama.Text = CStr(dr("nama")). how to make sure that the datareader has row?did't if check it with: If dr.HasRows = False Then ' error mesej Else txtnama.Text = CStr(dr("nama"))

[enjoycrack]

put the break point there, debug and open the quick watch to see the datareader object....And one more thisng, the field name is correct or not? << >>

[pandapatin]

the name field is correct.it return nuthing.one thing how should the stored proc look?

[enjoycrack]

it's obviously that no data in DB, so before you assing the value retrieved from datareader, you have to check if it's null or not... << >>

[pandapatin]

there is a data in the db.can u show me the write stored proc?My stored proc look like this : dbo.sp_getUser ( @noPekerja varchar(50) ) AS SELECT lec.* FROM lec WHERE (lec.noPekerja = @noPekerja) Is it rite?

[enjoycrack]

the way you check your store is that you call this store in sql query analyzer and check the returned result is correct or not... << >>

[Kas_Aspnet]

You should not use the CommandBehavior.CloseConnection in your case. Remove this and close the reader explicitly after getting all the data from the reader. Happy programming. Kas_Aspnet

[store_cold]

If dr.HasRows = False Then ' error mesej Else 'if there is only one row while dr.read txtnama.Text = CInt(dr("nama")) txtjawatan.Text = CInt(dr.item("jawatan")) txtjabatan.Text = CInt(dr.item("jabatan")) txtbidang.Text = CInt(dr.item("jabatan")) txtjabatan.Text = CInt(dr.item("jabatan")) end while 'if there is only one row while dr.nextresult txtnama.Text += CInt(dr("nama")) txtjawatan.Text += CInt(dr.item("jawatan")) txtjabatan.Text += CInt(dr.item("jabatan")) txtbidang.Text += CInt(dr.item("jabatan")) txtjabatan.Text += CInt(dr.item("jabatan")) end while End If Else :)

[Horscht i]

If the problem is that the TextBoxes don`t get filled with data (this was my problem few days ago), try: SqlDataReader Reader = null; SqlConn.Open(); Reader = SelectData.ExecuteReader(); while (Reader.Read()) { Txt_ProjectTitle.Text = Convert.ToString(Reader[1]).Trim(); ButtonListProjectType.SelectedValue = Convert.ToString(Reader[2]); DropDownList_ProjectStatus.SelectedValue = Convert.ToString(Reader[3]); [and so on...] } Reader.Close(); SqlConn.Close(); It is C# code though, but should be easy to read. I think you just have to put this while loop around the if/else commands. while (dr.Read()) { If dr.HasRows = False Then ' error mesej Else txtnama.Text = CInt(dr("nama")) txtjawatan.Text = CInt(dr("jawatan")) txtjabatan.Text = CInt(dr("jabatan")) txtbidang.Text = CInt(dr("jabatan")) txtjabatan.Text = CInt(dr("jabatan")) End If Else 'error } -- modified at 7:54 Tuesday 14th March, 2006

[Ista]

Kas_Aspnet wrote:

You should not use the CommandBehavior.CloseConnection in your case

Yes he should 1 line of code equals many bugs. So don't write any!!