GR M
Last Activity: Feb 10 '11, 10:30 AM
Joined: Dec 27 '10
Location: Bhubaneswar
-
Many a thanks David. Actually I have done it through SQL. But I wanted to show to my niece how the sql actually works through Vb.net codings. I have stuck at the for loop. I thought the condition checking is dynamic. But It was found to be static at the beginning of the loop. Thanks for the insight and also the suggestions. Also I've noticed , U have taken a great interest in my submissions. So nice of U David. Thanks Again. -
How to deal with index out of range exception?
Hi,
I was trying to add two quantities at different rows of same description i.e same product_name and same item_pack.1st I want to check the table if it contains the same description or not by comparing with the first record and so on. When found, I'll add up the quantities and then to delete that particular row (to avoid duplicate search). But when I delete the row the particular row, next time it throws an out of index exception.
... -
How to pass encrypted data to a database?
Hi All,
Do consider another thought. As we pass data to a database in a clear cut way, there may be situations, when we might fear data stealing. So can we simply encrypt data at the time of insertion, so that the data privacy will be maintained and the front end can only see the data. Any suggestion is appreciated.Tha nks in advance -
How to know if a form is already opened or not?
Hi,
How can we find if a form is already opened and is in active state programetically ? Any help is welcome. Thanks in advance. -
Make A database connection. Create a table to store/record the information according to the checkboxes checked. Retrieve them As you wishLeave a comment:
-
Problem in Visibility Of Some Controls In My Project
Hi everybody..
Just a Simple question. I'm having a form(Form1) with some controls(Button s,DatagridView, TextBoxes etc) added to it. At the form load event, I'v hide some of those(buttons, datagridview) Controls. Then from another Form(Form2) I'm calling the first form(Form1) by creating an object(My_Form) of it in form2
...Code:dim My_form As New Form1 My_form.mdi_parent=Form_parent my_form.datagridview.visible= true
-
Hello Prasd599, I'v finally made it. Actually the code was perfect. The problem was with the unregistered version of MS Access. I'v fixed it and all is well. Thanks a lot Showing interest in my problem. Tk Kr.Leave a comment:
-
How to write Connection String In App.Config File?
Hi..
I want to write the connection string of my application in app.config file. I dont know how to write it or how to dynamically change it from my application source code either. My App.config file shows like..
...Code:<?xml version="1.0" encoding="utf-8" ?> <configuration> <system.diagnostics> <sources> <!-- This section defines the -
No. I'm running on Win xp Sp3.Leave a comment:
-
How to dynamically change the connection string?
Hi..
Do consider my thought. I want to write my connection string in such away that it fits in the environment of database back up and restore. i.e. Most of time we do use hardcoded connection string. But if the user restores the backed up database to some other drive due to some reason or changes the restored database file name to his will, our whole program will crash. So, I invite some thoughts & lights on whether we could write the... -
Yes, I have tried those. The only soln I'v Got, that the code is almost perfect.The problem might be in the system. The Access That I'v used is of unregistered version. While openining, It always asks to register. This might be the cause of all problem. I'v modified the code to copy other files, such as .vb or .txt. It works fine. Thanks for your prompt reply MR. Prasad599. Plz reply me on these thoughts.Leave a comment:
-
system.io.file not found exception
Hi,
During file copy, I'm giving the absolute file name. But the compiler says file not found always. Is it a problem in my system or any error in my program.
...Code:Public Sub backupDB() Try Dim FileToCopy As String Dim NewCopy As String FileToCopy = "E:\Gyana_projects\Medicine_Stores_Management.accdb" NewCopy -
Dynamically creating Connection String
HI,
What my Idea is to develop a class which will create connection string depending upon the version of the database, i.e Office2007 or Office2010, we are using. Can We make such? If So, any idea is welcomed. Thanks in adv. -
Transaction Problem
I'm having problem With a Null reference exception Error message when running the later part of the code. i.e
FYI:Code:trans.Rollback()
...Code:Dim trans As OleDbTransaction Try trans = con.BeginTransaction If con.State = ConnectionState.Closed Then con.Open() End If Dim cmd_inward As OleDbCommand = New OleDbCommand("Insert -
adding items to a combo box depending upon the value given
I have a unbound datadridview named dgv_add, which contains columns of type datagridviewcol umn types and the another column of type datagridviewcom bobox type. I want to add specific items from a database depending upon the inputted text in the column of 1st type. I mean I want to retrieve specific column from a database and add the available items to the combobox after inputting text in the column of 1st type.
eg:
DGV_Add-> datagridview... -
I'v done it myself. Bt thanks a lot for your time and supportLeave a comment:
-
Thanks A lot sir.Leave a comment:
-
out of range erxception
I'm having out of range exception when executing the line
FYI giving the code below.Code:rdr_mfdby = rdr(" Mfd_company").ToString
...Code:Private Sub AllToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AllToolStripMenuItem.Click Dim todate = DateAndTime.Now.Date If con.State = ConnectionState.Closed Then -
data type mismatch between vb date datatype and ms access datetime data type
I'v designed a ms access database table with one field having Datetime datatype. I can Insert data into it from vb.net front end by using
.Code:trns_dt = DateTime.Now.Date
But when I fetch records from the tableand assign the dataset datasource as da, it shows datatype mismatch error.
...Code:da = New OleDbDataAdapter("Select * from Daily_Transaction where trans_date between '" & dtp_from_dt.value
No activity results to display
Leave a comment: