173 Posted Topics
 | huummm your code is write but there is only two three mistakes. Try this one for searching purpose. [CODE] Private Sub Find_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ''open the connection dim str as String dim ds as Dataset Dim da as SqlDataAdapter str="Select * from [Application] … |
| | if you want the child form in your Mdi Parent form then try this code . it will not come out of that mdi parent form.you have to just set the Mdi parent for your child form. let X be the Mdi Parent and Y,Z be the Chile then [CODE] … |
| | Many of the student don't know how to find connection string, if they find then there will be some mistake. it's a simple idea to find connection string try it. and vote for it how to find connection string of any database or any server like, access or sql or …  |
 | first globally create one data adapter that is [CODE] dim myadapter1 as DataAdapter ''and whenever you want to use write in procedure myAdpter1=new DataAdapter ''after your code for first DataGridView ''at the end of 1 DataGridView write myAdpter1.Close myAdpter1=nothing ''then further write myAdpter1=new DataAdapter '' end so on. [/CODE] |
 | hummm for valdation of datetimepicker write code on the dtppicker of change event for eg. it sholud be today or greater then today dtp.value <= Now.Date \\\dtp is name of control  |
| | hey, you had created one inner join from two table it means you had created one view for that. you never insert data in view. so if you want to insert data in that inner join. batter is insert data in that two table. after that you see that view … |
| | in you code there is mistakes quotes so write true code. write your code like this [CODE] sqlsearch = "SELECT * FROM [setting] WHERE [mname] LIKE ' " & TextBox.Text & " ' ;" [/CODE] try this code. |
| | in ms access there is one data type for auto number use that for auto numbering. |
| | hii if you want to search date from database then formate the date value [CODE] dim dt as date dt=FormatDatetime(dtp1.Value,ShortDate) [/CODE] try this one |
| | hii rmontgomery write your code with the sql transaction. after deleting the data commit the transaction. then it will remove successfully try this. if thread is sole mark as a solve |
| | huunm on the textboxid keydown event or leave event of the that you can check the value given by the user like if in db theres' is 1,5,6,9,8,6 while in any of the one event I'll write the code [CODE] dim str as string,sqlstr as string,ans as boolean con.open() ''write … |
| | hello i have big problem on sending Message to mobile. i had created one application where i'm storing the All the information of customer now when they placing order i want to send them message of their bill amount. and bill date. but i'dont no how to send message on … |
| | hii your code is right but what do you want from this. that i can't understand . if you want to use the same code in your two three form then create one class module and pass the vale at their and retrieve by creating a object. |
| | hello everyone i had created 5-6 crystal report in my vb.net project with back end sql server 2005 and i had given my path for crystal report. after this i had creted setup and deployed at customer machine but there it dosn't shows any report instead of it gives an … |
| | Re: SQL Problem try this [code] Dim SQLCon As New SqlServerCe.SqlCeConnection Dim SQLCom As New SqlServerCe.SqlCeCommand dim str as string,i as boolean SQLCon = New SqlServerCe.SqlCeConnection("Data Source = BK.sdf") SQLCon.Open() str=""INSERT INTO [Current Rentals](MemberID,DVDID,DaysonRent,DateRented,DueDate,TotalPrice,Overdue,DaysOverdue,OverduePrice) VALUES('" _ & trim(tbmemberId.text) & "','" & Trim(tbDVDID.Text) & "','" & trim(Cint(cbdays.text)) & "'_ & trim(getdate(),Dateadd(days," & trim(Cint(cbdays.text)) & … |
| | |
| | hello every one i had created one application front end as vb.net and back end is Access 2003. after this i had created a setup of that application. it perfectly work on my computer but when i am installing setup on my friends computer it install and run time it … |
| | in .Net we have to first Open the file where we have to put our data like [code] Dim FILE_NAME As String = "C:\test2.txt" If System.IO.File.Exists(FILE_NAME) = True Then Dim objWriter As New System.IO.StreamWriter(FILE_NAME) objWriter.Write(TextBox1.Text) objWriter.Close() MsgBox("Text written to file") Else MsgBox("File Does Not Exist") End If [/code] Another one … |
| | can anyone tell me how to convert this code to vb.net it's vb6.0 code and gives error in vb.net [CODE] Dim a As Integer Dim b As Boolean Do While Not b And a < cmbcust.ListCount If UCase(Left(cmbcust.List(a), Len(txtname.Text))) = UCase(txtname.Text) Then cmbcust.ListIndex = a b = True End If … |
| | hello every one when I'm Updating a table in access it gives syntax error in update statement can any one help how to sole this problem[CODE] vbstr = "UPDATE EmpMaster SET Name= '" & UCase(txtname.Text) & "',Address='" & Trim(UCase(txtadd.Text)) & "',TeleNo='" & txttel.Text & "',MobileNo='" & txtmob.Text & "',E-mail='" & … |
| | can any one help me for inserting a record in access table me code gives an error of overflw[CODE] dim vbstr as string vbstr = "insert into EmpMaster Values ('" & txteid.Text & "','" & UCase(txtname.Text) & " " _ & "','" & UCase(txtadd.Text) & "','" & txttel.Text & "','" … |
| | if u want to change your connection string at run time. then create one txt file and put you connection string in that file and use file handling to read the connection from that file keep that variable Global for each connection now when you want to change a computer …  |
| | please help me someone i have two text box in ,my form and i want to retrieve databased on the 3 text box condition. so i'm doing like this code dim con as sqlconnection dim ds as dataset, dim da as sqldataadapter dim cmd as sqlcommand 'on textbox key down … |
The End.