467 Posted Topics
Re: 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) | |
Re: 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)"` | |
Re: your query should be "insert into SK_Silk (JID,silk_own) Values (("Select JID From TB_User where StrUSerID='" & TextBox1.Text & "'") ," & Val(TextBox2.Text)) | |
Re: 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() | |
Re: 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 … | |
Re: Or you can do it with ComboBox1's LostFocus Event | |
Re: 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). | |
Re: Do not understand. Please explain questions correctly, | |
Re: 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. … | |
Re: 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. | |
Re: 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 … | |
Re: 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. | |
Re: You can use BatchUpdate method. | |
Re: 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. | |
Re: Please create a new thread. | |
Re: 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 … | |
Re: 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. | |
Re: 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. | |
Re: "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 … | |
Re: 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. | |
Re: 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 … | |
Re: 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 … | |
Re: 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 … | |
Re: 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 … | |
Re: From my opinion you do not write the connection string properly. Please follow this [site](http://www.connectionstrings.com/sql-server/). | |
Re: Please post the codes for configuration method. From my opinion you must have to check that config method thoroghly. | |
Re: 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. | |
Re: 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 … | |
Re: 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 … | |
Re: 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 … | |
Re: 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. | |
Re: 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) | |
Re: 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. | |
Re: Agreed with @JamesCherrill. Using a class object you can do it easily. | |
Re: Please try it Dim sql As String = "Select SUM(orders_amount) As Amount FROM orders WHERE inquiries_ref ='" & TBOrdersCustomer.Text & "'" | |
Re: 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 … | |
Re: Please, show your efforts to do your job first, then forum could give you a suggestion to solve. | |
Re: 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. | |
Re: 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 … | |
Re: 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. | |
Re: 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", … | |
Re: 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 | |
![]() | Re: 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 … ![]() |
Re: 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. … | |
Re: 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. | |
Re: > 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 | |
Re: 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 & … |
The End.