The source code files are for VB.NET, there is no.SLN or.VBPROJ file included. I have seen this before with another component's source code files that I downloaded which was free. Is there a way to work with these files without a.SLN and.VBPROJ file? I have attempted to re-create a.VBPROJ file by attaching the. I have a datagridview with 1 column and any rows. I will use this to entry any data. What can I do to make this column can be added dynamically in runtime???
I am a bit new to this VB.NET application stuff. I currently try to develop a application using Microsoft Visual Basic. Net with Remote SQL Server 2005.In my application include user login using Username and Password. The application will use from many branches. Every branch have their own Username and Password. I create User Master table in SQL Server Database with SLN, User_name, Password, Branch, Note fields.
Now I want to design a VB.Net Form in my application where I can get all Username and Branch login status in a DataGridView like....
Header - *Branch Username Status*
Value - Kolkata U00001 Logged
How can I get this? If any senior vb.net developer or expert solve the same i will be very thanks full to him. Thanking you.
Daniel SmithDaniel Smith
1 Answer
Here is some SQL to extract the current users:
Note there are two levels of security in SQL Server - SQL Security and 'Integrated' security. The latter uses the windows login, SQL Security is managed by you within SQL Server. It looks like you intend to add an SQL user/login named for the branch with a defined password that everyone in the branch will use. Not a great idea IMO. You can use integrated security and add each windows user to SQL server and then add the SQL users to security groups to control access to the SQL objects. This would require each user to authenticate with your windows servers first locally before they can connect to the remote server.
I'd highly recommend you upgrade to at least SQL Server 2008 R2.
rheitzman![Format datagridview columns vb net Format datagridview columns vb net](/uploads/1/2/4/7/124794771/109054728.jpg)
![Net Net](/uploads/1/2/4/7/124794771/367954104.png)
1,9441 gold badge11 silver badges28 bronze badges
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.