|
combobox.datasource = data.tbtest;
combobox.DisplayMember = "Text";
comboBox.ValueMember = "ID";
This code populates the combobox droplist. and the user selects the appropriate value and the selectedvalue ID gets stored into the Form Table on Button click.
Just to add on (on Button Click)
table.TestID = Convert.ToByte(comboBox.Selectedvalue)
I hope this makes sense.
|
|
|
|
|
I'm not clear why you are converting it to a byte, however ...
SelectedValue is of type Object and so you will be calling the Convert.ToByte overload that takes Object , which MUST implement IConvertible . Int32 does not implement this interface.
The solution is to force it to an int first . e.g.
table.TestID = Convert.ToByte((int)comboBox.Selectedvalue)
|
|
|
|
|
|
Thanks, I stand corrected. I checked as far as it is a structure and missed the interface declaration.
|
|
|
|
|
Sorry mate. By CType do u mean Conversion.ChangeType in C#?
Could you provide the same in C# please.
I am converting it to Byte because the column in of type tinyint (8 bit integer = 1 byte)
Thanks,
|
|
|
|
|
Thanks for the answer. When i select an item from the combobox and tab to the next control... its giving me the same exception. Do I have to change any property of the combobox?
Cheers!!
|
|
|
|
|
spankyleo123 wrote: . When i select an item from the combobox and tab to the next control... its giving me the same exception
What excepiton? Where it does happen, and in witch event?
|
|
|
|
|
Its this one ... "ByteConverter cannot convert from System.Int32." NotSupportedException was unhandled.
This happens when i select a combobox item and go to next control on the form.
Many thanks,
|
|
|
|
|
This thread seems to be getting lost. Try stepping through the code in the debugger (put a breakpoint where the exception occurs), and capture all values. Then post those values, the exception, and the code around the exception, so people can see everything that is involved with the problem in one message. txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
I've tried at least three free custom controls, and either they make very broad assumptions, or are so poorly designed and documented as to be unusable.
I've tried SuperList, ObjectListView, and one other that I don't recall the name of.
I need the following features (in order of importance, but first three are must-haves):
0) The ability to put one *or more* images in a given cell along with text
1) Sorting on any column
2) Supports grouping
3) Multi-line items
4) Alternate row colors
Can anyone steer me to something usable (and free)?.45 ACP - because shooting twice is just silly ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
|
Wow, that looks great! I'm gonna go check it out..45 ACP - because shooting twice is just silly ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
Hey,
I want to create a .xlsx file based on data from a grid.
My problem: I have values like 01234 (starts with zero) exporting them make 1234 ... so, how can I export it with right format?
I fill the file with:
if (Excelpfad == "")
return false;
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
Microsoft.Office.Interop.Excel.Workbook newWorkbook = excelApp.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.Office.Interop.Excel.Sheets excelSheets = newWorkbook.Worksheets;
string currentSheet = "Tabelle1";
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)excelSheets.get_Item(currentSheet);
for (int i = 0; i < UsingGrid.Cols; i++)
{
for (int j = 0; j < UsingGrid.Rows; j++)
{
worksheet.Cells[j + 1, i + 1] = Convert.ToString(UsingGrid[j, i]);
}
}
for (int iExcel = 0; iExcel < UsingGrid.Cols; iExcel++)
{
((Microsoft.Office.Interop.Excel.Range)worksheet.Columns[iExcel + 1, t]).ColumnWidth = UsingGrid.get_ColWidth(iExcel) * 0.13171875;
}
if (Excelpfad.Substring(Excelpfad.LastIndexOf(".")) == ".xls")
worksheet.SaveAs(Excelpfad, Microsoft.Office.Interop.Excel.XlFileFormat.xlExcel8, t, t, t, t, t, t, t, t);
else if (Excelpfad.Substring(Excelpfad.LastIndexOf(".")) == ".xlsx")
worksheet.SaveAs(Excelpfad, t, t, t, t, t, t, t, t, t);
and another question: how can I close that file correct?
I have:
newWorkbook.Close(true, n, n);
excelApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
but the "EXCEL.EXE" process still run
thank you
|
|
|
|
|
Mschauder wrote: for (int j = 0; j < UsingGrid.Rows; j++) { worksheet.Cells[j + 1, i + 1] = Convert.ToString(UsingGrid[j, i]); } }
first question:
something like:
r.NumberFormat = "@";
Note this is language specific(system language and settings).
Best way to do it is record a macro while you set the Format to text and look at the VBA produced and
translate it to C#. This silly article is especially about formatting. And the export is a lot faster than the cell by cell aproach.
|
|
|
|
|
Hi,
I am allowing user to select datetime in datetimepicker in "dd/MM/yyyy" format but when it stores in sqlserver 2005 it store as "mm/DD/yyyy", but i want it store as "dd/MM/yyyy" format in SqlServer 2005, how can i do that OR When i filter records, it should be in "dd/MM/yyyy" format ?
Regards,
XYZ
|
|
|
|
|
The internal format used to store a date time has nothing to do with how it is serialized as a string. Both SQL and C# have techniques for serializing date/times. In particular, you'll want to look into DATEPART and CONVERT for SQL and ToString and String.Format for C#. The C# DateTime also has several methods that allow you to serialize to different common formats.
|
|
|
|
|
Write in SQL Select Query
Select Convert(varchar(10),getdate(),103) Like this will return dd-MM-yyyy
And in C# use .ToString("dd-MM-yyyy");
In grid use DataFormatString Property and make sure HTMLEncode="False" set in That columnBest Regards,
Chetan Patel
|
|
|
|
|
I already know how to do that... you might want to reply to the OP to tell him/her what you've told me. Though, to be honest, I think I gave him/her enough information already.
|
|
|
|
|
you might want to read this[^].
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
Hello,
I get Error when i setup my service.
Error NUM 1001-Your password or your user is incorrnet.
SOMEBODY CAN TO HELP ME?WHAT TO DO?
|
|
|
|
|
Message Closed
modified 23-Nov-14 7:09am.
|
|
|
|
|
|
How to uninstall a program from Add/Remove Programs. Please guide me to achieve this programmatically. Thanks in advance.
|
|
|
|
|
Found this here[^].Me, I'm dishonest. And a dishonest man you can always trust to be dishonest. Honestly. It's the honest ones you want to watch out for...
|
|
|
|
|
|