Help at asp.net [vb]

[tynum]

---

PROBLEM:
unsaon nku pag kuha sa values sa akong na query para ma display nku sa web... newbie pa ko sa asp.net mga bro kay PHP ako gamit previously nya tungud aning trabaho nku karon.. nag nid man cla ug asp.net mao nag kat-on pa ko...

SAMPLE CODE IN PHP:

$result = mysql_query("select e_name, age from employee where emp_id = 001");
$row = mysql_fetch_array($result);
$name = "$row[e_name]";

echo $name;


SAMPLE CODE IN ASP.NET:

dim name as string
dim strsql as string = " select e_name, age from employee where emp_id = 001"

i.operation.database.executenonquery(strsql)

name = "[ value unta ni e_name diri ]"

response.write(name)


unsaon ni nku mga bro?? tabang pls... lamat daan...

[moz_k2]

Dapay naay modawat sa result sa imo query.

Try to look for ResultSet or Dataset in MSDN.

[tynum]

bai... unsay requirements sa dataset?? grabe wa may lami ang explanation sa MSDN...

[bryanarzaga]

SqlConnection1.Open()
SqlSelectCommand1.CommandText = "SELECT * From TBL_WireTransfers WHERE WireTransID = '" & Session("WireID") & " '"
Me.WireTransferDetailsDataSet1.Tables("TBL_WireTra nsfers").Clear()
SqlDataAdapter1.SelectCommand = SqlSelectCommand1
SqlDataAdapter1.Fill(Me.WireTransferDetailsDataSet 1, "TBL_WireTransfers")
SqlDataAdapter1.Fill(Me.WireTransferDetailsDataSet 1)

Dim objReader As SqlDataReader
Try
If SqlConnection1.State = ConnectionState.Closed Then
SqlConnection1.Open()
End If
objReader = SqlSelectCommand1.ExecuteReader(CommandBehavior.Cl oseConnection)
If objReader.Read Then
'Me.lblMemName.Text = "Member Name: ".ToUpper & objReader("theThirdPartyAccName").ToString

Me.Label2.Text = "Financial: " & objReader("W_Financial").ToString
Me.Label3.Text = "Phone Number: " & objReader("W_PhoneNum").ToString
Me.Label4.Text = "Address: " & objReader("W_Address").ToString
Me.Label5.Text = "City: " & objReader("W_City").ToString
Me.Label6.Text = "State: " & objReader("W_State").ToString

End If
objReader.Close()
Catch ex As Exception
End Try



sample rani ok

[tynum]

lamat bai ha... try nya ni nku... nagka problema ko sa pag gamit sa DATASET.... pwede pa tudlu unsaon pag gamit?? paminaw sad nku ang sunud nku na problema aning DATASET kay kaning SqlDataReader lamat kay imo na nahatag... hehe.. need jud bai na mu agi pa ka aning:

SqlSelectCommand1.CommandText = "SELECT * From TBL_WireTransfers WHERE WireTransID = '" & Session("WireID") & " '"

Dim objReader As SqlDataReader
SqlDataAdapter1 as SqlAdatper
SqlDataAdapter1.Fill(Me.WireTransferDetailsDataSet 1)

objReader = SqlSelectCommand1.ExecuteReader(CommandBehavior.Cl oseConnection)



dili diay pwede na sa executenonquery() ka mu kuha sa mga queried values para ma display

[bryanarzaga]

unsa imu gamit na version sa studio? 03 05 08?

[bryanarzaga]

lamat bai ha... try nya ni nku... nagka problema ko sa pag gamit sa DATASET.... pwede pa tudlu unsaon pag gamit?? paminaw sad nku ang sunud nku na problema aning DATASET kay kaning SqlDataReader lamat kay imo na nahatag... hehe.. need jud bai na mu agi pa ka aning:

SqlSelectCommand1.CommandText = "SELECT * From TBL_WireTransfers WHERE WireTransID = '" & Session("WireID") & " '"

Dim objReader As SqlDataReader
SqlDataAdapter1 as SqlAdatper
SqlDataAdapter1.Fill(Me.WireTransferDetailsDataSet 1)

objReader = SqlSelectCommand1.ExecuteReader(CommandBehavior.Cl oseConnection)



dili diay pwede na sa executenonquery() ka mu kuha sa mga queried values para ma display

daghan way mu query naa in ani pud naa tinapulan diretso e bind sa txtbox/label

[tynum]

unsa imu gamit na version sa studio? 03 05 08?

2005 ako gamit bai... ingon ka bai na daghan ways para mu query.... site daw some examples na imo nahibaw-an... ako nahibaw-an kay executenonquery() ug getdatatable() ra.... unsa pay lain ways

[bryanarzaga]

2005 ako gamit bai... ingon ka bai na daghan ways para mu query.... site daw some examples na imo nahibaw-an... ako nahibaw-an kay executenonquery() ug getdatatable() ra.... unsa pay lain ways

yep pero unsa man imu gusto e achieve? asa nimu e display ang data? saun raman tanan kung datagrid saun gani, kana ako g post dli man gani na databinding its just passing values sa textbox pero pwede gani sa session states nimu e transfer ang queried db record.

sa 05 naa na ra ghapun ang ang drag drop sa database pero mu himu sya ug table daan, unlike sa 03 e drag nimu ang database from the server explorer dropped as connection string with a data adapter then generate dataSet,

[tynum]

bai mka bind ba ka ug queried values padung sa textbox gamit sa executenonquery()?? kung mka bind ka... unsaon??