User Profile

Collapse

Profile Sidebar

Collapse
Denden
Denden
Last Activity: Feb 6 '17, 04:51 PM
Joined: Aug 21 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Denden
    started a topic Populating a GridView Inside a UserControl

    Populating a GridView Inside a UserControl

    Hello everyone, i'm having a problem on how to populate my gridview since the gridview's are not within the same Form.

    Let me try to explain how the form is setup. Let's imagine i have a Button1, then Two Panels. Upon clicking the button1, i will add a custom control which contains a gridview inside of those two panels. Just like panel1.controls .add(controlToB eAdded).

    Everything works fine except when populating the...
    See more | Go to post

  • Denden
    started a topic SQL Bulk Copy AutoMapping in VB.NET

    SQL Bulk Copy AutoMapping in VB.NET

    I have this simple code on VB.NET that inserts data from Excel Spreed Sheet to SQL Server database, now i want the data to be inserted on my database automatically without manually calling the columnmapping.a dd. Basically, i will insert the data base on the header row on the excel spread sheet.

    Here is my code..
    Code:
    Using connection As New OleDbConnection(Excelconnection)
                Dim cmd1 As New OleDbCommand("SELECT
    ...
    See more | Go to post

  • Denden
    started a topic Dividing Project in Multiple Executables

    Dividing Project in Multiple Executables

    Hello, we have a group project in school and we asked to make a simple system, my problem is how do I divide the system into multiple executabls so that I will not be the only one doing the whole thing since this is a group project, maybe one of my classmate will do the updating of the application, I will do the login form, the other one will do the CRUD and so on and so forth.. Thank you.
    See more | Go to post

  • Denden
    started a topic Align integer to Left on Gridview

    Align integer to Left on Gridview

    Hello, how to aligt the integer values to the left. Im using Devexpress Gridview. ...
    See more | Go to post

  • Denden
    started a topic MDI form

    MDI form

    Hello bytes, i am trying to call a form using keydown event and it works if the active form is not an MDI container but how if the active form is an MDI container itself?
    Thanks
    See more | Go to post

  • Denden
    replied to Saving Database Connection using Config.ini
    i am now using app.config. Thanks btw. Cheers
    See more | Go to post

    Leave a comment:


  • Denden
    replied to Internal Database Version
    My server version is 12.0.2 and i tried to created a testDB on sql server 10.50.400 so i am expecting the database version to be 660/661. Thanks for helping me....
    See more | Go to post

    Leave a comment:


  • Denden
    replied to Internal Database Version
    Thanks for the reply CK but the query gave me a null value.
    I tried this query.
    Code:
    SELECT DatabaseProperty ('TestDB', '660');
    SELECT DatabaseProperty ('TestDB', 660);
    and gave me an error.


    i also tried
    Code:
    SELECT DatabaseProperty ('TestDB', 'version');
    and return 728 version but that database was created using earlier version....
    See more | Go to post

    Leave a comment:


  • Denden
    started a topic Internal Database Version

    Internal Database Version

    hello, do you know how to determine the database version of a database on sql server management studio for some compatibility reasons because not all of the databases are created using the version of sql server i am currently running. some of them are attached using backup. Thanks.
    See more | Go to post

  • Denden
    started a topic Saving Database Connection using Config.ini

    Saving Database Connection using Config.ini

    Ive been searching tutorial on youtube and other known sites on how to save/read the database connection on the config.ini file. Lets say i have this connection,
    Code:
    SQLServer:192.168.1.2
    UserName:sa
    Password:1234
    DatabaseName:SampleDB
    i find it easy to configure my connection if it would be setup that way but i find a hard time getting a tutorial for that. What would be the things to need if ill be...
    See more | Go to post

  • Denden
    replied to Integer to boolean convertion
    um, i tried to input 1 and expecting that the compiler will give me a false value but give me an error instead.

    System.FormatEx ception: String was not recognized as a valid Boolean.
    at System.Boolean. Parse(String value)
    at System.Convert. ToBoolean(Strin g value)
    See more | Go to post

    Leave a comment:


  • Denden
    started a topic Integer to boolean convertion

    Integer to boolean convertion

    Good evening, ive written a simple code but throws an error in C#, why is this happen.
    Code:
    	bool inputValue = Convert.ToBoolean(Console.ReadLine());
    		Console.WriteLine(inputvalue);
    		Console.ReadLine();
    See more | Go to post

  • Denden
    started a topic Updating a value if cell is DBNull

    Updating a value if cell is DBNull

    hi, i want to know how to implement this one, im trying to do a login page in vb.net and after 3 consecutive login attempts, the username will be locked and will not be able to login to the system.

    inside my database, i have three columns, the username, password, and loginattempst column.

    Code:
    Dim cmd As New SqlCommand("select * from users where username=@username", conn)
    cmd.Parameters.AddWithValue("@username",
    ...
    See more | Go to post

  • wow. thumbs up for the explanation. by the way, im using datareader in reading data, is that the best to use.
    See more | Go to post

    Leave a comment:


  • already fixed. thanks
    See more | Go to post

    Leave a comment:


  • Tables is not a member of System.data.datatable

    hi again, im stuck with this error. please help me....
    See more | Go to post

  • @frinavale

    i am reading the articles @home&learn website and i found it different from yours, here the way they did on how to update data on database

    Code:
    Dim cb As New OleDb.OleDbCommandBuilder(da)
            ds.Tables("Denden").Rows(inc).Item(1) = TextBox1.Text
            ds.Tables("Denden").Rows(inc).Item(2) = TextBox2.Text
            da.Update(ds, "Denden")
    ...
    See more | Go to post

    Leave a comment:


  • Denden
    replied to Converting Integer to Double
    im just trying if it can be done sir. im just experimenting with them. thank you for helping me out.
    See more | Go to post

    Leave a comment:


  • Denden
    started a topic Systax Error (Missing Operator)

    Systax Error (Missing Operator)

    hi im reinventing a code myself but when i tried to run it didnt work as expected. i dont want to copy all the one ive downloaded so i made it a smaller by reducing the control use and not using search command.

    so heres my very simple code
    Code:
    Private Sub loadrecord()
    
    
            Dim conn As New OleDbConnection(Get_Constring)
            Dim cmd As New OleDbCommand
            Dim dr As OleDbDataReader
    ...
    See more | Go to post

  • Denden
    started a topic Converting Integer to Double

    Converting Integer to Double

    i'm on my way on learning a new language vb .net and i have a hard time figuring out what might be the solution. Heres my code.

    Code:
       Dim x as integer = 4
            Dim y as integer = 8
            Dim z As Integer = x / y
            ' i could just declare z as double if i want to but i dont want to do that
            ' i also tried to use convert to double
            'z = Convert.ToDouble(z) but return 0 as result
    ...
    See more | Go to post
No activity results to display
Show More
Working...