Search results for query: *

  1. F

    Question ConnectionString for a Remote Sql Server

    :tennis: Thanks to all for the Help. The issue has been resolved. Ill post the solution for others.
  2. F

    Question ConnectionString for a Remote Sql Server

    Thanks jmcilhinney But as yon can imagine im rather new to this and would appreciate a bit of direction in establishing the proper sqlserver login permissions in accord with a logged in window user. I will be only allowing connection to the sql server through a fixed TCP/IP port as a final...
  3. F

    Question ConnectionString for a Remote Sql Server

    Im trying to connect to the Sql Server from another PC on the same network using ADO.net. This is the ConnectionString and error: Dim CnnStr1 As String = "Data Source=192.168.1.118;Initial Catalog=MySample;Integrated Security=True" 'Error Login Failed for user 'KAY_NET\Guest'...
  4. F

    Question Calling function from another form

    A general ruled that i have used, is to determine if the exact same method is needed from various places within the application. If so, then the sub or function should be declared as Public and place in a Public Class or Module. You may also define a public function or sub within a form and call...
  5. F

    Question Sql Server 2005 Remote Connection Problem

    ** Remote Server machine Settiings** Computer Name :KAY_NET Instance ID :MSSQL.1 Insatnce name :SQLEXPRESS IP Address :192.168.1.118 **Surface Area Config for services and Connections** --DataBase Engine-- Startup Type :Automatic Service Status :Running Server Name :SQLEXPRESS Remote Conn...
  6. F

    Question is shared function or not?

    If a method is shared you dont have to instaniate an object to use it. String.Format(...) if a shared method, no need to instance an object. dim Cnn as new sqlConnection Cnn.ConnectionString="..." Cnn.ConnectionString is a member of sqlConncention which must be instanced first before using.
  7. F

    Question add component

    Right click "Application Root" in Solution explorer Click Add>Component. Or use Project Menu Item and click Add.Component.
  8. F

    Start External Program

    Add a reference to the external dll and start it from within your program, by what ever method suites your needs.
  9. F

    Question using a field in a database to keep a counter

    item=combobox.selecedindex-1 or combobox.selecedindex, depending... Test It. slq statement="Update [tablename] SET MyCounter=MyCounter+1" Hope It Helps.
  10. F

    Adding to list collection generates an error

    Its Private Assets as new List(of Assets) Not Property Assets as ... if you need to reference it from a property you still need to declare it properly then create a property structure that references the Assets declaration. Hope this helps.
  11. F

    Reading magnetic swipe card output

    there is nothing cryptic about ASCII, its just letter numbers and symbols. What your seeing has to do with the card manufacturer. Contact the card vendor about the contents of the data on the strip, and any demo code to construct and deconstruct data on the strip, if its not security data.
  12. F

    Question How can i catch a select item in combobox?

    Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged MsgBox(ComboBox1.SelectedItem) End Sub
  13. F

    Writing to file problem...

    Attach a read file button. Attach a popup menu to the listbox. But do change the code. Unless of course your listbox only has one item in it.
  14. F

    Writing to file problem...

    Dont create a string variable everytime SelectedIndexChange occurs, huge waste. try If System.IO.File.Exists(listbox1.SelectedItem)=true the ...
  15. F

    Help - WPF Capture MainWindow Close Event

    Private Sub Window1_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles Me.Closing If Not MsgBox("do u want to close", MsgBoxStyle.YesNo) = MsgBoxResult.Yes Then e.Cancel = True End If End Sub
  16. F

    Question Open new default browser window from button

    'Just Found this online, was looking for it myself. it works great and should serve your purpose with a few modifications. 'By Zebula8 Public Class Form1 Friend Function GetDefaultBrowser() As String Dim browser As String = [String].Empty Dim key As...
  17. F

    "DoEvents" or update GUI while a database query is running

    Create as seperate thread and run the query asynchronously with a callback informing you when the process is complete. Moderate Difficulty. Plenty of samples online.
  18. F

    created a table/datagriview when a button is pressed. then how to connect/add to SQL

    use Entity Framework, Model first Approach. Can't offer any code, learning the object model myself. Check if out, Im sure it will do the job.
  19. F

    I need some better understanding of File I/O

    'I agree with Gopher 2011 a dataset or xml would be a better option. 'But i guess the point of the exercise is to learn about sequential file handling and file I/O. 'For this code to run add the following to a form: 'Create Data File 'Add File Path to form level variable 'TextBox = txtid...
  20. F

    Calling/caller forms

    Try opening the data entry form as showdialog which would prevent any other actions from taking place until the dialog is closed. This would return to the calling form only.
Back
Top