467 Posted Topics

Member Avatar for sashiksu

A little addition with AleMonteiro's post you can also use DateAdd() fuction to get your desired date. The syntax is `DateAdd(DateInterval As Microsoft.VisualBasic.DateInterval,Number As Double,DateVAlue As Date)` LabelEndDate.Text = DateAdd(DateInterval.Day, Val(TextBox1.Text), dtploanstart.Value)

Member Avatar for AleMonteiro
0
302
Member Avatar for sashiksu

Your error should be at line no 37. `cmd.Parameters.AddWithValue("@Business_Name)", Convert.ToString(txtbusinessname.Text))` You made an extra charecter in parameter declaration `"@Business_Name)"`

Member Avatar for Santanu.Das
0
456
Member Avatar for Abdelaziz_1

your query should be "insert into SK_Silk (JID,silk_own) Values (("Select JID From TB_User where StrUSerID='" & TextBox1.Text & "'") ," & Val(TextBox2.Text))

Member Avatar for Santanu.Das
0
716
Member Avatar for bayron209

To count record nos. the syntax is select count(*) from <TableName> Where <Condition> To get the number of records the syntax is Dim x as Integer = .ExecuteScalar() or Int x =.ExecuteScalar()

Member Avatar for bayron209
0
703
Member Avatar for sashiksu

Is `con` one and only one connection object in your project and already opened it at the time of starting of your application ? If it is, don't open it in every procedure or function because you already opened it at the time of your application has started and close …

Member Avatar for sashiksu
0
2K
Member Avatar for Angelito_1
Member Avatar for Prashanth K M
Member Avatar for J Michael

In your loop you must have to insert some code lines to choose for feeding new page or not. To do this you will have to use `args.HasMorePages = True / False` In DW here is a rich codesnippet library, from there you can read this [snippet](https://www.daniweb.com/programming/software-development/code/444231/printing-text-with-word-wrap).

Member Avatar for Santanu.Das
0
786
Member Avatar for Parth_3
Member Avatar for Parth_3
0
310
Member Avatar for Parth_3
Member Avatar for Santanu.Das
0
317
Member Avatar for Parth_3

hericles is correct. Firstly you called the function without parameter value. Secondly codes in function UserExit() need some change. No need to use datareader. Just you have to sure any value exist or not in the table. I just change in your codes, you can use it if you want. …

Member Avatar for Santanu.Das
0
302
Member Avatar for Parth_3
Member Avatar for Santanu.Das
0
75
Member Avatar for Parth_3

Hi Partha: welcome to Daniweb. This is too much complicated coding, very simple. Please show the jobs you tried to find text from database and failed. We are always ready help you to correct your miscodings or process to get your desired result. thanx.

Member Avatar for Santanu.Das
0
83
Member Avatar for KushMishra

I am sorry to make response after two weeks. I do not understand how could you implement Cut, Copy, and Paste on Combobox or other objects except Textbox / RichTextBox. WPF uses a number of prebuilt commands. The designers of wpf realized that every application is likely to have a …

Member Avatar for Santanu.Das
0
2K
Member Avatar for Ralph Anthony

Use oledbdatackmmand object, asign command text and execute it to delete the data row. From my opinion you used here a wrong sql statement I.E."Delete * from [userinfo]". It should be "Delete From [userinfo] Where <condition here>". Hope it can help you.

Member Avatar for Santanu.Das
0
484
Member Avatar for JModak
Member Avatar for vuyiswamb

Normally every form level events are declared privately. So you can not access them from another form or page . To do this you can create procedure publicly in a module or class and call it from any where in your application.

Member Avatar for Santanu.Das
0
193
Member Avatar for jaai
Member Avatar for themaj

1) You can copy and paste your desired files from one project folder to another project folder by using windows explorer, but through visual studio's solution explorer you must have to add them to your project as existing file otherwise the project would not attach them into it and you …

Member Avatar for Santanu.Das
0
313
Member Avatar for David_64

You can add buttons dynamically and add handler with them to search the appropriate record from database. The textproperty of the button should be `acsdr("tableno")`. After clicking the button, serch records on basis of the text property of the button or sender. Hope it can help you.

Member Avatar for David_64
0
207
Member Avatar for hallianonline

You have to write the code line no 7 I.E. myprod = !reci_prod_code within do loops before comparison with Text1.Text. Hope it can help you.

Member Avatar for ez4u2c
0
319
Member Avatar for Papa_Don

"Dim data() As String = {"box1", "box2", "box3"}" Here box1,box2,box3 are not the names of the variables, they are string 3 values of the string array data(). You can declare it as Dim data(2) As String data(0)="box1" data(1)="box2" data(2)="box3" But to store data in an array by using a loop …

Member Avatar for Papa_Don
0
1K
Member Avatar for hefaz

Microsoft Ribbon Control is not made for vb or c# .net application. You could not use it directly. You can use it for your wpf application. If you want to use it in vb or c# .net application you must have to create a user control by wpf.

Member Avatar for rproffitt
0
549
Member Avatar for Miurei

You have wrote a wrong code lines to search usertype at line 16 in the if - end if statement. If dr.Read = True Then 'Wrong searching codes here Else End If You already read data by calling ExecuteReader(). So, why are you calling an another Sal statement? You already …

Member Avatar for Miurei
1
7K
Member Avatar for Christopher_12

Agreed, with Jim. Using Parameterized Query you can prevent your database system from malicious SQL Injections. > "column name or number of supplied values does not match table definition" From my opinion, the number of textboxes do not match with total number of fields. Please check & compair your data …

Member Avatar for Miurei
0
360
Member Avatar for Johnny Joe

Do not understand the need of the codes from line 5 to 15. I can asume that they are not for add button. You already declare the connection object in line 16. So no need of the lines 18 & 19. You can remove them. Next lines are right to …

Member Avatar for Miurei
0
647
Member Avatar for farahinsamsudin

Do not find the execution of command of the command object in both editing and deleting procedure. After asigning parameters you will have to use **cmd.ExecuteNonQuery()** method to update your datatable. And also you will have to use a semicolon **;** to run multiple SQL query by a single command …

Member Avatar for Miurei
0
243
Member Avatar for nosfa

