224 Posted Topics

Member Avatar for axes2t2

when u try to get the Cust_id and there are no record in database then value of your last will be null.. so check like this: [CODE] if IsDBNull(last) then last =0 end if [/CODE] u cant set last here to watever your starting cust_id is rather than 0.

Member Avatar for axes2t2
0
2K
Member Avatar for NitendraTRIC
Member Avatar for Leodumbi

use something like this [CODE] Dim ds As New DataSet() Dim dt As New DataTable Dim dgvrow As System.Windows.Forms.DataGridViewRow Dim dgvcol As System.Windows.Forms.DataGridViewColumn For Each dgvcol In Me.DataGridView1.Columns dt.Columns.Add(dgvcol.Name) Next For Each dgvrow In Me.DataGridView1.Rows dt.Rows.Add(dgvrow) Next Dim i As Integer = 0 Dim j As Integer = 0 For …

Member Avatar for Leodumbi
0
741
Member Avatar for tendaimare

[CODE] sfdSaveMe.Filter = "Word File | *.doc" [/CODE] add the above code before the sfdSaveMe.ShowDialog()

Member Avatar for tendaimare
0
143
Member Avatar for bhagawatshinde

hi.. following code works for me.. see if u can use it: [CODE] Me.RichTextBox1.Height = TextRenderer.MeasureText(" ", Me.RichTextBox1.Font).Height * Me.RichTextBox1.Lines.Length [/CODE]

Member Avatar for bhagawatshinde
0
400
Member Avatar for Polongo

try this at form's load event [CODE] Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.Width = Screen.PrimaryScreen.Bounds.Width Me.Height = Screen.PrimaryScreen.Bounds.Height End Sub[/CODE]

Member Avatar for Luc001
0
181
Member Avatar for xanawa

hummm.. 1. A simple POS (Point of Sale System) 2. A Simple CRM System 3. Music Player 4. Library Management System 5. Fee Management System 5. Human Resource Management System 6. School Management System 7. Personal Diary 8. Personal Journal etc..

Member Avatar for xanawa
-2
237
Member Avatar for Baby G
Member Avatar for Baby G
-3
264
Member Avatar for jlivvers

hi... suppose your dataset is DS check this kind of condition.. [CODE] if DS.Tables(0).Rows.Count >0 then "load your report" else MessageBox.Show("Nothing to Print") End IF[/CODE]

Member Avatar for sandeepparekh9
0
230
Member Avatar for markdean.expres

Hi.. Do somthing like this [CODE] Dim filter() As String filter = Me.TextBox1.Text.Split(" ") BindingSource.Filter = "surname like '" & filter(0) & "' or surname like '" & filter(1) & "'" [/CODE]

Member Avatar for sandeepparekh9
0
76
Member Avatar for ninjaimp

can u post the column structure of your two tables.. i mean wat columns your two tables contain..

Member Avatar for sandeepparekh9
0
86
Member Avatar for lielee

hi... Add Functions Like: Users (like admin, guest, etc) User Restrications Reports (Daily, Monthly, Yearly etc)

Member Avatar for lielee
0
165
Member Avatar for markdean.expres

do something like this: [CODE] Dim content() As String Dim s As String = "IT111,IT112,IT113" content = s.Split(",") [/CODE] here u can make a loop in which ur PREREQ field is stored in s (string) and then u can split and check each content like :- content(0), content(1) ,...etc after …

Member Avatar for markdean.expres
0
102
Member Avatar for paulablanca

just check the :- COUNT(your column name of table).. // in sql for datagridview check DataGridView.Rows.Count if count is > 10 then dont let user enter any data

Member Avatar for paulablanca
0
173
Member Avatar for noel9

use : DateTimePicker1_ValueChanged event A little demonstration [CODE] Private Sub DateTimePicker1_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DateTimePicker1.ValueChanged Dim strmonth As String = String.Empty If Me.DateTimePicker1.Value.Month = 1 Then strmonth = "Jan" End If If Me.DateTimePicker1.Value.Month = 2 Then strmonth = "Feb" End If If Me.DateTimePicker1.Value.Month = 3 …

Member Avatar for noel9
-1
144
Member Avatar for dejanc

just use the datediff with your sql query.. and all the rows will have the days in place of the whole date

Member Avatar for dejanc
0
246
Member Avatar for CrankyMero

use something like this: [CODE] Private Sub ACEPTAR_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ACEPTAR.Click TEST1.Text = "Aceptada" Dim imp As Integer imp = CANT.Text * PRECIO.Text Ventas.Rows.Add(My.Settings.folio + 1, fecha.Text, Ventas.Rows(c).Cells(2).Value = "V", ComboBox1.Text, ComboBox2.Text, CANT.Text, PRECIO.Text, PRECIO.Text, imp, ComboBox3.Text) End Sub [/CODE] wat i am saying …

Member Avatar for CrankyMero
0
286
Member Avatar for kruxena

do something like this: VB.NET Syntax (Toggle Plain Text) 1. Dim content() As String 2. Dim s As String = "IT111,IT112,IT113" 3. 4. content = s.Split(",") Dim content() As String Dim s As String = "IT111,IT112,IT113" content = s.Split(",") here u can make a loop in which ur PREREQ field …

Member Avatar for kruxena
0
134
Member Avatar for akritiu

here is sample image: do it this in sql server when u make a table: [URL="http://lh4.ggpht.com/_blnOia1d0Pw/TTO8GvMmclI/AAAAAAAACdU/clRIl9x08tQ/s512/Untitled.jpg"]sample image[/URL]

Member Avatar for sandeepparekh9
-1
107
Member Avatar for sandeepparekh9

hi i am developing an application of which i want to create a DEMO version for 7 days.. i tried to make the demo stop in vb.net by checking for the current date and if its past 7 days then the app. wont start. but the problem is is the …

Member Avatar for sandeepparekh9
0
119
Member Avatar for Angrybirds

hey.. try this.. [URL="http://www.codeproject.com/KB/miscctrl/FingerPrintIdentifcation.aspx"]http://www.codeproject.com/KB/miscctrl/FingerPrintIdentifcation.aspx[/URL]

Member Avatar for sandeepparekh9
0
115
Member Avatar for x2fair

here.. let me show you you have to use Autocompletestringcollection i made a little app. for you .. see this link: [URL="http://lh3.ggpht.com/_blnOia1d0Pw/TQxyMJTiRqI/AAAAAAAACc4/s8m4GWX5YkA/autocomplete.jpg"]http://lh3.ggpht.com/_blnOia1d0Pw/TQxyMJTiRqI/AAAAAAAACc4/s8m4GWX5YkA/autocomplete.jpg[/URL] Write the following code for the button 1 [CODE] Dim books As New AutoCompleteStringCollection Dim conn As New SqlConnection("Data Source=NITIN\SQLEXPRESS;Initial Catalog=library;Integrated Security=True") Dim cmd As New SqlCommand("select btitle …

Member Avatar for x2fair
0
103
Member Avatar for iWarrior
Member Avatar for x2fair

hi ... you can use open source barcod making software.. if you like u can change the source code.. here is link to one of those : [URL="http://www.zint.org.uk/zintSite/"]http://www.zint.org.uk/zintSite/[/URL] direct download : [URL="http://www.mediafire.com/download.php?3bwol5zgg7wz8x6"]http://www.mediafire.com/download.php?3bwol5zgg7wz8x6[/URL]

Member Avatar for x2fair
0
109

The End.