sushilsth

thanx buddy, i also learned from your mistakes.. thanks again..

array (size=4) 0 => array (size=7) 'id' => string '75' (length=2) 'room_name' => string 'Economy ' (length=8) 'no_of_room' => string '0' (length=1) 'price' => string '500' (length=3) 'description' => string 'asdfasf' (length=7) 'image' => string '' (length=0) 'hotel_id' => string '1' (length=1) 1 => array (size=7) 'id' => string '70' …

i am actually working for showing online for loged in user. This is my code: $qt="select userid from plus_login where tm > '$tm' and status='ON'"; $result = mysql_query($qt); while($row=mysql_fetch_array($result)) { $uid = $row['userid']; $qt1="select first_name, last_name from signup where user_id='$uid'"; $result1 = mysql_query($qt1); while($rows=mysql_fetch_array($result1)) { $_SESSION['name']=$rows[0]." ".$rows[1]; echo $_SESSION['name']."<br>"; } …

any suggestion would be great helpful.. thanx in advance..

<?php $query=mysql_query("SELECT model_no,images1 FROM nokia"); echo"<div>"; while ($img = mysql_fetch_array($query)) { echo $img[0]; echo "<img src = cms/pages/images/".$img[1].">"; } echo"</div>"; ?> what is actually wrong in my code.. its not displaying images($img[1]) but it displays the content 'model_no' ie. $img[0]. plz any sugesstion would be greatly helpful...

Private Sub btnsave_Click(sender As Object, e As EventArgs) Handles btnsave.Click 'to check if the records already exists... Dim sqlQRY As String = "SELECT COUNT(namee) AS namecount from staff WHERE namee='" & TextBox7.Text & "'" Dim queryResult As Integer Dim com As New OleDbCommand(sqlQRY, conn) queryResult = com.ExecuteScalar() If queryResult > …

Private Sub Form16_Load(sender As Object, e As EventArgs) Handles MyBase.Load Dim sqlquery As String = "SELECT SUM(price) AS totalprice FROM expenses" Dim sqlcommand As New OleDbCommand With sqlcommand .CommandText = sqlquery .Connection = conn .ExecuteNonQuery() End With Label2.Text= 'totalprice that is SUM(price) End Sub i want to display sum(price) in …

Private Sub Button11_Click(sender As Object, e As EventArgs) Handles Button11.Click Dim sqlquery As String = "INSERT INTO firstfloor_house_rent (datee,amt) VALUES ('" & DateTimePicker8.Text & "', " & TextBox24.Text & ")" Dim sqlcommand As New OleDbCommand With sqlcommand .CommandText = sqlquery .Connection = conn End With ans = sqlcommand.ExecuteNonQuery() If (ans …

Private Sub btnsave_Click(sender As Object, e As EventArgs) Handles btnsave.Click Dim com As New OleDbCommand() ' Try Dim fs As New FileStream(str, FileMode.Open) Dim data() As Byte = New [Byte](fs.Length) {} fs.Read(data, 0, fs.Length) fs.Close() 'readed image Dim name As New OleDbParameter("namee", OleDbType.VarChar, 50) name.Value = TextBox7.Text Dim address As …

I have boolean value either class a or class b.. if those given condition are fulfilled then i want to have class a label in my report else class b. but when i inserted below format in formula field then i got error. this is just a sample. plz provide …

Private Sub btnload_Click(sender As Object, e As EventArgs) Handles btnload.Click Dim sqlquery As String = "select frmStudentReg.regno,nursery.rollno,[nursery.nepali(writing)],[nursery.nepali(oral)],[nursery.maths(writing1)],[nursery.maths(oral)],[nursery.maths(writing2)],[nursery.english(writing)],[nursery.english(oral)],[nursery.physical_edu(oral)],[nursery.creative(oral)] from frmStudentReg,nursery where frmStudentReg.regno=nursery.regno" Dim sqlcommand As New OleDbCommand Dim sqladapter As New OleDbDataAdapter Dim table As New DataTable With sqlcommand .CommandText = sqlquery .Connection = conn .ExecuteNonQuery() End With With sqladapter .SelectCommand …

this code in form load event... Dim sqlquery As String = "select * from frmStudentReg" Dim sqlcommand As New OleDbCommand Dim sqladapter As New OleDbDataAdapter Dim table As New DataTable With sqlcommand .CommandText = sqlquery .Connection = conn .ExecuteNonQuery() End With With sqladapter .SelectCommand = sqlcommand .Fill(table) End With For …

hi, i have 12 groupbox in each tabcontrol page. And i want to keep all groupbox in same location of same size overlapping each other. I want to make one function and apply to all groupbox. So that my code wouldnot be lengthy. But i didnot get idea to do …

Sub loadtodgv() Dim sqlquery As String = "select * from nursery" Dim sqlcommand As New OleDbCommand Dim sqladapter As New OleDbDataAdapter Dim table As New DataTable With sqlcommand .CommandText = sqlquery .Connection = conn .ExecuteNonQuery() End With With sqladapter .SelectCommand = sqlcommand .Fill(table) End With DataGridView1.Rows.Clear() For i = 0 …

Dim i1 As Integer Dim i2 As Integer For i1 = 0 To Me.DataGridView5.Columns.Count - 1 For i2 = 0 To Me.DataGridView5.Rows.Count - 1 If String.IsNullOrEmpty(Me.DataGridView5.Item(i1, i2).Value) Then MessageBox.Show("You must fill in all cells before you can save the data.", "Empty Cells", MessageBoxButtons.OK, MessageBoxIcon.Information) DataGridView5.Rows(i1).Cells(i2).Style.BackColor = Color.Bisque 'Index was out …

For i = 0 To DataGridView1.Rows.Count - 1 ' Dim row1 As Integer = DataGridView2.Rows(i).Cells(1).Value.ToString Dim row1 As Integer = Nothing Dim row2 As String = Nothing Dim row3 As String = Nothing Dim row4 As String = Nothing Dim row5 As String = Nothing Dim row6 As String = …

Private Sub one_btninsert_Click(sender As Object, e As EventArgs) Handles one_btninsert.Click For i = 0 To DataGridView1.Rows.Count - 1 Dim row1 As Integer = Val(DataGridView1.Rows(i).Cells(1).Value.ToString) Dim row2 As String = DataGridView2.Rows(i).Cells(2).Value.ToString Dim row3 As String = DataGridView2.Rows(i).Cells(3).Value.ToString Dim row4 As String = DataGridView2.Rows(i).Cells(4).Value.ToString Dim row5 As String = DataGridView2.Rows(i).Cells(5).Value.ToString Dim row6 …

Private Sub btnupdate_Click(sender As Object, e As EventArgs) Handles btnupdate.Click Dim myindex As Integer Dim reg As Integer Dim roll As Integer Dim nepaliw As Integer Dim nepalio As Integer Dim mathw1 As Integer Dim matho As Integer Dim mathw2 As Integer Dim engw As Integer Dim engo As Integer …

Grpnursery.Top = 38 Grpnursery.Left = 20 grpone.Top = 38 grpone.Left = 20 i have 15 groupbox in my form and i want them all to be in same position in form. How to make a function of position and all call to all the controls.. function position() dim grp as …