Search results for query: *

Dear All, I want to customize error msg of my own in place of the following. "Error when committing the row to the original data store" This error msg appears when we set DataColumn to AllowDbnull = False and try to update the DataTable with a null value. Any one has the solution to this...

...= New OleDbConnection(strConn) Dim techDataAdapter As OleDbDataAdapter Dim dtCustomerDetail As DataTable Try Dim strSQL As String = _ "SELECT * FROM Customers WHERE CustomerID = @CustomerID" Dim techCommand As New OleDbCommand(strSQL, techConnection)...

Dear All, I have datatable with a Column as "Sno". This DataTable is bound with DataGrid Now I want to generate Row Numbers for 'Sno' DataColumn through expression Public Function Tempinvoice(ByVal DataTableName As String) As DataTable dt = New DataTable(DataTableName) Dim dcsno As...

Dear all, I have a datagrid bound with tempDataTable. Dim TempInvoiceData As TechManagement.DBComponents.ProductDB = New TechManagement.DBComponents.ProductDB Dim DataTableName As String tblTempInvoice = TempInvoiceData.Tempinvoice(DataTableName) and DataTable Columns...

Dear All, When I run Application I Have following error An unhandled exception of type 'System.NullReferenceException' occurred in system.windows.forms.dll Additional information: Object reference not set to an instance of an object. Sample Application is attached here Can any one hep me...

Dear All, below mentioned code is working and fetches data exactly as I wanted with one exception. That's, the ProductID, I enter goes into next row. all other data(ProdDescription,Uprice) goes into right cells of currentrow. so what's wrong here? why ProdID goes into next row? can any one...

Dear all, Following code is not working with Enter Key What is wrong here? All other Chr 's working. For Example if I put : Following is the DG Tablestyles column dgtbc = dgInvoice.TableStyles(0).GridColumnStyles(1) ' If Not (dgtbc Is Nothing) Then dgtbc.Width = 110...

...(How can we attach a small button in this column) 3. When the user enters numbers into qty column and presses enterkey amount column should show the calculated value (that is qty*Uprice) I have done this last two in VB6 but I could not do all this in VB dot net2003. can any one help me please?

...KeyAscii = 0 DataGrid1.Refresh cons.Connect On Error Resume Next strsql = "Select * from ProductMaster where Prodcode='" & DataGrid1.Columns(0).Text & "'" Set rst = New ADODB.Recordset rst.Open strsql, Conn...

Dear all, The code as below after filtering, gives strange data in the listbox "System.Data.DataRowView" Here something Error I can' short out. filterview.RowFilter = "ProductID LIKE '%" & txtProductID.Text _ & "' OR ProductName LIKE '%" & txtProductID.Text & "%'" So any one can helpme...

Dear All, I'm getting error with the following code. can anyone shortout the problem please. Your help is highly appreciated. Public Function GetProductDetails(ByVal productID As Integer) As ProductsDetails ' Create Instance of Connection and Command Object Dim techConnection As...

Dear All, I have problem with following code : Private Sub frmProdDataEntry_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim Categories As TechManagement.DBComponents.ProductDB = New TechManagement.DBComponents.ProductDB cboCategory.DataSource =...

Dear All, Why Crystal Reports Sorts Automatically? I use following code to assign dataset to the report. When the report generated everytime it sorts automatically. How can I remove auto sort? Dim sql As String = "SELECT ProductID,ProductName,ProductImage FROM Products Where ProductID in ("...

Dear All, I want to save image from picture box into access database with size of 400x300, regardless of whatever the original size of picture in the picture box. 1). For example The Picture may be Desk or Chair. Chair size may be 50x75 varias Desk size might be 400x300. The rest area of...

Dear All, I'm creating a intractive CD with images(Catalogue) loaded in access db. I don't want every user to install the program into his pc. When he/she inserts cd it should play and display images by category wise (9 pictures at one time). is there vb code to acheive this in flash or any...

Dear vis781, I don't understand the following phrase. Can you give more explaination please.It will help us more. Increase your winforms load times. Open the windows forms generated bit and delete... Control.size = new ... Control.location = new point... Instead use ...

Hi All, I have added a box object into CR for page border and formatted with round corner. When i previev it, It does not shows round cuved corners. however when I exported into word doc format it displays round corner in word.but not exactly as I wanted, the round corner is fixed size only...

Dear All, I am new to dot not. I'm using vbdot net 2003 with crystal reports that bundled with vs2003 for creating catalogues for our company. In design time I have added picture field to the crystal reports and ticked the cangrow property so the picture can fit into its true aspect ratio. but...

Dear All, I have a Listbox lstProductID. I Want to print pictures of productid's from lstProductID list box only. how can we assign parameter from lsit box. can anyone help with sample code please? Thanks in advance

Dear All, I have a picturebox control on a form. But the Stretch property of the picturebox control doesn't strech very well - i.e. it distorts the Aspect Ratio to fit the control size. So some pictures look ugly on the form. Can you help with sample code please. Thanks in advance