Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
40% Quality Score
Upvotes Received
1
Posts with Upvotes
1
Upvoting Members
1
Downvotes Received
2
Posts with Downvotes
2
Downvoting Members
1
1 Commented Post
0 Endorsements
~10.1K People Reached
Favorite Tags
Member Avatar for Hawk123

i can't get DateTimePicker to insert into Access databse. I've tried all the suggestion i can find from this forum, so i'm thinking my problem is different? my table has a column date which has a Date/Time format my code [CODE] Dim cmd As OleDbCommand Dim sqlstr As String, ans …

Member Avatar for izzah_3
0
3K
Member Avatar for sushilsth

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' …

0
110
Member Avatar for sushilsth

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>"; } …

Member Avatar for diafol
0
202
Member Avatar for sushilsth
Member Avatar for sushilsth

<?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...

Member Avatar for kgavhane12
0
368
Member Avatar for sushilsth

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 > …

Member Avatar for tareywolf
0
193
Member Avatar for sushilsth

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 …

Member Avatar for xerohomicide
0
141
Member Avatar for sushilsth

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 …

Member Avatar for Reverend Jim
0
275
Member Avatar for sushilsth

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 …

Member Avatar for deceptikon
0
170
Member Avatar for sushilsth

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 …

Member Avatar for Reverend Jim
0
116
Member Avatar for sushilsth

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 …

Member Avatar for Begginnerdev
0
263
Member Avatar for sushilsth

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 …

Member Avatar for ss125
-1
981
Member Avatar for sushilsth

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 …

Member Avatar for ShahanDev
0
136
Member Avatar for sushilsth

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 …

Member Avatar for sushilsth
0
201
Member Avatar for sushilsth

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 …

Member Avatar for ddanbe
0
346
Member Avatar for sushilsth

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 = …

Member Avatar for sushilsth
0
459
Member Avatar for sushilsth

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 …

Member Avatar for Begginnerdev
0
3K
Member Avatar for sushilsth

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 …

Member Avatar for M.Waqas Aslam
0
184
Member Avatar for sushilsth

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 …

Member Avatar for ddanbe
0
85