|
There are many ways to do this with an enum, but you may want to take a look at the Description attribute. This[^] is a great article - chock full of yummy enummy goodness.
|
|
|
|
|
I am using a Data class to return data from SQL server
<br />
DataSet tpoDataSet = new DataSet();<br />
command.Transaction = transaction;<br />
command.CommandText = psSqlStatement;<br />
command.Connection = ipoConnection;<br />
adapter = dbProvider.CreateDataAdapter();<br />
adapter.SelectCommand = command;<br />
adapter.Fill(tpoDataSet);<br />
<br />
return tpoDataSet;<br />
Its in a dll which is used across different projects for linking to SQL and has
proven its reliability in the past.
However I am passing a sql string to return information on a table in a database
<br />
"SELECT column_name as colname ,data_type as datatype, " + <br />
"character_maximum_length as CharLen,numeric_precision, " +<br />
"numeric_scale, column_default as defaultvalue , " + <br />
"CASE WHEN COLUMNPROPERTY(object_id(table_name),column_name,'IsIdentity') =1 THEN " +<br />
"'YES' ELSE 'NO' END " +<br />
"as 'IsIdentity', " +<br />
"is_nullable as IsNullable " +<br />
"FROM [" + psTargetDb + "].INFORMATION_SCHEMA.COLUMNS " +<br />
"WHERE TABLE_SCHEMA = 'dbo' " +<br />
"AND table_name <> 'utSqlLog' " +<br />
"AND table_name = '" + tpsTableName + "'";<br />
the problem is with the line
<br />
"CASE WHEN COLUMNPROPERTY(object_id(table_name),column_name,'IsIdentity') =1 THEN " +<br />
"'YES' ELSE 'NO' END "<br />
which is returning 'NO' even if the field is an identity field. If I cut and
paste the query into sql and run it then I get the field values that I would expect!
Help appreciated.
|
|
|
|
|
Hi,
Please let me know if there are any good books to start with plugins for MS office, Outlook, IE etc using C#? I loking into few links on MSDN but wanted to see if anyone has some pointers on it?
Appreciated
Thanks
Vikas
|
|
|
|
|
|
I tried to install VSTO but I have C# 2005 express edition and doesnt support.
Is there anyway I can try VSTO on Express edition?
Thanks
Vikas
|
|
|
|
|
most of the pluging application uses COM as underlying technology , C# make it quite easy to use the plugin in any other applicaiton , there are lot of book avaliable on pluging but most of them uses sample code in C++ or VB, you get the concept from there and can implement the same using C# sementic which are quite simple as compared to COM in C++
Regards,
Sunil Tonger
|
|
|
|
|
In my prohect I have menustrip with sub items.but I have used KeyBoard Hooks in prohect and j't allow Up n Down arrow.I want to collopse menu bar and iterate by arrow.(no mouse even).
If U have any suggestion please help me.
Thanks in advance!
|
|
|
|
|
Hello friends ,
I am facing problem dealing with blob data using C#. can anybody tell me how to read and write data in blob field .
thankin you ...
|
|
|
|
|
|
hi there,
I am trying to read and write .xls file into the database table.
It writes the file successfully and reads as well .. but when I try
to open it after reading it from database it shows that the file is
read only and sometimes it shows that the file is corrupted ...
waiting for your reply ...
thanking y o u ...
|
|
|
|
|
Hello everyone,
Any recommended tutorials or code about how to use C# to implement Windows Service?
thanks in advance,
George
|
|
|
|
|
Google not working for you?
Giorgi Dalakishvili
#region signature
my articles
#endregion
|
|
|
|
|
|
|
Cool, N a v a n e e t h!
regards,
George
|
|
|
|
|
Hi!
There is a VS add-in.
In it I need to create a user control that would draw icons on pane on the left side of text editor window (like breakpoints) and react to OnMouseOver(like Hint) and MouseDown events
I'd be glad for any help.
(sorry for my English )
|
|
|
|
|
|
Hi all,
I'm trying to extend GridView control to add in the Pager row a DropDownList with values to change the PageSize. The thing here is that, to make it general, I'd like to add the values to the DropDownList either in the Properties window at design time or in the code behind. I created a class to keep the values and, following instructions found in several forums, add the requested attributes.
Here is the code:
[DefaultProperty("Text")]
[ParseChildren(true), PersistChildren(false)]
public class MyGrid : GridView
{
protected SizeItemCollection _PageSizeItems;
[Category("Paging")]
[Editor(typeof(CollectionEditor), typeof(System.Drawing.Design.UITypeEditor))]
[PersistenceMode(PersistenceMode.InnerDefaultProperty), MergableProperty(false)]
[DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
[Description("Items list for the PageSize selector DropDownList")]
public SizeItemCollection PageSizeItems
{
get
{
return (_PageSizeItems != null ? _PageSizeItems : new SizeItemCollection());
}
}
protected override void InitializePager(GridViewRow row, int columnSpan, PagedDataSource pagedDataSource)
{
}
}
public class SizeItem : Component
{
private int _size;
public SizeItem() { }
public SizeItem(int size)
{
_size = size;
}
public int Size
{
get { return _size; }
set { _size = value; }
}
}
public class SizeItemCollection : CollectionBase
{
}
I manage to see the PageSizeItems modal form in design time to add the values, but I don't know why they are not stored properly. Same problem happens if I try to add the values in the code behind using the Add(SizeItem) method.
I'm pretty new to C# and .NET and would really appreciate some help on this. Please feel free to ask any other questions.
Thanks in advanced
|
|
|
|
|
Hi
I want to connect with gmail.com that get my emails. In .Net.Mail is only SmtpClient class, I've searched in google but I've found only how to send mails with gmail. I cannot find how to receive mails from gmail.
Does anyone know something free library to do it?
dift
I
|
|
|
|
|
|
Good evening
I am using C#.Net for my project. I want to fill the Data Grid with certain records. But most of the examples will fill all the records in the Data Grid. How should I rectify this?
Please email to :-
moraali_ali@yahoo.com
|
|
|
|
|
Use a query with filter criteria to return only the data you need to bind to the grid.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I use a PostgreSQL database and this is the way I fill a datatable, and the parse the datatable to the gridview, assuming that it is called dtgview1.
try<br />
{<br />
NpgsqlConnection conn = new NpgsqlConnection("Server=" + server + ";" + "Port=" + port + ";" + "User Id=" + username + ";" + "Password=" + password + ";" + "Database=" + dbname + ";");<br />
DataTable dt = new DataTable();<br />
conn.Open();<br />
NpgsqlDataAdapter da = new NpgsqlDataAdapter("SELECT * from messages ORDER by mes_id", conn);<br />
da.Fill(dt);<br />
conn.Close();<br />
<br />
dtgview1.DataSource = dt;<br />
<br />
}<br />
catch(Exception ex)<br />
{<br />
MessageBox.Show(ex.toString());<br />
conn.Close();<br />
}
That's it
|
|
|
|
|
like i want to see the call stack of another process..
My small attempt...
|
|
|
|
|
Expose a method in that other process that returns the call stack and use remoting to get to it.
|
|
|
|