|
hi,
im working on a customer recording sw. i need to get the customers from the db according to the specifed keywords. firstly i wrote a stored procedure and i executed it and it is working but with datagrid it is not. then i wrote a less specific procedure into the c# code, if i didnt write any parameter it is working, i see the customer info in the datagridview but with a parameter the datagridview is empty. here is the code:
string connStr = "Data Source=ZEYNEP\\SQLEXPRESS;Initial Catalog=Esmira;Integrated Security=True";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = conn.CreateCommand();
SqlParameter param;
param = new SqlParameter("@ad", SqlDbType.NVarChar);
param.Value = "zeynep";
cmd.Parameters.Add(param);
cmd.CommandText = "SELECT * FROM musteri where ad=@ad";
DataSet dataset = new DataSet();
SqlDataAdapter dataadapter = new SqlDataAdapter(cmd);
dataadapter.Fill(dataset,"FOO");
dataGridView1.DataSource = dataset.Tables["FOO"];
here "cmd.CommandText = "SELECT * FROM musteri where ad=@ad";" if i write "ad=zeynep" it is ok but "ad=@ad" is not working.
does anyone have an idea about it???
|
|
|
|
|
Hi,
I have added a dynamic column to the datagridview.
In every row of this column there is a checkbox.
Not sure why I can not check these checkboxes as I click on them.
In case it makes any difference, I am leaving the autogeneratedcolumn as the default and so I am not setting it.
This briefly shows you what I am doing...
dtPricesSourcesBest.Columns.Add("AcceptPrice", typeof(Boolean));
dgvSecurityPricing.DataSource = null;
dgvSecurityPricing.DataSource = dtPricesSourcesBest;
Any ideas please?
|
|
|
|
|
arkiboys wrote: Any ideas please?
Look at the properties for the column. Make sure you have them all initialized properly.
|
|
|
|
|
Solved it.
The problem was that all the columns were set to readonly.
Thanks
|
|
|
|
|
I have an application that loads the default country from a country table based on the user's login credentials. However I have a combobox(as part of addres fields) that loads all countries from a countries table. I would like the combobox to default to the default country.
eg. if a user login in US I want US as the first item in the combobox.
Please help
Thanks
Tawa
|
|
|
|
|
You could do it like this:
private void YourFormForm_Load(object sender, EventArgs e)
{
int defaultCountryIndex = 7;
countryComobBox.SelectedIndex = defaultCountryIndex ;
}
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Is it possible to get the index from the combobox instead of hard coding the value. I am trying to avoid a situation where I have to provide values for all countries
|
|
|
|
|
TawaPower wrote: Is it possible to get the index from the combobox instead of hard coding the value. I am trying to avoid a situation where I have to provide values for all countries
Yeah, I was just giving a simple example of what you could do. Definately not a good idea to hard-code anything like that. What you could do is:
Once you have the country from the user, you iterate over each county in the combobox, and once you find the match for the user's county you have the index of it(you iterator value in your for loop), and set the selectedindex to that value.
-- modified at 11:22 Tuesday 13th November, 2007
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
am putting background image on ListView control. But items on list view are coming in white background. I set item background color to transparent but it still has white background. Any idea how to resolve it?
|
|
|
|
|
|
Hi does anyone know how i can get the names of all available classes wich are derived from a base class ?
|
|
|
|
|
Here's how to get all derived classes of a base class in one assembly:
List<Type> derived = new List<Type>();
Type baseClassType = typeof(BaseClass);
foreach(Type t in baseClassType.Assembly.GetTypes())
{
if(t.IsSubclassOf(baseClassType))
{
derived.Add(t);
}
}
|
|
|
|
|
With this code you can get all derived classes from the current assembly and its referenced assemblies... (this should be all assemblies in the project)
List<Type> derives = new List<Type>();
foreach( AssemblyName name in Assembly.GetExecutingAssembly().GetReferencedAssemblies() ) {
Assembly assembly = Assembly.Load( name );
foreach( Type class in assembly.GetTypes() ) {
if( class.IsSubclassOf( typeof( BaseClass ) ) ) {
derives.Add( class );
}
}
}
|
|
|
|
|
It will be all referenced assemblies, but not necessarily all assemblies in the project. Referenced assemblies are those that are actually listed in the References tree in Visual Studio and imported by namespace into the project. If you have any late bound assemblies (assemblies loaded by reflection using Assembly.Load()), they won't be in this list.
|
|
|
|
|
Hi...
I have been working with a image thing and all the stuff i have done is with the system.drawing.image part. now i would like to use some of the system.drawing.bitmap fetchers and would like to do it with out saving the Image to file and opening it as a Bitmap.
Running in VS2005 C#.
I have been trying all sorts of things i have read all around the Internet but just cant seem to get the right syntax.
all help would be greatly appreciated.
thanks
|
|
|
|
|
Bitmap bit = new Bitmap(image);
|
|
|
|
|
What!? You mean it's that simple? After all the hours spent researching this if I had only read the documentation, Bitmap.Bitmap(Image) Constructor 
only two letters away from being an asset
|
|
|
|
|
Mark Nischalke wrote: You mean it's that simple
True. System.Drawing.Imaging is a magic wand in fact. I was inspired to put down a few points on the same as an UtilityAPI here:
http://dotnetspider.com/kb/Article3446.aspx[^]
|
|
|
|
|
I have a 3rd party treeView Control which shows its own context Menu on right click. I want to override it with my Own.
I set control's CONTextMenu to my own contextMenu , what actually happening that it shows all items as Disabled. Also shows default context Menu.
Help me please!
|
|
|
|
|
Hi Adnan, it's been awhile.
Try inheriting from the control and overriding OnMouseDown. When that occurs, show your own context menu.
|
|
|
|
|
yeah, not much into soapbox thingie due to time and since I was not in MS technologies for long time so was not participating in other forums either 
i am away from net for long time, could be take ma as DUMMY and give some rough example what do you mean by Overriding OnMouseDown?
I am actually tracking MouseUP event. When user clicks right button, I am setting control.contextMenu to my Context Menu at the location of Mouse clck(e.x,e.y)
I am surprised why the heck it shows disable Items?
|
|
|
|
|
Hi all,
How would one do the following over in C# ?
short unsigned int crc16(char *pBuf, short int Len, short int InitialCrc)
{
short unsigned int crc=0, i=0;
crc = 0;
for (i = 0; i < Len; i++ )
{
crc = (crc >> 8) | (crc << 8);
crc = crc ^ *pBuf;
crc = crc ^ ((crc & 0xff) >> 4);
crc = crc ^ (crc << 12);
crc = crc ^ ((crc & 0xff) << 5);
pBuf++;
}
return(crc);
}
Many Thanks in advance
Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's ![Green Alien | [Alien]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/alien.gif)
Programm3r
My Blog: ^_^
|
|
|
|
|
I think this would be it:
ushort crc16(ref char pBuf, short Len, short InitialCrc)
{
int crc=0, i=0;
crc = 0;
for (i = 0; i < Len; i++ ) {
crc = (crc >> 8) | (crc << 8);
crc = crc ^ pBuf;
crc = crc ^ ((crc & 0xff) >> 4);
crc = crc ^ (crc << 12);
crc = crc ^ ((crc & 0xff) << 5);
pBuf++;
}
return((ushort)crc);
}
Everything stays the same, short unsigned int, becomes ushort. short int becoms short.
I changed crc to an int because whenever you did a bitwise operation, it came back as one, so you just change it back when you return it.
My current favourite word is: PIE!
Good ol' pie, it's been a while.
|
|
|
|
|
Does this article on CRC16 algorithm in C#[^] help?
For what it's worth, that code can almost be recompiled in C# since pointers and addressof operators are supported. If you wanted to port it with minimal impact, you might write something like this:
unsafe ushort crc16(char *pBuf, short int Len, short int initialCrc)
{
ushort crc = 0;
ushort i = 0;
for (i = 0; i < Len; i++ )
{
crc = (crc >> 8) | (crc << 8);
crc = crc ^ *pBuf;
crc = crc ^ ((crc & 0xff) >> 4);
crc = crc ^ (crc << 12);
crc = crc ^ ((crc & 0xff) << 5);
pBuf++;
}
return crc;
}That uses "unsafe" code (pointers, etc.) that can't be verified by the runtime. By the way, it appears initialCrc isn't used and could be removed.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
