Visual Basic .NET Forum

How to connect locally on server machine?

I have the following code: Imports System.Data.SqlClient Public Class Main Protected WithEvents DataGridView1 As DataGridView Dim instForm2 As New Exceptions Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles startpayrollButton.Click Dim ssql As String = "select...

Someone gave me the following code to fix an issue but I'm not sure what some of it is used for. oCmd = cnn.CreateCommand oCmd.CommandText = "sp_allsum" adapter.SelectCommand = oCmd adapter.Fill(ds) What is the cnn. used for in this case? Intellisense is asking me to declare values for it.

Hi I have a class structor for example like this: Person.name.firstname() Person.name.Lastname() Person.Father.firstname() Person.Father.Lastname() Now I want to write a method for my class to return the firstnames like this: Public function ReturnFirstname(methodname as string)

I have an button(add) which adds data to a datatable and binds it to a grid. I want to save the data into a array accross multiple postback without using session,viewstate etc... selectQuery = "SELECT Proposal_Form_No as from Policy_Entry where svmslogin.Policy_Entry.Status='LoginReqd' and (Policy_Entry.Proposal_Form_No = '" +...

hi i have qusetion how to remove ongy blank items from listbox? I mean I wanna make button that only remove blank items from listbox

I have a form that requires me to execute several stored procedures one after the other. I'm wondering how to do that in vb.net. I realize that I could just have one stored procedure with all of my queries in it, but for clarities sake, I want to keep them seperate. Thank you Doug

I have the following code: Public Class Payrollfinal Private Sub Payrollfinal_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load exportfileButton.Enabled = False Dim oCmd As System.Data.SqlClient.SqlCommand Dim oDr As System.Data.SqlClient.SqlDataReader oCmd = New...

I want to edit the existing word processing ML doc. But I dont know how they have created that doc. Please see the attachment for reference. How to ctreate it from scratch?

i need to upgrade system from vb6 to vb.net but there was a condition for the database that i cant convert it to vb.net. Set Data2.Recordset = Db_Profile.OpenRecordset("Select * from BatchTable where datecreate = datevalue('" & Data1.Recordset.Fields("DocDate") & "') and RecCueNo = '" & Data1.Recordset.Fields("RecCueNo") & "'") ...

Hi The method below fails on the line marked in bold and I receive an object reference error. I know that this is a common error but, I've tried changing several assignments to ensure they match up with the required types and it the method still fails. I also tried: agentResponse(0).InputData = testMetaDataArray without the () after...

I am able to query/read the "Application" event log using System.Management classes in VB.net 2005 (win xp) But I have problem reading the "Message" / "description" of my custom event log. I am getting a System.NullReferenceException{"Object reference not set to an instance of an object."} while reading the "Message" / "Description of the...

Something is going wrong, I have no idea what it is. I just simply want to draw over pacman so he can open and close his mouth, so there would be 5 pacman's, with different mouth positions. (Note: The change of color was just to make sure I was seeing the results.) Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As...

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.Thanks in advance

I have a form that shows users data from a sql query. What I want to be able to do is when users make a change, they press a save button, the edited/changed data is saved to a new table and then the window is closed. I've looked for several tutorials for this. Can anyone give me an example of a good tutorial or a code example? My database that...

hi every one how can I send email to multi recipients at once? I tried but I couldnot sent more than one recipient each time

Hi, How can we find if a form is already opened and is in active state programetically? Any help is welcome. Thanks in advance.

I have one textbox and search button... when i entered file name suppose abc... i want to search all file which start from abc..

Hi, I want to record for future reference wich addins are active at the time a spreadsheet was last updated. We use addins with incremental revision number as they get updated. However, if the file is opened 2 years from now, I will want to be able to reproduce the original computation by selecting the addin which was active the last...

how can I add checkeditems or one by one items on click from CheckedListBox to TextBox one by one with( ;) between them such as emails in field of mailto ?

Hullo Good Friends, I am using VBNET2008. As requested by Senior Developer to retrieve all file names with extension .DOC set in the FolderBrowserDialog. Then place the File name in the DataGridView. Was told to use System.IO. I have not done it before and just don't know how to start it as well. My office mate, Jane Durban is having the...

Hi everybody.. Just a Simple question. I'm having a form(Form1) with some controls(Buttons,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 dim My_form As New...

I have the following form: Imports System.Data.SqlClient Public Class Main Protected WithEvents DataGridView1 As DataGridView Dim instForm2 As New Exceptions Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles startpayrollButton.Click Dim ssql As String = "select...

Hello, I'm trying to send a Null value in a DateTime field while calling my stored procedure. If I use this first method (short with one line), i got the following error message: cmd.Parameters.Value = (this.OrderDate == DateTime.MaxValue) ? DBNull.Value : this.OrderDate;

I have the following form: Imports System.Data.SqlClient Public Class Main Protected WithEvents DataGridView1 As DataGridView Dim instForm2 As New Exceptions Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles startpayrollButton.Click Dim ssql As String = "select...