- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 12
- Posts with Upvotes
- 10
- Upvoting Members
- 7
- Downvotes Received
- 12
- Posts with Downvotes
- 7
- Downvoting Members
- 9
- Interests
- Visual Studio, msSQl, MySQl
54 Posted Topics
 | Re: Project form 4 You didn't post your codes, so do not understand how far you wrote and the exception you got. Reading your post I create a new like this  I suppose it would be solved your requirments Codes are below. Public Class Form1 Sub initObjects() DataGridView1.AllowUserToAddRows = False DataGridView1.AllowUserToResizeRows = …  |
 | To short numbers in descending order, you can use the following codes, if you like. Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click Dim x(9) As Integer For i As Integer = 0 To x.GetUpperBound(0) x(i) = i + 1 Next Dim y As Integer = 0 For … |
| | Re: error Ther is no way to emagine a cause for an exception, if you do not state,how far you went about that matter and how you tried to remove the exception. Post your snippet, we can try to help you to solve your problems. To convert a string to double you … |
| | Connection string alaways delimits with a ";". You did not put ";" after **";Password=" + TextBox4.Text + "(put here a ';')"**. It could be solve your problem.  |
 | |
| | Do not understand why did you call a MessageBox in every function and also about the declaration type as Decimal of the variables. Function is for the use of some value to return. Calling of Message in a function makes an obstraction to do its actual work. Call MessageBox in … |
| | You didn't supply your code. We do not understand where from you get a problem. Distinct your problem in your codification.  |
 | Re: scope of VB.Net You can learn Visual C#, Visual C++, Visual Basic in .NET platform, what you want. There are many versions like Visual Studio 2008, Visual Studio 2010, Visual Studio 2012. Choice and dicision is your own. As SQLServer you can use MsSQL Server, MySQL, Oracle and many others. MySQL is most … |
 | |
| | 0.00 is the right answer for you because too many wrong codes you write. 1) In btnCalculate.Click event you already passed the argument values in several functions. But in the code area of every functions you tried to initialize the parameters. And you did it wrongly though this is a … |
| | Re: Sums of Number Do not understand, what do you want? At the calling of `MessageBox.Show`, you have interchanged the `Prompt` and `Title` argument values. But in case of addition, I do not understand, what did you try to show in messagebox. If you try to show the inputted value, why do you want … |
| | You make an information of your Database with two Tables named 'Employee Info' and 'Earnings'. But you didn't say about the structure of the tables. From your posting assumming that the 'Employee Info' Table has fields like Emp_Code, Emp_Name, Emp_Desig etc. It is normal. But you didn't define the structure … |
 | This is not a good job to create a table for every status. Add a field of the status, which describe the seat is for Regular, disabled or VIP's. and check the condition. Here I make a modification in the table 'Reservation' with field name SeatStatus, FieldType Text (10). Where … |
| | Agreed with deceptikon. I also prefering own XML file with Serialization more than a database. I never try to use App.config file. I always try to keep it in safe position. I like to leave it for VS. Use of Serialization in XML file to store configarations is more convenient … |
| | Simply apply `MessageBox`. I am posting here the new one for your `ENTER` Button Click Event. Private Sub ENTER_Click(sender As System.Object, e As System.EventArgs) Handles ENTER.Click Dim btnNm As String = "" con = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\laptop\Documents\Trial\Sample.accdb") con.Open() Dim Buttons As New List(Of Button) From {A1, A2, A3, A4, A5} … |
| | These are not appropriate examples. They are for exporting Report Data to Exel file Format. He/She wants the oposite ones. |
| | You did not post your codes, what far you have done. We can help you but not for to do your jobs. |
| | Re: How to do this Some days ago I do the same as you want. Private Sub ToolStripLabel4_Click(sender As System.Object, e As System.EventArgs) Handles ToolStripLabel4.Click If (ValidateUser() = False) Then Return Dim UserCommand As New System.Data.SqlClient.SqlCommand If distributionDB.State = ConnectionState.Closed Then distributionDB.Open() End If UserCommand.CommandText = "Select Count(UserID) From DistUser Where UserID=@UsID" UserCommand.Parameters.Add("@UsID", SqlDbType.VarChar, 50).Value … |
| | You choose the correct event. I am trying to modify it. It could help you Public Class Form1 Dim btnPress As Boolean = False Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click, Button2.Click, Button3.Click, Button4.Click, Button5.Click If btnPress Then MsgBox("You can only select one seat for every Process") … |
| | BY a simple TextChange event you could do it Private Sub TextBox_TextChanged(sender As System.Object, e As System.EventArgs) Handles TextBox1.TextChanged, TextBox2.TextChanged Dim x As Double = 0 For Each actTxtBox As TextBox In Me.Controls If (actTxtBox.Name = "TextBox1") Or (actTxtBox.Name = "TextBox2") Then x += Val(actTxtBox.Text) End If Next IIf(x > … |
| | From two to three days MySQL56 does not strat when window starts. It still remain in stop position. I try to start it mannualy from its shortcut menu on its red coloured Icon at TaskBar. But it still remain in stop position. Through Control Panel I went to the Servises …  |
| | When I want to create a database by through MySQL Workbench 6.1 CE the database always creates at "C:\ProgramData\MySQL\MySQL Server 5.6\data\". But I want to save it in my desired folder. How do I do that? |
| | I use SQL Server2008 R2. From yesterday, I get a problem to open it. When I try to open it by Microsoft SQL Server Management Studio an error is occurring. And I also get the same error when I call it from vb.Net2010. I am attaching here the error picture. … |
| | Re: Load Image If you already attached your pictures to the resorce in your application you can use `image1.image = my.resources.yourImageName`. if not, in `Load` method define the file name with proper file location path. |
 | Please, distinctly write your problem. |
| | In DeleteData() procedure, you mention the commandText Property two times, One in Line 71. `cmd = New SqlCommand(query, con)` Second one is at Line 73. `cmd.CommandText = query` . Remove the second One. But I do not find your Update query and also dataGridView Control. Iam trying to modify Your … |
| | Add parameters after assigning the `CommendText` Property (Line No 45). |
 | Re: Please Help... No one have sufficient time to teach a new one. Read books, journals or from MSDN and also learn form teaching concerns and socities. Forum members can help you to correct your learnings and ways by making some fruitful tips. Achievement is your concern. Now I am describing here how … |
 | After insertion of new value, close and then create new instance of query. |
| | Check your database, reading your codification, I understand that Field `emp_id` in your Data Table is the `Prymary key`, but you declre its Data Type is `Double`(God knows why?). This is not a good job. Take it as `Varchar` type and make the SQL commands on its base and modify … |
| | I fall on same problem about Crystal Report, But in vb.Net 2010 and msSQL Server 2008R2. SAP Crystal Report does not working as I desired. |
| | To create a report using `PrintDocument` I have some opinion, you can use it if you like. 1) Set `PrinDocument.DefaultPageSettings`at PrintDocument's `BeginPrint` event. 2) At the position of `With PrintDocument.DefaultPageSettings` use `With e.PageSettings` 3)At line 17 use`e.PageSettings.Landscape` in lieu of `PrintDocument.DefaultPageSettings.Landscape`. Finally, after completion of reporting in my knoledge, you … |
| | Right Click on Project Name, then go to `Add` and Click `New Folder`. It can attach a New Folder In your Solution Explorer. Rename it. Then Right Click On it and Open it with `Windows Explorer` and Copy and Pest Your Pictures In it. |
| | I am try to posting here, though I do not work with Asp.Net. I am working on vb.Net. Where you are making a condition like `if (dr.Read())`, in vb we are first checking that the DataReader has any rows. If dr.HasRows then dr.Read() 'Statements EndIf Hope you should get a … |
| | In `Application.StartupPath()` the exe file of the applicaion, which now you are tried to write, resides. Simply the path of the folder where the application exe file exists. You can change the application startupPath. Put your database file into the folder where the exe file exists. You can use following … |
| | There are several ways to make a report. You can do this by creating .rdlc file/Crystal Report (.rpt). To show .rdlc file you have to use Microsoft ReportViewer object and for Crystal Report use CrystalReportViewer. For Typed DataSet you can use Microsoft ReportViewer. You can also use `PrintDocument` Object to … |
| | A seller sale a thing by 10% loss on his selling price, how % loss on his purchase price? |
 | The following codes prevent the keys other than Digits and '-'. And you can press the deletion and nevigation keys. Public Class Form1 Private Sub Form1_KeyDown(sender As Object, e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown If TypeOf Me.ActiveControl Is TextBox Then If Not ((e.KeyCode = Keys.D0) Or (e.KeyCode = Keys.D1) Or (e.KeyCode … |
| | I am now in a problem to prompt user at the first run of my program. The Server is msSql Server 2008 R2 and Plaform vb.Net 2010. At the time of starting, the program starts to search the file, where the ConnectionString is saved. If it get then well else … |
| | |
| | The most easiest way is `Update` your table programmatically at `DatagridView1.CellEndEdit` event. This event will raise when you try to leave the Cell. Another Process: Add a `DataGridViewCheckBoxColumn`, it will be checked or unchecked when you try to edit the Cell. This will be checked/unchecked at DatagridView1.CellBeginEdit event. Now at … |
| | Reading you post I can understand your problem. Your problem is you have a datagridview of two columns. First is the name and second one is price. You want to pick up the price from datagridview and try to multiple with qty. and get the tot price. May I right? … |
| | To store the every words you can use this. Dim StrArray() as string StrArray=Split(Trim(Label1.Text),Space(1)) The following code can check the words. Private Sub TextBox1_KeyDown(sender As Object, e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown If e.KeyCode = Keys.Return Then If FindWords(Trim(TextBox1.Text)) Then MsgBox("Found") Else MsgBox("Not Found") End If End If End Sub Private … |
| | Two to three years ago I wrote a small codification to search strings in an array for a part of string (where may be it reside). First I loaded an `Array` by some values running a `Loop`. You can load your data from `database` into the `Array`. Write the `part … |
| | I hope the following codes help you. Private Sub ButtondeleteListItem_Click(sender As System.Object, e As System.EventArgs) Handles ButtondeleteListItem.Click ''' First remove the selected items For Each litem As ListViewItem In ListView1.SelectedItems ListView1.Items.Remove(litem) Next ''' Check the items count is not zero If Not ListView1.Items.Count = 0 Then ''' modify the text …  |
| | Simply create a table to store the user supplied `@datePerformedFrom` and `@datePerformedTo`. Create a view joining with the table `shipment`. Now you can attach this view with `ReportViewer` object by creating a `DataSet`. |
| | |
| | You can Try this Me.Text = String.Format("{0}.{1}.{2}.{3}.{4}", My.Application.Info.Version.Major, My.Application.Info.Version.MajorRevision, My.Application.Info.Version.Minor, My.Application.Info.Version.MinorRevision, My.Application.Info.Version.Revision)  |
| | The following codes will prevent the keys other than the alphabates. But you can allow the deletion and nevigation keys. Public Class Form1 Private Sub Form1_KeyDown(sender As Object, e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown If TypeOf Me.ActiveControl Is TextBox Then If Not ((e.KeyCode = Keys.A) Or (e.KeyCode = Keys.B) Or (e.KeyCode … |
| | My client wants to send a SMS to his customers from his computerised billing system. But, I do not know anythig about this subject, How it can do. I want to know, how can I do that? And Which services I have to need. How do I correspond with these … |
The End.