From my opinion you do not write the connection string properly. Please follow this [site](http://www.connectionstrings.com/sql-server/).

Member Avatar for Miurei
0
358
Member Avatar for VIPER5646

Please post the codes for configuration method. From my opinion you must have to check that config method thoroghly.

Member Avatar for VIPER5646
0
266
Member Avatar for NurieDavis

Please post the related code you did and desribe the problem what you are facing. Forum can try to give you a suggession/ way to solve your problem.

Member Avatar for Santanu.Das
0
170
Member Avatar for sing1006

To copy data from one table to another you must have to sure that the fields structure of those tables are same like fields name and data type . Then the syntax is Insert Into My_Table1_Name Select * From My_Table2_Name But if you want to insert some selective data then …

Member Avatar for Santanu.Das
0
291
Member Avatar for A1990

You can do it by adding an another condition in Where clause. Try If txtBoxSettingNewPassword.Text = txtBoxSettingConfPassword.Text Then con.Open() cmd.Connection = con cmd.CommandType = System.Data.CommandType.Text cmd.CommandText = ("UPDATE [User] " & _ "SET password = '" & (txtBoxSettingNewPassword.Text) & "'" & _ "WHERE user_name ='" & (txtBoxSettingUserName.Text) & "' And …

Member Avatar for Santanu.Das
0
176
Member Avatar for jovstudios

You can use the following example. only make sure that the interval property of the timer control is 1000 miliseconds Public Class Form1 Dim sec As Integer = 0 Dim min As Integer = 0 Dim hr As Integer = 0 Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles …

Member Avatar for Santanu.Das
0
452
Member Avatar for zachattack05

In If statement a Boolean variable/method/functon always checks True, by default. But, when you call it alone or attach a ! with it, it depands on the structure of your coding style or on your requirment.

Member Avatar for JOSheaIV
0
577
Member Avatar for Jacktheclimber

PLease, read the followings you can get a conception about the convertion from decimal to binary, octal, hexa and vice-versa. [http://home.iitj.ac.in/~ramana/pds/number_systems.pdf](http://home.iitj.ac.in/~ramana/pds/number_systems.pdf) [http://www.cs.ucf.edu/courses/cop3502h.02/binay_octal_Hex.pdf](http://www.cs.ucf.edu/courses/cop3502h.02/binay_octal_Hex.pdf) [http://www.math-only-math.com/conversion-of-binary-numbers-to-octal-or-hexa-decimal-numbers.html](http://www.math-only-math.com/conversion-of-binary-numbers-to-octal-or-hexa-decimal-numbers.html) [http://www.rapidtables.com/math/number/Numeral_system.htm](http://www.rapidtables.com/math/number/Numeral_system.htm) [http://math.stackexchange.com/questions/541253/hexadecimal-to-octal-and-vice-versa](http://math.stackexchange.com/questions/541253/hexadecimal-to-octal-and-vice-versa)

Member Avatar for vegaseat
0
201
Member Avatar for kermie

In this regard, my experiance in not so good. I purchased a Nokia XL mobile at Dubai for my personal purpose, but at Kolkata it didn't support the warrenty. This depands on the jurisdiction area where you are pruchasing.

Member Avatar for jwenting
0
101
Member Avatar for James_43
Member Avatar for ddanbe
0
287
Member Avatar for papadakiss

Please try it Dim sql As String = "Select SUM(orders_amount) As Amount FROM orders WHERE inquiries_ref ='" & TBOrdersCustomer.Text & "'"

Member Avatar for tinstaafl
0
340
Member Avatar for Mheljun

There are some mistakes in conception to read data from datareader object. If the **reader** contains no data it can't give you any result. So, you have to check first it contains any record or not. The codes should be MysqlConn = New MySqlConnection MysqlConn.ConnectionString = "server=localhost;userid=root;password=root;database=taihsin_inventory" Dim Reader As …

Member Avatar for Santanu.Das
0
247
Member Avatar for rony001

Please, show your efforts to do your job first, then forum could give you a suggestion to solve.

Member Avatar for Santanu.Das
0
1K
Member Avatar for Dani

I have surprised. In morning it was the old, now it is new one. I like it. Design is cool. A great effort Dani. Keep it up. In log in page , Login button,s alignment should be right aligned.

Member Avatar for Dani
4
640
Member Avatar for Arun_14

Here I just post here a simple example of calculation Public Class Form1 Dim runningtotal As Double = 0.0# Dim add As Boolean = False Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click If add Then runningtotal += Val(TextBox1.Text) Else If Not String.IsNullOrWhiteSpace(TextBox1.Text) Then runningtotal = Val(TextBox1.Text) End …

Member Avatar for Santanu.Das
0
182
Member Avatar for fugio

Make a loop form 1 to length of the text and create a dynamic checkBox and show on your form checked/unchecked. Dim x as integer for i as integer= 1 to x.length 'do your codes here loop hope it can give you a way.

Member Avatar for Reverend Jim
0
150
Member Avatar for mbowenitj

NO need to wrrap datatimepicker value by `single quotation` mark. For string type variable you can use it. To use date you must use `#`. Use parameterised query to avoid this type of hazards. selectQuery = "SELECT * FROM EmployeeRegistration WHERE EmpJoinDate BETWEEN @fromDate And @toDate ORDER BY EmpJoinDate" cmd.Parameters.AddWithValue("@fromDate", …

Member Avatar for Reverend Jim
0
178
Member Avatar for Olanrewaju_1

Please post your codes which you did to sum the cells values. Go through a loop for columns to sum rowwise cell values. And go through a loop for rows to sum columnwise cell values

Member Avatar for Santanu.Das
0
354
Member Avatar for djrico8

There ia an extra space in your sql statement you made find from your uploaded picture. The sqlstatement should be "SELECT health,strength FROM playerstats WHERE playerid= " & playeridlbl.Text Before reading the reader, please check it produces any record or it is blank. A blank reader can produce an exception …

Member Avatar for djrico8
0
305
Member Avatar for Imam_3

Refreshing on every 5 seconds directly by using timer can make a problem on objects focus on user's screen and it is most disturbing probling at the time of dataentry. To avoide this type of problem you can use BackgroundWorker. Here is a fine [tutorial about BackgroundWorker](https://www.daniweb.com/software-development/vbnet/tutorials/477520/how-to-use-backgroundworker-to-create-threads) created by Rev. …

Member Avatar for Imam_3
0
1K
Member Avatar for ddanbe

Instead of line 48 to 54 in your codes you can use databinding to show your data. DataBinding is one of the beautiful part of WPF.

Member Avatar for ddanbe
1
552
Member Avatar for Imam_3

> newLabel.Text = newLabel.Name Inspite of this code at line no 9 to show data from table you can use this following codes newLabel.Text = ds.Tables("room").Rows(i)(ColumnIndex) or new Label.Text=ds.Tables("room").Rows(i)("Column Name") Hope it can help you

Member Avatar for Imam_3
0
1K
Member Avatar for satti

Your codes are quite right. A little bit change is needed. You can use 9600 as baudrate. And a little change is needed in the function SendSMS(). codes are following If SMSPort.IsOpen() Then SMSPort.Write("AT" & vbCrLf) SMSPort.Write("AT+CMGF=1" & vbCrLf) SMSPort.Write("AT+CMGS=" & Chr(34) & phoneNumBox.Text & Chr(34) & vbCrLf) SMSPort.Write(message & …

Member Avatar for Santanu.Das
0
310

The End.