How to create a scroll banner which displays two messages scroling in opposite direction across the applet’s Window. Can anyone help me? With Regards, Suman

Check box column getting unchecked when I am sorting column in datagridview. Can any one help me? Regds. Suman Imports System Imports System.Data.SqlClient Public Class Form1 Dim str As String Dim con As SqlConnection Dim da As SqlDataAdapter Dim ds As New DataSet Dim dt As DataTable Dim dv As DataView Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "Integrated Security=SSPI; User Id=sa;Initial Catalog=MAS08; Data Source = suman" con = New SqlConnection(str) con.Open() str = "select * from unitmaster" da = New SqlDataAdapter(str, con) da.Fill(ds, "unitmaster") dt = ds.Tables(0) dv = New DataView(dt) Dim colCheckbox As New DataGridViewCheckBoxColumn() ' Size the column width so it is wide enough to display the header colCheckbox.AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader colCheckbox.ThreeState = False colCheckbox.TrueValue = 1 colCheckbox.FalseValue = 0 colCheckbox.IndeterminateValue = System.DBNull.Value colCheckbox.DataPropertyName = "Checkbox" colCheckbox.HeaderText = "Checkbox" colCheckbox.Name = "Checkbox" 'colCheckbox.ReadOnly = True dgv.Columns.Add(colCheckbox) dgv.DataSource = dv End Sub End Class

Imports System Imports System.Data.SqlClient Public Class Form1 Dim str As String Dim con As SqlConnection Dim da As SqlDataAdapter Dim ds As New DataSet Dim dt As DataTable Dim dv As DataView Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "Integrated Security=SSPI; User Id=sa;Initial Catalog=MAS08; Data Source = suman" con = New SqlConnection(str) con.Open() str = "select * from unitmaster" da = New SqlDataAdapter(str, con) da.Fill(ds, "unitmaster") dt = ds.Tables(0) dv = New DataView(dt) Dim colCheckbox As New DataGridViewCheckBoxColumn() ' Size the column width so it is wide enough to display the header colCheckbox.AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader colCheckbox.ThreeState = False colCheckbox.TrueValue = 1 colCheckbox.FalseValue = 0 colCheckbox.IndeterminateValue = System.DBNull.Value colCheckbox.DataPropertyName = "Checkbox" colCheckbox.HeaderText = "Checkbox" colCheckbox.Name = "Checkbox" 'colCheckbox.ReadOnly = True dgv.Columns.Add(colCheckbox) dgv.DataSource = dv End Sub End Class

Check box column getting unchecked when I am sorting column in datagridview. Can any one can help me? Regds. Suman

Rupesh, Sorry, couldn't solve the problem Suman

sorry, didn't solve the problem.

When I am generating report using following code from reportviewer my reportviewer showing the following message. 'A data instance has not been supplied for the data source 'Dataset1_customers'. Can any one solve the problem? Regards. suman Imports System Imports System.Data.SqlClient Public Class Form1 Dim con As New SqlConnection Dim str As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim da As SqlDataAdapter Dim ds As New DataSet str = "Integrated Security=SSPI; User Id=sa;Initial Catalog=Northwind; Data Source = suman" con.ConnectionString = str con.Open() str = "select * from customers" da = New SqlDataAdapter(str, con) da.Fill(ds, "customers") ds.DataSetName = "customers" RV.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local RV.LocalReport.ReportPath = "C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\WindowsApplication4\WindowsApplication4\Report1.rdlc" RV.LocalReport.DataSources.Clear() RV.LocalReport.DataSources.Add(New Microsoft.Reporting.WinForms.ReportDataSource("customers", ds.Tables(0))) RV.DocumentMapCollapsed = True Me.RV.RefreshReport() End Sub End Class

Sorry, it is not working. Should I change any properties to show data? Suman

