20,285 Topics
 | |
| | I'm just trying to connect vb.net application to my cpanel web host space's mysql database. I got some idea from internet and tryied. But It doesn't work for me. If you know about this help me. I think it was great help for others too. my whole code is this … |
| | Hi Ive got 3 listboxs In Listbox 1 I have a list of names, listbox2 a list of days. These lists have been put into arrays _names & _days. What Im trying to do is join the 2 lists with a delimiter of "-" then display the joined lists in …  |
| | hi i currently facing this prblem" the connection was not closed. the connection's current state is open" how to solve it Imports System.Data.OleDb Public Class frmOrderSummary Dim con As OleDbConnection Dim selected_Row As Integer Dim selected_ID As String Dim order_id, food_id, orderdate, quantity, food_name As String Const CONNECTION_STR As String … |
| | imports system.data.sqlclient mysqlconn = New SqlConnection mysqlconn.ConnectionString = "Data Source=" + txtServerName.Text + ";initial catalog=" + txtdatabasename.Text + ";initial catalog=" + txtshardacc.Text + ";user id=" + textusername.Text + ";password=" + txtpassword.Text Dim queryresult As Integer Try mysqlconn.Open() command = New SqlCommand("select COUNT (*) as numRows from _Char Where CharName16='" & …  |
| | How to make picturebox from form to picturebox rdlc reportviewer vb.net Imports Microsoft.Reporting.WinForms Public Class BCPrint Private Sub BCPrint_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'PNJKDCDataSet.tbl_Pat_Image' table. You can move, or remove it, as needed. Me.tbl_Pat_ImageTableAdapter.Fill(Me.PNJKDCDataSet.tbl_Pat_Image) 'TODO: This line of … |
| | I'm new to vb and therefor I can't find where is the error while I'm making reports. I coded My report button like this : Dim adapter As New MySqlDataAdapter Dim ds As New DataSet1 adapter.SelectCommand = New MySqlCommand("Select * from mcs.custormer", Form1.mysqlcon) adapter.Fill(ds.Tables(0)) ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local ReportViewer1.LocalReport.ReportPath = System.Environment.CurrentDirectory … |
 | Hi Dw. I'm trying to read a text file. This text file has a multiply lines and what I want is that I want to separate each line or should I say I want to split each line (chop it) so that I will be able to assign these fields … |
| | Hi friends, Please I am writing an app that is meant to work like WhatsApp. When a user type some text, he clicks a send button. The clicking sends the text to a central database. There is a timer that is checking for unread messages and display them in a … |
| | What is the code for adding/multiplying numbers as per quantity and rate? |
| | Hello everyone please your help with the correct syntax of this code i´ve just build it but the visual studio has closed the session and i lost all my work the code as you can see search between two dates that part its ok, and then search in another field … |
| | At the bottom is my code and I want to save data on my joined table. Please advise or edit the codes. Thanks :D 'VB.net Public Class RadTechLP Private Sub RadTechLP_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'PNJKDataSet.Procedure1' table. You …  |
| | I'm looking more and more about answer for my question. When I open mysql query browser first time, there is place that we can create new mysql connection. I want to create connection like this. In the 4 computers connected to a LAN network. I name these computers A,B,C,D for … |
| | 'Private Sub ComboBox1_SelectionChanged(ByVal sender As System.Object, ByVal e As System.Windows.Controls.SelectionChangedEventArgs) Handles ComboBox1.SelectionChanged ' Dim cmd As New SqlClient.SqlCommand ' Dim tbl As New DataTable ' Dim da As New SqlClient.SqlDataAdapter ' Dim code As Integer ' Dim ds As New DataSet ' Dim sql_empid As String = cmbaaa.SelectedValue.ToString ' Try … |
| | value of life certificate is not updating through this code. myconn.Open() cmd.Connection = myconn cmd.CommandText = " UPDATE Pension_Master SET l_cer='" & l_cer & "',validfrom=convert(datetime,'" & validfrom.Date & "',101)," & _ "validto=convert(datetime,'" & validto.Date & "',101) WHERE ppo_no = ' " & TextBox1.Text & "'" If (payment_register.Visible = True) Then …  |
| | i have a problem.. now when i execute a Query From Visual Studio 2012 at Sql Button it gives to me The results as 1 Rows affected like this pic >> photo Link : http://imgur.com/OqzaKqq but when i execute the Same query From my Program it give me this message … |
| | Hi I can add watermark text on a .pdf document to an absolute position. This time I want to add water text of small font size to cover all of the page including margins. I know that I need relative positioning of text, fitting text to text lines depending on … |
| | Hey,now i need to Replace this text "Kelvin.1337" From textbox1.text....By meaning when i write into textbox1.text a word i need to change Kelvin.1337 to the word which i wrote it into textbox1.text photo link: http://imgur.com/5EOsMob but i got problem when i write the word it delete all text and appear … |
 | I am importing data from excel into datagridview its kind of working fine. my data is like this in excel 10001 MR NEW 10002 MR OLD 10003 MR CLEAN 1MB21 MR DIRTY 1BA12 MR DIXON 1EA12 MR RYDER When I load the data all is loaded untill it gets to … |
| | hello this code for add the auto number form the access table to the form vb but But it only works when the table contains data but when the table is empty does not work and the bill number appears a blank Sub New() InitializeComponent() Try Dim BillNo As New … |
| | hi all, I am having a problem with importing images into Database with code. I've done this so far Dim conn As New Data.SqlClient.SqlConnection("Data Source=virtualmachinelink,1433;Network Library=DBMSSOCN;Initial Catalog=School Management;User ID=me;Password=mypass") 'dont worry about the connection string, is good, Dim SDA As New SqlDataAdapter Dim bSource As New BindingSource Try conn.Open() Dim …  |
| | Hi i have a conflict with a string i want some words of a string to make lowercase shal i have as string Valkenburg Aan De Geul But i want it to make it as Valkenburg aan de Geul the folowing code dos not work ang gives a conflict If … |
| | Hello All, I am fairly new to Vb.net. I have experience in MS Access and VBA. I am trying to connect a remote Oracle Database through vb.net but getting the below error. But, the same Oracle database connecting with the help of SQL Developer. Can any one please help me? … |
| | Dear... I'm doing INVENTORY PROJECT... I'm using ACCESS as BACK-END... My tables are PURCHASE and SALES... In PURCHASE table, fields are CODE(primary key), PRICE, DATE, TOTAL, QTY... when I'm entering datas in form and when i click submit, the datas stored... but when i enter same DATA(CODE), it is showing … |
| | In my vb.net programm there is problem occure while connectiong to network. my connecrion string was : con.ConnectionString = "User Id=root;server=//192.168.8.101;password=mysql;database=moneycs" This shows : "unable to connect to any of the specified mysql hosts" error messege. Please help me guys |
| | I have data grid view named dgv. So below I called dgv. There are 5 columns in dgv. For 2 columns I load data from one mysql table. For another 3 cloumns I want to load mysql table with where query matching with firts two columns. For that I want … |
| | I want to make 6 digit number and put it number of count at data grid view 1. Currently I used below code. This show numbers like 1,2,3,4,5..... like.... For Each row As DataGridViewRow In DataGridView1.Rows Dim obj(row.Cells.Count - 1) As Object For i = 0 To row.Cells.Count - 1 … |
| | Hi Friend, dtpdate datetime that's my field and datatype in vb.net use dtpdate.text Error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. please solve my problem. Thanks & Regards |
| | I have two RadioButton and Two Checkbox which represents things that holds a value in decimal example price! The user has to choose from either of the radiobutton and also from either of the checkbox. I have a button to culculate the total! I'm using if else statement but got … |
| | Hey I need to know if I can convert.my full vb project to #c? If I can how I can do it |
| | Hi, Does anyone have some good examples of ADO.NET code that demonstrates a coded connection to SQL Server such that bound controls bind to retrieve and update data. Thanks |
The End.