|
I am doing it in C# windows application not in asp. Any idea how to do it?
|
|
|
|
|
Terence van Schalkwyk wrote: string strSql = "select * from Names";
1. You could change your query to fetch only the name.
Terence van Schalkwyk wrote: dataGridView1
2. You could hide the first column inside the datagrid by using the visible property of the column.
dataGridView1.Columns(0).Visible = False
Quidquid latine dictum sit, altum videtur.
Whatever is said in Latin sounds profound.
|
|
|
|
|
Abhinav S wrote: 1. You could change your query to fetch only the name.
Not an option as I might need the id elsewhere
Abhinav S wrote: 2. You could hide the first column inside the datagrid by using the visible property of the column.
dataGridView1.Columns(0).Visible = False
Worked perfectly by doing the following:
dataGridView1.Columns[0].Visible = false; instead of () needed to use [].
Thanks. Now just to name my Columns!
|
|
|
|
|
Solution:
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "First Name";
Is this the best way to do it? Any downsides?
|
|
|
|
|
If someone added another column, or insert a column before the firstcolumn, the datagridview will display wrongly. Generally I will define the columns to be displayed and their order, instead of hiding the columns that I do not want to display.
|
|
|
|
|
Define only the columns that you want to display in the datagridview:
this.dataGridView.AutoGenerateColumns = false;
this.dataGridView.Columns.Clear();
this.dataGridView.Columns.AddRange(GetGridViewColumns());
private DataGridViewColumn[] GetGridViewColumns()
{
DataGridViewTextBoxColumn id = new DataGridViewTextBoxColumn();
id .DataPropertyName = "ID";
id .HeaderText = "ID";
id .Name = "ID";
id .SortMode = DataGridViewColumnSortMode.Automatic;
id .ReadOnly = true;
id .Width = 100;
id .DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
id .DefaultCellStyle.Format = "";
DataGridViewTextBoxColumn name= new DataGridViewTextBoxColumn();
name.DataPropertyName = "Name";
name.HeaderText = "Name";
name.Name = "Name";
name.SortMode = DataGridViewColumnSortMode.Automatic;
name.ReadOnly = true;
name.Width = 100;
name.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
name.DefaultCellStyle.Format = "";
return new DataGridViewColumn[] { id, name };
}
|
|
|
|
|
Thank you so much this is perfect. Just what I am looking for! Codeproject is such a great community!
|
|
|
|
|
try this after you set the DataSource:
dataGridView1.DataSource = dset.Tables["Names"];
dataGridView1.Columns["ID"].Visible = false;
Hope it could help you.
|
|
|
|
|
Hi...
I am getting NotSupportedException "The given path's format is not supported."
XmlDocumentObject.Save(filename);
filename is "L:PROT", because it contains colon that's why exception is coming.
Is there any alternative to use : in filename which could be saved in XmlDocument?
Thanks in Advance..
Piyush
|
|
|
|
|
There are certain characters and filenames (such as CON or PRN) that you can't use when writing out a file. The : is used as a part of path identification, so is unavailable. You need to remove this colon.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
hi,
System.IO.Path.InvalidPathChars will return a char array contianing the platform specfic characters that cannot be specified in path string.
-> compare your characters against the invalid chars to determinate that your path is valid or not..
greetz
|
|
|
|
|
Hi everyone;
I want to add some information on my print document.
To be precise
I'm printing my DataGridView like this:
private void button5_Click(object sender, EventArgs e)
{
if (SetupThePrinting())
MyPrintDocument.Print();
}
private bool SetupThePrinting()
{
PrintDialog MyPrintDialog = new PrintDialog();
MyPrintDialog.AllowCurrentPage = false;
MyPrintDialog.AllowPrintToFile = false;
MyPrintDialog.AllowSelection = false;
MyPrintDialog.AllowSomePages = false;
MyPrintDialog.PrintToFile = false;
MyPrintDialog.ShowHelp = false;
MyPrintDialog.ShowNetwork = false;
if (MyPrintDialog.ShowDialog() != DialogResult.OK)
return false;
MyPrintDocument.DocumentName = "Customers Report";
MyPrintDocument.PrinterSettings = MyPrintDialog.PrinterSettings;
MyPrintDocument.DefaultPageSettings = MyPrintDialog.PrinterSettings.DefaultPageSettings;
MyPrintDocument.DefaultPageSettings.Margins = new Margins(40, 40, 40, 40);
if (MessageBox.Show("Verilerin sayfaya ortalanmasını istiyor musunuz?", "Baskı Özellikleri - Sayfa Ortalama", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
MyDataGridViewPrinter = new DataGridViewPrinter(dbGridView, MyPrintDocument, true, true, "KASA DÖKÜMÜ\n\nbakiye:"+label17.Text+" gelir:"+label19.Text+" gider:"+label18.Text+"", new Font("Tahoma", 10, FontStyle.Bold, GraphicsUnit.Point), Color.Black, true);
else
MyDataGridViewPrinter = new DataGridViewPrinter(dbGridView, MyPrintDocument, false, true, "KASA DÖKÜMÜ\n\nbakiye:"+label17.Text+" gelir:"+label19.Text+" gider:"+label18.Text+"", new Font("Tahoma", 10, FontStyle.Bold, GraphicsUnit.Point), Color.Black, true);
return true;
}
So, I need to make two changes:
1. I need to add a line to the end of the document to put the information on my label#'s, how to put this line properly ( if possible such as: "The information is" +label7.text+ " format)
2. Because of the number of columns, my document prints 6 pages for a 3-paged information. also uses first 3 pages for first 4 columns, and the last 3 pages for the rest of the columns. Reducing the character size in the print document could be a solution, but I don't know how to do that either.
Can anybody PLEASE help ?
|
|
|
|
|
Message Closed
modified 23-Nov-14 6:18am.
|
|
|
|
|
Thank you but it seems like PrintPage event is more likely used for adjusting the margins or determining the printable boundaries; generally features about the document. I think I just need to decrease the font size of the text in the printed document. any idea?
|
|
|
|
|
no one ?
|
|
|
|
|
Help please
Does anyone know an elegant way to initiate a bash/perl script (to run on a linux box) from a windows form written in C#?
Thanks
|
|
|
|
|
Never did it, but I think that the most straight-forward way would be to connect to linux through ssh and run commands.
Check this[^] article from CP.
|
|
|
|
|
Another idea is to use a folder which both machines share.
On the Linux machine, a program checks that folder for new files, and if a new file is encountered, that program then executes some actions depending on the file.
This method requires that you develop such an "observer" for Linux and get it running on the Linux machine before your users try to start something from your Windows program.
|
|
|
|
|
This seems way to convoluted and overly complex to be "elegant". Don't you think?
|
|
|
|
|
Excel Exception from HRESULT: 0x800AC472
I am exporting data to excel thru C# code.
while export is in progress, if I open any excel file (not necessariliy the one being created), I get the above error.
Earlier I was exporting on a background thread, but after reading various comments on google, I removed the background thread but the problem still exists.
Gurpreet
|
|
|
|
|
Message Closed
modified 23-Nov-14 6:18am.
|
|
|
|
|
I have created a simple application to show the problem:
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
Microsoft.Office.Interop.Excel.Application _objAppln;
Workbook _objWorkBook;
Workbooks _objWorkBooks;
Worksheet _objWorkSheet;
public Form1()
{
InitializeComponent();
InitializeExcelObjectModel();
}
~Form1()
{
DisposeExcelObjects();
}
void SaveExcel()
{
_objAppln.DisplayAlerts = false;
_objWorkBook.SaveAs("C:\\tmp.xls",
XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, false, Type.Missing, XlSaveAsAccessMode.xlNoChange,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
_objWorkBook.Close(true, "C:\\tmp.xls", false);
_objAppln.DisplayAlerts = true;
}
private void InitializeExcelObjectModel()
{
_objAppln = new Microsoft.Office.Interop.Excel.Application();
if (_objAppln != null)
{
_objWorkBooks = _objAppln.Workbooks;
_objWorkBook = _objWorkBooks.Add(Type.Missing);
_objWorkSheet = (Worksheet)_objAppln.ActiveSheet;
}
}
public void DisposeExcelObjects()
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(_objWorkSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(_objWorkBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(_objWorkBooks);
System.Runtime.InteropServices.Marshal.ReleaseComObject(_objAppln);
_objWorkSheet = null; _objWorkBooks = null; _objWorkBooks = null; _objAppln = null;
}
private void button1_Click(object sender, EventArgs e)
{
string cell1 = string.Empty, cell2 = string.Empty;
string[] chars = { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T" };
for (int row = 1; row < 1000; row++)
{
for (int column = 0; column < 20; column++)
{
cell1 = chars[column] + row.ToString();
Range objRange = _objWorkSheet.get_Range(cell1, cell1);
objRange.Value2 = cell1;
System.Runtime.InteropServices.Marshal.ReleaseComObject(objRange);
objRange = null;
}
}
SaveExcel();
}
}
}
Project will need a reference of Microsoft.Office.Interop.Excel.dll
While button1_Click is processing, at that time if you open any other excel and just click on cells... it throws error.
Gurpreet
|
|
|
|
|
i want to turn y usb into a smart drive, however the u3 website seems to be unavailable
is there a source code that i can compile to make the u3 converter?
|
|
|
|
|
The site seems to be working for me - clickety[^].
DaveIf this helped, please vote & accept answer!
Binging is like googling, it just feels dirtier. (Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
|
|
|
|
|
I'm cropping an image and after i cropped the image,i want to put the image in a container as thumbnail...can anyone help me...how can i refresh the directory / folder where the image i cropped was save...thanks in advance guys...
|
|
|
|
|