if i need short date and time then wts the method for that

thanks a lot sknake. Problem Solved

Hi all, I have created a table in which i have a DateTime Column . i need that i dont want to insert values in that column from the front end. i have created a trigger for that purpose. whenever i...

hi all, i m working on a project(Inventry System) in which i have to update stock frequently. i have created a trigger in SQl for stock updation. if i insert for a particular product in stock table...

Hi All, i m currently making a project on departmental store. i m facing a problem in it. i m facing the same problem while Billing and at the time of stock maintainance. the problem is as follows:
...

Hi all i m working on a component to generate reports. when user uses this component it should prompt the user wheather oracle/SQL server/Access should be used. on the basis of the user's input it...

hi all, i m working on a component for MIS department. i need that when i run my component it should ask for: from where u want to retrieve ur data i.e. from Oracle/SQL Server/MS-Access. when i...

Hello Sir, Can u tell me how to merge two tables(no relationship) in datagridview. I have used merge method of datasets but in vain

Yes LIZr I have 2 DataSets And i Have Merged Them through Merge method of datasets. But Still I m not getting my result
I have Tried following
ds1.Merge(ds2);
dataGridView1.DataSource =...

Actually I want it to be done throuth DataSets. Actually it is an assignment

Hi all i want to display two unrelated tables in the same datagridview. I m using merge method of datasets but in vain. Any idea Plz

Thanks for replying, i have done all wt i wanted to but now i m facing another problem. when i enter a wrong product code a messagebox appeares but after that the control shifts on the next cell i.e....

HI all i m making a project for a departmental store. In that I have to make a bill generation form in which i have taken a gridview for the products entry which have been purchased by the customer....

Hi there I want to import Printing in my Application. But I m Unable to send the values to be printed in the Printing Class. i Initialize the Printing Class Variables from other class by Creating an...

Hi all I m making a project in which i have two textboxes to enter time of Departure and Arrival. The User can enter any string value in a textBox. But i want that user must enter a time format value...

Hi there, I have also the same problem But i m using SQLServer 2005. I have created Crystal Reports using wizards only but i want to do it throuth coding.
I just have added a report form to my...

Hi all i want to add my Column names in a combo box for some purpose But how i will do that because i dont know the number of columns in the table and new column in the table can be added from the...

it Didnt work at all But i have got the solution from somewhere else.
anyways thanks a lot

How can I cancatinate it ? i mean to say how i pass my primary key to find method which is composed of 2 columns

thanx for replying dickersonka and LiZr
I m doing it by adding primary key to my table and by using DataRowCollection's Find method. But the problem is that my primary key consists of 2 columns and...

Hi all I just want to add some functionality in my project. I simply need that when a user enters some details then based on some specific column values if the value entered by user already exists in...

Hi dickersonka, Can u plz post some code to trap which checkbox has been checked and how to trap that row
Its urgent plz

Can u please Give some code for that plz

sorry I couldnt understand ur suggestion. I explain u my problem. I m making a project on Airlines Reservation. Now after selecting source,destination,class and date of travel when user clicks on...

I have tried it with the coding given above But it is still not adding new column. Plus i want to know how that particular column can be bound with database column

Thanx for replying, Now i m using DataGridView with a checkBox column But now i m facing another problem. How i will come to know which checkBox user has checked and to trap the values of that...

Thanx for replying, But my motive is to add a new column with database values. How can i do it?

Hi all, Iwant to know is there any way to add a new column in datagrid depending upon the value of a combobox. I have columns in a table whose names are same as combobox's items names. I need to add...

Hi all,
I m facing a problem regarding datagridview. I have taken a gridview with a custom column with checkBox only. Every row in datagrid contains a checkbox as its first column.
Now i...

Hi all, I m making a project on airlines reservation in C#. I have some problem.
The problem is when i accept the values from the user like Origin City,Destination City,Date of travel and class of...

Hi all, I m making a project on airlines reservation in C#. I have some problem.
The problem is when i accept the values from the user like Origin City,Destination City,Date of travel and class of...

Hi I m Having a Problem in retrieving records.
I want to get nth maximum value in a column.
I have tried it using top
select top n ColumnName from tablename where(select top n-1 ColumnName from...

HI all, I just want to ask how we can add more than 1 table in dataset or dataadapter through coding not through wizard.

HI all I m facing a problem in my project.
I have made a form for users to change their password
But when i click on submit button i get an error msz in the form of exception
the msz is :...

Hi all i m facing a problem in my project.
I want to add all the rows of a particular column(based on name of the column) in the combo box without using data bindings wizard.
i need it through...

Thanks a lot Camilo I got my solution.

Thanx for reply Ramy but i think u didnt understand my problem. my problem is that i cant access any of the items in the menustrip. means when i type there is no option for these items. Even creating...

HI all i m making a project in which i have added menu named Login which includes items
like login, create new user, delete user, change password etc. i want to access these items on the basis of...

Hi all I have to make a form in my project which includes text NOW LOADING following 4 to 5 dots like ......, Now my motive is that on loading that form the dots should look like moving as is...

Sorry for providing insufficient information. My purpose was that nobody should be able to move the form from its location to other location in the application.
Wt should i do for that