If you are talking about the order of address components. i.e. (State, ZipCode) or (ZipCode, State) etc. then use String.Format function. The format string specific to each country may be stored in database.
Gulfraz Khan
Posts
-
Print address in country specific format -
1K Mifare CardI am writing to a 1K Mifare Card (RFID) in my windows application. How can I secure/personalize/encrypt this card so that only my application can read and write the data over it. Thank You
-
change datagridview column nameI assume you are talking about the column headers in the datagrid. you can use the column aliases to rename your columns before binding the datasource to the dataset in design mode. if you already have a bounded datasource then You can rename the column headers of the datagrid by using the following sample code MyDataGrid.Columns["catID"].HeaderText = "Cat ID"; MyDataGrid.Columns["desc"].HeaderText = "Description"; MyDataGrid.Columns[2].HeaderText = "Category Name";
-
Fancy search functionur scenario may be different, but, i used the following method in one of my application. dgv refers to a DataGridView object BindingSource bs = new BindingSource(); //u may create a custom data source and then populate it bs.DataSource = YourDataSource; dgv.DataSource = bs.DataSource; bs.Position = bs.Find("PropertyToBeSearchedIn", "TextToBeSearched");
-
How do I make a formless windows application?use the "main" method do not show any form (if u have any)
-
I want to open PDF File in my applicationI think u can use a browser control in ur application and then navigate to the url of the file. I hope it helps.
-
Data entry validation and databindingI am using visual studio .net 2008 and developing a windows forms application. I want to use databinding and keep the business/validation logic in a separate layer (other than presentation layer). The validation may be performed in ColumnChanged event or RowChanged event(depending upon user preference) of the datatable of the dataset. validation error message must be shown in a Message Box if validation is performed in ColumnChanged event and there are validation errors then the focus should be set to the control that has the validation errors. if validation is performed in RowChanged event (i.e. user hitting the save button) and there are validation errors, then the focus should be set to the control which comes first in the tab order and has validation errors. Is there any way i can do it?
-
dynamically setting MaxLength property of a Textboxwhy do i need to query the database for the length of the field since my textboxes are databound (using drag & drop from the data sources window) and the properties of the the datatables show the mapped fields (i.e. varchar(6) to system.string with length 6). Is there any way I can access these properties of the datatables.
-
dynamically setting MaxLength property of a Textboxbut, the problem remains. what length should i set as i don't know the lenght of the field in the database?
-
dynamically setting MaxLength property of a TextboxHi! i have many textboxes on a form in a vb .net 2005 application these textboxes are databound. Is there any way i can set the MaxLength property of these textboxes (which are bound to varchar fields in the database) to the size of the field in the database. Or how do i access the field (i.e. DataColumn of the table) to which a textbox is bound. Thank You
-
print a local rdlc report without showingThank you Giorgi for the link, I checked out the link, but it uses Reporting Services. and I don't want to use Reporting Services. My application is actually a Point of Sale which prints the Transaction Bills (embedded report). Showing the report in the reportviewer and then showing the print dialog irritates the user alternately, is there any way to print the report to the default printer without showing print dialog. thank you once again.
-
print a local rdlc report without showingI am creating a windows application using vb .net 2005 (i don't mind c#) and sql server 2005. i want to print a local (embedded) rdlc report without showing it. is it possible? if not, then how do i print the report (displayed in reportiviewer) without showing print dialog. Thank you.
-
print local rdlc report without showingI am creating a windows application using vb .net 2005 and sql server 2005. i want to print a local (embedded) rdlc report without showing it. is it possible? if not, then how do i print the report (displayed in reportiviewer) without showing print dialog. Thank you.
-
SQL Server 2000 Installation problem on Windows server 2003Thank You for reply. I will try it out
-
SQL Server 2000 Installation problem on Windows server 2003i am trying to install sql server 2000 standard Edition on Windows server 2003 but at the configuration time during the installation, Configration error message is shown pointing to "C:\windows\sqlstp.log". when I open this file it contains the following messages in the bottom. and setup exits. Sql Server Log ############################################################################## Starting Service ... SQL_Latin1_General_CP1_CI_AS -m -Q -T4022 -T3659 Connecting to Server ... driver={sql server};server=NICOPDB;UID=sa;PWD=;database=master [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified driver={sql server};server=NICOPDB;UID=sa;PWD=;database=master [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified driver={sql server};server=NICOPDB;UID=sa;PWD=;database=master [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified SQL Server configuration failed. ###############################################################################
-
Transfer data between databasesThank you Ennis. It really works for me. and thank you for the reference URL too.
-
How to convert amount into words in crystal reportif your data comes from a database then write a user defined function that takes the amount as parameter and returns the amount in words. use the this function in the select statement for retrieving the data and then display it. May be you can write custom code in Crystal Reports, but I am not sure how to do that.
-
One to many columns in a reportI have a table with one column. This table has more than 1500 rows. I want to print those 1500 rows of one column using 4 columns in the report(rdlc). How is it possible?
-
Transfer data between databasesI have two SQL server databases on the same server. The table structure is same except for few. I want to move some records from different tables one database to another. What is the best way to do it? create a DTS package, but I don't know how it supports 'Begin Tran' and the 'Execute SQL Task' in the DTS does not take any parameter (i.e. global variables) in the update and delete statements. If I create a Stored procedure and use the 'Begin Tran' and 'Commit' statement in the procedure. It also does not work for me since the stored procedure keeps on executing the statements that are followed even if any error occurs (i.e. primary key violation etc.). How do I make sure that the statements in the stored procedure are rolled back or procedure exits when any error occurs in it. Thank you for helping me.
-
One to Many columnsI have a table with one column. This table has more than 1500 rows. I want to print those 1500 rows of one column using 4 columns in the report(rdlc). How is it possible?