I am unable to show data on datagridview using the following code. Can anybody help me please. Nothing showing in datagridview but no error message displayed. Suman Dim str As String Dim mycon As New OleDb.OleDbConnection Dim da As OleDbDataAdapter Dim ds As New DataSet Dim dt As New DataTable Dim dv As New DataView str = "Provider=Microsoft.jet.oledb.provider.4.0; Data Source=Nwind.mdb;" mycon.ConnectionString = str mycon.Open() str = "select * from customers" da = New OleDbDataAdapter(str, mycon) da.Fill(ds) DGV.DataSource = ds.DefaultViewManager

I have created a report on D: Drive and Database(MS-Access) is also in D: Drive.But When I have copied the programme in E: Drive, it is not working. I think I need to make the connection through coding. Regards, Suman

I want to create crystal report dynamically i.e from connection to data field every thing I want to do through programming. if it is Possible, please help me. Reards, Suman

While sending mail using the following code getting the error message 'could not access 'CDO.Message' object' Can anybody help me. Regards Suman Imports System.Web.Mail Public Class Form1 Inherits System.Windows.Forms.Form Dim mymsg As New MailMessage Dim myserver As SmtpMail Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click mymsg.From = "mahesh@yahoo.com " mymsg.To = "suman100@yahoo.com" mymsg.Subject = "SubjectOfTheMailString" mymsg.Body = "BodyOfTheMailString" myserver.SmtpServer = "mail.yahoo.com" Try myserver.Send(mymsg) Catch ex As Exception MsgBox(ex.Message) End Try End Sub End Class

How can I import data from a Foxpro database to an access databse using VB.Net Code

Can I make a Crystal Report using dataview? Suman

How do I automatically resize the Form when the screen resolution changes between design-time and runtime Regards Suman

I am developing my application using 1024x768 pixel setting. Using VB.Net code can I resize the application form automatically in a different pixel setting (e.g 800x600). Can anybody help me? Regards Suman

Thnak you Mr. Nathan,It is working. With Regards Suman

I have down loaded the following code form Microsoft site and it is working. But I am unable to understand how I will trap it in my keyup or keypress event or any other way. Can any body help me please. With regards Suman How to trap keystrokes in .NET controls by using Visual Basic .NET or Visual Basic 2005 View products that this article applies to. On This Page SUMMARY Set Up the Key Trap Implement the Overridden Method Build an Example SUMMARY This step-by-step article demonstrates how to trap keystrokes in Windows Forms controls. By using the sample code in this article, you can intercept almost any individual keystroke. You also can intercept key combinations, including CTRL and ALT. The Print Screen key is not affected by this technique. Additionally, some keystrokes from keyboards with additional keys, such as keys that control a Web browser or a CD-ROM player, might not be captured. For most purposes, the standard KeyUp, KeyDown, and KeyPress events are enough to capture and handle keystrokes. However, not all controls raise these events for all keystrokes under all conditions. For example, consider the DataGrid control: If no data has been assigned to the grid, the arrow keys (LEFT ARROW, RIGHT ARROW, UP ARROW, and DOWN ARROW) raise only the KeyUp event. Other keys, such as A or 4, raise all three events. If the DataGrid is currently displaying data, none of the standard keyboard events are raised for the navigation keys. Keystrokes such as A or 4 raise no events, raise only KeyUp, or raise all three events, depending on what is currently selected in the control. In these situations, you can follow the steps in this article to capture keystrokes, regardless of the state of the control. The code samples in this article are written to work with the DataGrid, because this is the control for which this feature is most frequently requested. You can use this same approach with other .NET controls. Set Up the Key Trap To trap keystrokes in a Windows Forms control, you derive a new class that is based on the class of the control that you want. You override the ProcessCmdKey method. In this overridden method, you will place the code to process the keystrokes that you want to trap. The following sample code is an example of the basic structure for such a class: Class MyDataGrid Inherits DataGrid Protected Overrides Function ProcessCmdKey( ByRef msg As Message, ByVal keyData As Keys ) As Boolean End Function End Class Implement the Overridden Method T

Can anybody help me.

How can I capture Keyup event in a datagrid using datagridtextboxcolumn.