|
All good advice. Thanks for your time luc!
|
|
|
|
|
Hello,
When i use the Fill() method from the data adapter, every column from the sql table is being mapped to a c# type variable,now i need the original sql server type of each column to dynamically populate a sqlCommand's parameters. How can I map the variable back to it's corresponding SqlDbType, is it possible?
example:
table customers(integers int,
MyFloats floats)
...........
select * from customers -> myCusomers
myCustomer.Columns[0].DataType.Name=Int32
how can i specify that my Int32 was a SqlDbType.Int
desired output is:
cmd.Parameters.Add("@ints", [myCustomer.Columns[0] as SqlDbType.Int], [myCustomer.Columns[0].size], myCustomer.Columns[0].Name);
Thanks!
drinking beer is fun
|
|
|
|
|
The simplest way would be to implement a simple look up table:
internal static class SqlHelper
{
private static Dictionary<Type, SqlDbType> types = new Dictionary<Type, SqlDbType>();
static SqlHelper()
{
types.Add(typeof(int), SqlDbType.Int);
types.Add(typeof(double), SqlDbType.Float);
}
public static SqlDbType GetType(Type type)
{
if (types.ContainsKey(type))
return types[type];
return SqlDbType.Variant;
}
}
|
|
|
|
|
Thank you Ed, your information was very helpful and elegant
drinking beer is fun
|
|
|
|
|
Im am developing a windows app, and i have data populated into a gridview. Instead of allowing users to edit the data in the grid(which is probably the easiest way) I want to be able to select a row and have a modal form pop up with Textboxes and other controls to edit the data. How would i go about populating data in those controls from with the information of with the gridview?
|
|
|
|
|
Add a Column/Link button to the row, handle the cell content click event and pass a reference to the row data to the new form:
<code>private void dgv_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (dgv.Columns[e.ColumnIndex] is DataGridViewButtonColumn)
{
DataForm df = new DataForm(dgv.Rows[e.RowIndex]);
df.ShowDialog();
}
}
I think that should do it!
-- modified at 17:33 Wednesday 18th July, 2007
|
|
|
|
|
hi all
i need an API that enables my application to send and recieve e-mails using SMTP & POP3
p.s. dont want these mails to be recieved as spams
Mostafa Ismail
|
|
|
|
|
You can use the System.Net.Mail namespace to send emails. Receiving them isn't built into the .NET Framework. You'll have to use some other library or P/Invoke the MAPI Win32 functions to get the mail. Or, be adventurous and write your own POP3 client.
Mostafa_Ismail wrote: .s. dont want these mails to be recieved as spams
You don't get to make that determination. Whether or not your email is received and interpreted as spam is entirely up to the person receiving it.
|
|
|
|
|
|
Is it possible to make a button lose it's focus once a mouse has passed it? (i mean, if it's clicked and held down and then the mouse moves out of the button).
for example, the buttons in Minesweeper are like that. so, is there any way to do so?
|
|
|
|
|
Set the focus to something else.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
but how would i know which button to set the focus to? (did you even look at minesweeper to see what i meant?)
|
|
|
|
|
sharpiesharpie wrote: but how would i know which button to set the focus to?
Don't set focus to another button. Set it to a panel, or a label, or anything else. Panels and labels are good because they don't show as focused.
sharpiesharpie wrote: (did you even look at minesweeper to see what i meant?)
Wow! Way to get pissy.
|
|
|
|
|
In Minewseeper they might look and act like buttons, but there's clearly some additional functionality built in, not to mention the actual Minesweeper "grid" itself.
To emulate that, I think you're going to have to spend a bit of time developing your own custom control - although this will clearly take a bit more time, it will afford you much finer control (pun intended )
"It was the day before today.... I remember it like it was yesterday."
-Moleman
|
|
|
|
|
Well...i did make a custom control, a panel that has an array of rectangles in it into which i render images, but it was EXTREMELY flickery for some reason (even though i used a backbuffer) :/
|
|
|
|
|
In a situation with over one hundred controls, the obvious solution to flickering
(and lack of performance about which you will complain later on) is the lightweight
approach: forget Buttons, use a double-buffered Panel, draw everything yourself,
and handle the necessary mouse events yourself.
I guess that's how Microsoft did Minesweeper; they use 57 GDI objects, both in Beginners
and in Expert mode, according to TaskInfo.
|
|
|
|
|
i did draw everything myself, i drew images on a panel and overrided the mouse movements and added a basic collision detection...but it did flicker :/
|
|
|
|
|
Hi,
when a Panel does not contain any other Control, has double-buffering set up correctly,
and has all its drawing in its Paint handler, the only way I can think of to get flickering
is by having a bug in either your animation logic or your paint logic (unless you are
showing/hiding other stuff on top of it of course).
I have several apps that work this way, including a complex text editor; all work just
fine, not a single glitch to be seen.
As most often, my advice is to include code for logging/tracing so you can check
things happen when they should, and more importantly in this case, dont happen
when they should not.
|
|
|
|
|
I am debugging managed code (c#) that calls into unmanaged code (c) in a semi-production environment. I cannot install VS there. So, I am using Windbg and I have all the symbols for windows, managed and unmanaged code.
I set a breakpoint in a function in unmanaged code and want to see the full stack trace of where the call originated from in the Managed Code. But all I see is on the stack is calls from .net framework and nothing from my C# classes and functions.
Does anyone know how to get the full stack trace?
|
|
|
|
|
Hey every one ,, i am new programmer and i am working on a project (Electronic phone book ) and i need some help, the code is finished and my application works fine ,, what shall i do next ,how can i make it usable for every one ?!!!!
Rasta Man beta3 Zaman
|
|
|
|
|
sudany_zool wrote: the code is finished and my application works fine
Excellent - Well done!
sudany_zool wrote: how can i make it usable for every one ?!!!!
I thought you said it was "finished" and "works fine"? If it isn't usable then it isn't finished.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
sudany_zool wrote: how can i make it usable for every one ?
Write a quality article about interesting points in the project and place here on Code Project.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
First, upload it to a public server. Then find the email address for "everyone" and write them a nice notice. Oh but wait, you said "usable" for everyone... You'll have to use some globalization and get everything translated to about a thousand languages... And you'll also need to work out a way to get computers and connectivity to all the head hunter tribes in South America, nomads in Mongolia (maybe wireless is the best here), and all the dirt poor people suffering in Africa and Russia. And don't forget all the old ladies all over the world that barely have a phone. Then you have to worry about blind people and other handicaps that make using a computer difficult. And retards too. But if you mean animals and aliens too, I can't help you.
|
|
|
|
|
So now is the time to perform market analysis and write product specifications.
|
|
|
|
|
But how many phone book database apps are already out there? He needs to see where his stands out from the rest of them. Is it ease of use, etc?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|