|
hi,
at design time, select the datagridview and click on smart tag(which is top right corner of the datagridview). Now select option "Edit column". when you Choosing this option , a small window is appear.Left hand side part of this window,show the column. choose any column and then select "DefaultCellStyle" property and click on ellipse button.Now once again a window appear. from this window you set alignment (and others) property for individual column .
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
i am working on word macro. i have to copy down selected headings from one document into another.
For that i want to read heading 1 so as to display them on labels on a form . Can anyone guide me in this.
|
|
|
|
|
I am developing an application using VB.Net. On backend I am using MS Access and SQL Server 2005 both. I want to Import data from MS Access table to SQL Server 2005 table using VB.Net. For example, I have a table on MS Access Database name "tblInternship". And I have a table with the same name on SQL Server 2005 Database. Now I want to Import data from Access.tblInternship to SqlServer.tblInternship using Vb.Net.
How I can do this. Please send me a code or make me understand to solve this problem.
|
|
|
|
|
Hi,
This can be done in the following manner in SQL query analyzer.
---------------------------------------------------------------------
BEGIN CODE
-- option 1
INSERT INTO sqltable (field1, field2, field3)
SELECT FIELD2, FIELD2, FIELD3
FROM OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\accessfile.mdb";
User ID=Admin;Password=',tablename)
-- option 2
INSERT INTO sqltable (field1, field2, field3)
SELECT FIELD2, FIELD2, FIELD3
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\accessfile.mdb';'admin';'', tablename)
END CODE
---------------------------------------------------------------------
You may try the same thing using VB.Net.
I hope this helps  .
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
hi,
i need to solve a problem can any one help
problems:
1. i've have some images in database,i want to make it scroll in my windows application when i select a particuler image it should display the details in the controls in that form
this problem should be solved using vb.net 2005 and sql server for database
|
|
|
|
|
Justin Pravin wrote: 1. i've have some images in database,i want to make it scroll in my windows application
Scroll?? Like how?
It sounds like you're going for more functionality than you need right now. Try just showing an image in a picture box and handling it's click event to get and show the details of whatever you need first. Then you can move on to making it look fancy.
|
|
|
|
|
how to i save time n date in to database....i just know the code for show time n date..
datetimepicker.value=datetimepicker.now
but how to i save it ....can i use the update same as textbox and combo box..example like receipt there is date on top...when end of month i need retrieve from 1/1/08 until 31/1/08 how i can write the code
i update the latest date,and i stil can retrieve previous date...
Me.TimeTableAdapter.Update(Me.timeDataSet.timeIn)
do u all can help me up thanks....
this problem should be solved using vb.net 2005 and sql server for database
modified on Monday, March 31, 2008 3:37 AM
|
|
|
|
|
Member 4442916 wrote: Me.TimeTableAdapter.Update(Me.timeDataSet.timeIn)
OK. This tells me you've already created your database table and created a DataSet in Visual Studio. What's the column type in the database that's holding this date/time stamp? Do you know any SQL, like how to use SELECT, INSERT, UPDATE, DELETE??
|
|
|
|
|
ya i had aready create database from employee to time table.which mean example employee when enter password..then the time will automatically store in to login/out table
i no some sql...but i'm not so clear bout that..isit
UPDATE LogIn AND LogOUT
WHERE EmployeeName="XXX"
can i do like this or
INSERT LOGIN
VALUES
|
|
|
|
|
What is the data type of the column in the database table that's holding the date and time?? If you're using anything other than DateTime, you're going to have a very difficult time with this.
|
|
|
|
|
Login and Out datatype in database is date/time...i use bound method
in database employee table link to logIn and Logout table...which mean one employee has many login/out time..
modified on Wednesday, April 2, 2008 10:08 AM
|
|
|
|
|
How can i suppress the group header section if there is no record return in detail section?
thanks in advance!!! ^-^
jyn
|
|
|
|
|
jhyn wrote: How can i suppress the group header section if there is no record return in detail section?
Isn't that done automatically? 
|
|
|
|
|
Hi All,
I have created a customer database that contains customer details.
I have pasted a datagridview called CustomerDetailDatagridView that contains a list of the client details from the database.
In VB.net express 2008, is there a way I can filter the results of the datagrid simply by typing a name in a textbox just below the datagrid?
For e.g. I would like to type 'Jo' and all the entries with the term '*Jo*' will be returned (e.g. John, Johnathan etc).
Any help will be greatly appreciated...
A
|
|
|
|
|
Hello,
You can use the TextChanged() event of Textbox to filter the DataGridView.
Lets say, you have the following settings in Form_Load event of the application:
Me.OleDbDataAdapter1.Fill(DataSet11)
Me.BindingSource1.DataSource = DataSet11.Tables("Customers")
Me.DataGridView1.DataSource = Me.BindingSource1
Now in the TextChange() event, you can use the following code:
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
If TextBox1.Text = "" Then
Me.BindingSource1.Filter = ""
Else
Me.BindingSource1.Filter = "ContactName like '" & TextBox1.Text & "*'"
End If
End Sub
Now as you start typing in the textbox, it will start filtering the grid rows automatically.
I hope this will help.
Regards,
Allen
Allen Smith
Software Engineer
ComponentOne LLC
www.componentone.com
|
|
|
|
|
Hi All,
I am fairly new to programming in vb.net express.
I have downloaded a copy of vb.net express 2008 and was wondering how to open a crystal report from an application I have developed.
I have purchased a copy of crystal reports version 11 and created a new report that I have already linked into my database. (this report works fine when I double click and open it)
All I would like the application to do is when I click a button, I would like it to open my crystal report that I have saved on C:\temp.
Can I have step by step instructions please?
Abs
modified on Wednesday, April 2, 2008 2:39 AM
|
|
|
|
|
I have a web application in VS2008 VB.
I want to have a database check done at intervals. It seems to me that I should be setting it up using myapplication.startup - initiate a timer which does something useful every 30 minutes.
Trouble is, I can't figure out where my code goes. The MSDN article on how to add startup code directs me to menu options I cannot find. I get the general idea that I should have a file called "ApplicationEvents.vb" which has a startup event for class "myapplication" but it doesn't run the code.
I seem to remember using a config.web approach years ago, but I can't find a reference for that, either.
Thanks in advance. 
Everyone else's job looks easy
|
|
|
|
|
You don't need the Startup event at all. Simplify this.
How you do this depends on what you're "checks" are doing and what you want to do when the checks fail. If you're doing this every 30 minutes, you can write this as a console app or a Windows forms app and use the Windows Task Scheduler to run this app every half hour. When it's job is done, the app should quit on its own.
Or, you could skip the Task Scheduler and write it as an app that stays running for as long as you want, performing it's checks on whatever schedule you chose. You'd use a timer to check the current time against the scheduled time. You'd probably set this timer to 60000 milliseconds, which will fire the Tick event every 60 seconds. In this event is where you'd check the current system time against the scheduled time. If the two match, then you'd reschedule the next scheduled time and launch your checks routine.
|
|
|
|
|
hi 
i hope any one can help me
i want to ask how can i do undo && redo
in a database application that add delete and update
i want starting point pleas help
|
|
|
|
|
Google for "Command pattern".If you're looking to implement undo/redo operations in database transactions, you'd probably want to look into designing your database to log everything it does, including which fields it updates and what type of update what done to that record.
|
|
|
|
|
I have obtained and installed a copy of EZNamespaceExtensions, as I thought it would help me creating my application (an archiver, that shows the contents of the archive in a Namespace Extension).
I have created a new EZNamespaceExtensions project, and added my class to read archives, but could someone please point me in the right direction for making the actual Extension?
Thank you in advance, and Best Regards,
Fahad Sadah
|
|
|
|
|
|
That's great, but I've decided to just write it in C++. I just saw somewhere not to write namespace extentions in managed code.
|
|
|
|
|
I want to integrate 3 application into one parent window. Is this possible. Thanks.
|
|
|
|
|
IIRC, a long time ago I did this by basically getting the window's handle then calling SetParent() to change its parent to be my app. I figure there was more to it but maybe that will get you started.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
