467 Posted Topics
 | Your codes are quite right, but your conception is not clear how to maintain If ElseIf control flow. Your Logic is not clear in If score2 >= 90 Then letter = "A" ElseIf score2 >= 80 Then letter = "B" ElseIf score2 > 70 Then letter = "C" ElseIf score2 …  |
| | Haaaaaaaaaaaaa!, What a madly codes you have done. You tried to create a new user, but before creating it you went to check, is it has or not? Think deeply and widely what will you have to do? Time of codifications you can do any type of mistakes (this is … |
| | Please be descriptive abut your problem. Do not understand what is your problem. We are here to help you.  |
| | |
| | Pls. Post your codes what did you do and describe your problem. |
| | Submit your codes. We can help you to find the problem and also to resolve the problem. |
| | Use control flow to do your jobs. Like If (dp.DialogResult=Windows.Forms.DialogResult.OK) { '''''''''''''''' ''''Do Your Jobs'''''' '''''''''''''''' }  |
| | on my opinion check the **fileName** variable does contain "Full Path" of the file to open or not. |
 | You can do it by altering SelectionStart and SelectedText Property of the RTBox. private void buttonX1_Click(object sender, EventArgs e) { richTextBox1.SelectionAlignment = HorizontalAlignment.Center; richTextBox1.Text = "//enter texts"; richTextBox1.Text +=System.Environment.NewLine ; richTextBox1.SelectionStart = richTextBox1.Text.Length; richTextBox1.SelectionAlignment = HorizontalAlignment.Left; richTextBox1.SelectedText += "//enter text"; } |
| | What is your logic to remove an element from an Array? Here you construct your logic with three new Arrays, **NewArray, NewArray2 and NewArray3**, not with the Arrays where you already store the data. The removal activity of your process never reflects on the originals, because you tried to construct …  |
| | You can do it by using a recursive procedure with two for loops, first one will be in reverse order and concatinate the decremented/incremented value to a string variable.  |
 | Use of CDbl() is a cause to make an exception. You can use Val() in the place of CDbl() or both. num = Val(txtNumber.Text) or num = CDbl(Val(txtNumber.Text)) What is **Word(CInt(num))**? Is this a sub procedure to convert an integer to a string(spelling of the integer)? If it is, quite … |
| | There is another control flow needed before > If Not IsNumeric(input) Then Your codes are quite right and you need some modification. Like Do input = InputBox(msg1, msg2) 'Check is the variable stores any value or not If Not String.IsNullOrWhiteSpace(input) Then 'If it stores something do the calculations If Not … |
 | In your for loop there is no way to stop it before finishing. You can make a If ElseIf control flow. If it does not satisfy your condition exit from the loop.  |
| | |
| | Before updatation how could you clear the table name from the data source. Your problem is in line no 10. Don't clear tables name before updatation. If you clear before, how could data-adapter perform update? |
 | Most eye-catchy and most appriciatable work to every newbee. Attching progress percentage would be gave it an another dimention. |
 | |
| | Here two different mirror images have been opened in Database Explorer and Datasources windows. When first time they opened, the images were same. One user never see the data changes made by another. Like one user never see what is doing by another user, though they work in the same … |
 | Suppose, your problem is in ConnectionString. Your ConnectionString should be conn.ConnectionString = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\alm1.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1"; To know more, [go here](http://www.connectionstrings.com/excel/), if you like. |
 | What do you mean by this line > i want to do is encrypt the 3 column in the datagridview since it is a password.. Here is no way for which column you tried to encrypt or which is the password column you thought to encrypt. You can do it … |
| | Is the forms you showed are created dynamically? If so, create a controllflow by If Elseif to show the notification icon when the form shows at first time. |
| | Your codes are quite right for vb6, but not in vb.net. Some little modification is needed. The codes that should help you are Function CalculateDailyHours(InTime As String, OutTime As String) As String Dim StartTime As Date Dim EndTime As Date Dim Temp As TimeSpan ' ************************************** StartTime = CDate(InTime) EndTime … |
| | You do too many mistake. The index of subitem of a listviewitem never starts from 0, that you did it in the first line > If lvHistory.Items(i).SubItems(0).Text <> 0 Then . It starts always from 1. Like If lvHistory.Items(i).SubItems(1).Text <> 0 Then I do not understand, why are you declare … |
| | If you like to edit the field with same value of all 5000 records simply use $sql = "UPDATE tablename SET table_record = 'new_value'"; No need of for or do loop. Secondly, if you like to edit the feild with seperate value use a where clause in your SQL Statement … |
| | There is a convention in writing programming codification is Check the validation before assigning the values to the variables and force the user to input a value unless it is optional. But,here you do that from reverse. First you have assigned the values to the variables then checked the validation. … |
| | Do not understand. Pls. Elastrate the problem. > add icon on a textbox border |
| | Fine work, mainly the maintenance of picture quality. |
| | Do a Loop between LowerBound and UpperBound of the ArrayList. In loop Check the condition like ArrayList(i)=UserInput. If the condition satisfy Exit from Loop. |
| | Advance wishing your success. Do your exam without any tension. Cool Baby!! |
 | > How can I filter records from the clock set at right angles What do you mean by right angles? Did you mean DatagridView will load fresh data after every 15minutes or every single minute? Which one? I have done here some modification in your codes, which will load a … |
| | Re: Vb.net with SQL MySQL is a open source RDBMS. You would download it from MySQL.Com. The newly reales version is [MySQL 5.6.21](http://dev.mysql.com/downloads/mysql/?elq_mid=8488&sh=8261372613623268152424121&cmid=NAMK14057702MPP060C004&elq=1f5bf13bb3ff4d7fbf265d8e9466a70d&elqCampaignId=13325). The MS SQL Server also a freeware. You would download it from Microsoft Download Center. There are too many versions, MsSql server 2008, 2008R2, 2012 etc. SQL Statments are same for … |
| | A little modification is needed in your SQL statement. It should be the following. cmd.CommandText = "SELECT * FROM TblLogin where Username='"+ usr_lgn.Text +"' and Password ='" + pswr_lgn.Text + "' and STAFFSTATUS ='ACTIVE'"; |
| | List of textBoxes is a bad idea. But you can do it with Array or HashTable. Store the value of the TextBox in an Array and finally through a loop add them. |
 | This is a common threading problem in vb6. Here it is in the For Loop. Until completion of the loop it does not reales the thread. If your Loop runs in foreground, it will never permit you to do other works. You can do it by breaking the loop but … |
| | More easy process if yo use C# codifications without creating Function in SQL. Make a Do...Loop and do your job. It should be likely Do Until Date > ToDate '''open Connection '''SQL Statement with Where Clause Date beteen FromDate and ToDate '''Pick Your Data from Database '''Make calculation '''Close Connection … |
| | There are several process to transfer data from one form to other. Create a property for the form2 and assign the value to the property before showing Form2. |
 | Re: KeyLogger Error Problem is in Argument value passing. Nowhere I find the variable `gettheoath`. Declare the variable as per parameter type or check the variable type if you declare it as Global/Public variable in the main Module. |
| | Load the picture to the picturebox. Then add it as usual to the Binary field as you do with text fields. That will like it. RecordSet.AddNew Recordset.Fields("YourFieldName")=PicBox.Image Recordset.Update |
| | Transfer is possible through a For loop of the selected or checked items of the listview. you can get selected items from listview selecteditems collection. |
 | cgeier's is the right choice. You can use it. |
| | Is there any option to delete or cancel any post? If unwillingly I post any topics or any answer or post an identicle answare, what should I do? On my opinion, I should get a chance to delete or cancle mine (not others) if I do the same. |
| | |
 | @Begginnerdev, Your codes are quite right. But it can perform an exception due to Closed DataConnection. Nowhere you open the Connection Object. |
| | After saving file you must have close & dispose the Datable variable. And also close the opened file stream, inwhich you save the XmlFile. |
| | What do you mean by `displayindex`? DataSet would be typed or not. What is yours? If your DataSet is nontyped, Re-arrange the field names at SQL Statement as your desired serial. |
 | For simple movement of your picture you can do this. No need of MouseDown event or DefwndProc or any difficult calculation. Imports System Imports System.Drawing Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Panel1.AutoScroll = True PictureBox1.SizeMode = PictureBoxSizeMode.AutoSize End Sub Private Sub PictureBox1_MouseMove(sender As …  |
| | Most bad idea to use a single numerical one.  |
| | How for did you go? Show your efforts and tell about problems. |
 | NO, We are not ready to do your homework. How far have you gone? Post your codes and tell your problem. We are always with you to help. |
The End.