Pgmer

[CODE] Dim fBrowse As New OpenFileDialog With fBrowse .Filter = "Excel files(*.xls)|*.xls|All files (*.*)|*.*" .FilterIndex = 1 .Title = "Import data from Excel file" End With If fBrowse.ShowDialog() = Windows.Forms.DialogResult.OK Then Dim fname As String fname = fBrowse.FileName '' Do what you want to here. End If [/CODE] I have …

your already placing the combo on grid and you want to know how to bind records to that combo?

[CODE] Try Dim fBrowse As New OpenFileDialog With fBrowse .Filter = "Excel files(*.xls)|*.xls|All files (*.*)|*.*" .FilterIndex = 1 .Title = "Import data from Excel file" End With If fBrowse.ShowDialog() = Windows.Forms.DialogResult.OK Then Dim fname As String fname = fBrowse.FileName Dim MyConnection As System.Data.OleDb.OleDbConnection Dim DtSet As System.Data.DataSet Dim MyCommand As …

Did your Childform set its parent form?

After inserting the records did you try running ur statement on database like Select * from tblClass?

[CODE] Try Dim cn As SqlConnection Dim strCnn As String = "Your data base connection string" cn = New SqlConnection(strCnn) cn.Open() Dim comm As New SqlCommand("SELECT ItEquipmentNo FROM tblITEquipmentName WHERE equipmentName LIKE '" & it & "%'", cn) '' If ur using Sp then Commandtype= CommandType.StoredProcedure if it is Text …

you need to give more details like are you maintaining the purchase details? If yes, is there any relationship between these two? or Once user clicks on purchase update ur stock table with Currentstock-Qtypurchased and get the new values fromm db and bind again.

you can use Case statement in comboboxselectedindexchanged event

you need to initialize the cmdOLEDB using new keyword like cmdOLEDB=new oledbcommand. And after performing action please dispose the objects like coonection object and coomand object.

Yes Left join will give the cartesian product. Try using inner join. it all depends on the table structure and their relationship defined as said by debasis.

[CODE] Private Function ExtractNumbers(ByVal expr As String) As String Return String.Join(Nothing, System.Text.RegularExpressions.Regex.Split(expr, "[^\d]")) End Function [/CODE] write this function in ur form and call this it will return only number in string.

Why cant you give button in form, let the user make selection and click button to show records on form 2. And use the view to filter the records. This is the second thread u opend for same issue. :) try different ways of doing things. If you keep doing …

filter at the backend server only?

At which line the error comes up ?

What you want to identify? Have you given name to each of pic? plz explain

What is the problem? What is the above code all about? can you explain?

In which line the error is?

In windows application we dont have any viewstate. Probably you could try save in app settings. or data is huge save it in DB

Instead you do one thing, First show up the login form and validate is user is already registered if not show the registration form.

[CODE] Dim arrImage() As Byte Dim openFile As New OpenFileDialog If openFile.ShowDialog() = Windows.Forms.DialogResult.OK Then arrImage = System.IO.File.ReadAllBytes(openFile.FileName) Else Exit Sub End If [/CODE]

If ComboBox1.SelectedItem = "Sound 1" Then you need to set Playsound="ur audio file name not Sound1"

What count you want to show? Where is the execute reader in your code here? This half code does not explain anything...

Hi mitja, I have a doubt here... if Questions are in more say 100+ then ?

you need to add one more column to table Print as boolean and When user selects or unselects the data from Gridview u need to update those columns in DB and Get the data where Print=1 in crystal report.

[CODE] Dim dt as new datatable ' Code to add columns to table dt.Columns.Add("A", Type.GetType("System.String")) dt.Columns.Add("B", Type.GetType("System.String")) dt.Columns.Add("C", Type.GetType("System.String")) 'Binding the rows to gridview DataGridView1.DataSource = dt ' Code to add new row Dim dr As DataRow dr = dt.NewRow dt.Rows.Add(dr) [/CODE]

In form load event ComboBox1.Text = "Select item"

Try calling datagrid.refersh method after loading.

[CODE] ' Declare at form level Dim objRandom As New System.Random( _ CType(System.DateTime.Now.Ticks Mod System.Int32.MaxValue, Integer)) Public Function GetRandomNumber( _ Optional ByVal Low As Integer = 1, _ Optional ByVal High As Integer = 100) As Integer ' Returns a random number, ' between the optional Low and High parameters …

[CODE] Dim myTabPage0 As New TabPage() myTabPage0.Text = "Event " & (TabControl1.TabPages.Count + 1) TabControl1.TabPages.Add(myTabPage0) Dim txt As New TextBox txt.Text = "Test" myTabPage0.Controls.Add(txt) [/CODE] Try if this helps u

Which index you want to find? Explain in detail.

[CODE] Try Dim fBrowse As New OpenFileDialog With fBrowse .Filter = "Excel files(*.xls)|*.xls|All files (*.*)|*.*" .FilterIndex = 1 .Title = "Import data from Excel file" End With If fBrowse.ShowDialog() = Windows.Forms.DialogResult.OK Then Dim fname As String fname = fBrowse.FileName Dim MyConnection As System.Data.OleDb.OleDbConnection Dim DtSet As System.Data.DataSet Dim MyCommand As …

without installing framework you want to run your application on client system?

Ur letting the user to enter the data in gridview cell?

get those values into integers and compare. [CODE] Dim param As Integer = 122 Dim compval As Integer = Label.Text If compval > param Then MsgBox("greater") Else MsgBox("Less") End If [/CODE] This is just sample.. you need to make changes in ur case

you need to show the 2nd form first before calling tabpage2.show. [CODE] dim objfrm as new form2 objfrm.show() TabPages2.show() [/CODE] im not sure abt TabPages2.show() u may need to do activate or someother things.. try out

Is it the code snippet? Then put it in Snippets using code tags..

At which line are u getting the error?

Are you using Database for ur application ? if yes which database are u using?

you want to concatinate multiple values from DB and add to combo?

Have you checked the database for record after insert?

Why cant you load the types into combobox? and when selected index changed and selected item is "Software" get the data for Software or u can use dataview for this and rebind the grid..

Ruchi224 please mark the thread as solved if its is solved. It helps the forum to maintain clean.. dont just escape after getting the soluution. Actulally i should post this.. but i saw two of ur post are solved but u forgot to mark as solved.

8 fixed lables? are you putting them in Panel or gropu box? And what are the names you have given them to identify the sequence?

use picturebox.load method and pass ur Apppath where u keeping the pic. [CODE] Dim picpath As String picpath = Application.StartupPath & "\img1.jpg" picturebox1.Load(picpath) [/CODE] make sure pic will be there in the apppath

you want to update the same file? first delete the content and using io.write u can write back and save...

you want to get the each item in richtextbox?

Go to the properties of lable.. under Image select the image u want to assign. Make the text emty. And set autosize=false and set the size you want.

At what line of code ur getting the error? [CODE] Imports System.Data Imports System.Data.OleDb Imports System.EventArgs Imports System.Data.OleDb.OleDbCommand Imports System.Data.OleDb.OleDbConnection Public Class ContactInfo_supp Inherits System.Windows.Forms.Form Dim Message As String Dim cn As OleDbConnection Dim cmd As OleDbCommand Private Sub button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles button3.Click Try …

What error ur getting?

Declare connection string in module level and consume in all the forms.If at all it changes u need to change only in the module not in all the forms.