|
Hello everybody!
I created a database in MySQL, and successfully made connection from the C# application to MySQL. When I try to insert new record and update the database, it gave me an error message which is said
"ERROR [07006] Restricted data type attribute violation(SQL_C_NUMERIC)".
My code is
DataRow new_machine = main_form.db.Ds.Tables["machine"].NewRow();
new_machine["StockNo"] = stockno_txt.Text;
// Add a new machine record into the dataset
main_form.db.Ds.Tables["machine"].Rows.Add(new_machine);
// write it back to mysql database;
main_form.db.UpdateDatabase("machine");
The UpdateDatabase function is
public bool UpdateDatabase(string table)
{
System.Data.Odbc.OdbcDataAdapter adapter =
new OdbcDataAdapter("select * from "+table, _connection);
new OdbcCommandBuilder(adapter);
try
{
adapter.Update(_ds, table);
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
_ds.Tables[table].AcceptChanges();
return true;
}
In the database, the field StockNo is declared as varchar(8) primary key.
Could somebody solve this problem for me please???
Thanks in advance!!!
Asura
|
|
|
|
|
Does anyone have an idea of how to make a tab page's title directly editable? I have asked on other message boards and no answers to date. Thanks in advance!
|
|
|
|
|
You have to extend the class... but I don't know how to do it precisely.
CodeProject's Server wrote:
HTTP/1.1 500 Server Error
|
|
|
|
|
Hi,
I want to write a C# windows application that reads some text from the interface of another (separate) application, and am looking for a few ideas as to where to start.
Specifically, I would appreciate some help with the following questions:
1) What is the best way to determine how the information I want is held in the other application?
2) What will probably be the best way to access the information I want.
For question 1, I suspect that the information I want it is in the equivalent of a label control, but am not sure. It could be a graphic object of some sort...
For question 2, I am guessing that I will need to use some Win 32 APIs to get a handle to the window I want, and then perhaps start capturing messages on it? (That of course assumes that the text I want to capture is neatly displayed in an object that can be accessed via its handle, however that might not be the case!)
Thanks in advance.
|
|
|
|
|
Hellow Every one,
Please tell me how to create mutltilines Crystal Report in Visual Studio .Net 2003 Crystal Report Desinger Panel.
Like this:
Column 1 Column2
________________________________
Dummy ID1 Dummy Data Line 1
Line2 of Column2
Dummy ID2 Dummy Data Line 1
Line2 of Column2
___________________________________
Please help Me. If you not getting my point, inform me.
|Muhamad Waqas Butt|
waqasb4all@yahoo.com
www.sktech.freewebspace.com
|
|
|
|
|
I want to get a list of installed applictions and display it in a form - the name and its icon. I have found out how to get the path. I know this much that all the application names can be found inside the registy HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\. How do i get the application icon because even though i have the application name. I dont have the path. There surely must be some way cause i can the icons in the Add Remove applet in the Control Panel? I cant seem to find anything abou this on the Internet!!!
|
|
|
|
|
It looks like there's a DisplayIcon value in some of the registry keys for the installed apps. You could use that. Otherwise, I believe the way that Windows does it is by looking for the EXE in the InstallLocation value, which all of those keys provide, and then grabbing the icon from it.
Picture a huge catholic cathedral. In it there's many people, including a gregorian monk choir. You know, those who sing beautifully. Then they start singing, in latin, as they always do: "Ad hominem..."
-Jörgen Sigvardsson
|
|
|
|
|
Dont' know if this is the right forum but here goes !
I have an ActiveX control which I wrote (in VC6) and I am trying to use it in a C# Web App.
I have run it through AxImp.exe and now got a couple of dlls and a cs file.
Does any body know how I can now add the control to my C# page ?
Hope some body can help.
Cheers,
Users.
Can't live with 'em, can't kill em!
|
|
|
|
|
Are you using Visual Studio? If so, just add the ActiveX dll to the Visual Studio toolbox, then drop it on your form as if it were a standard .NET control, VS will do the AxImp for you.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Cops & Robbers
Judah Himango
|
|
|
|
|
I am using VS 2003, when I add the ActiveX Control and build the project, it does not create anything and I can't access the control as it does not have a variable associated with it, any ideas ?
Cheers
Users.
Can't live with 'em, can't kill em!
|
|
|
|
|
Are you adding it to the VS toolbox and drop it on your form? Or did you just add it to the project references?
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Cops & Robbers
Judah Himango
|
|
|
|
|
Hi,
I added the activeX to the Toolbox and then dragged it onto the form but when I look as it's properties, it only shows the HTML properties, I can't see a way to give a variable which I can access from functions in the cs file.
Any ideas ?
Cheers
Users.
Can't live with 'em, can't kill em!
|
|
|
|
|
If you dropped it on the form, it created a variable for you. VS usually assigns the name ax[componentName][number], so if you dropped the WebBrowser control, it would generate a variable named axWebBrowser1.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Cops & Robbers
Judah Himango
|
|
|
|
|
I tried adding the WebBrowser to the form, and nothing was created.
It does as you say if you drop the control onto a windows form but not a web form, any ideas ?
Users.
Can't live with 'em, can't kill em!
|
|
|
|
|
Lol...yeah, the WebBrowser controls is a Windows forms control, not a web forms control. That is where you're going wrong.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Cops & Robbers
Judah Himango
|
|
|
|
|
I think we are talking via crossed wires.
My original problem is that when I add any ActiveX control to a Web form, I dont know how to access it from the c# code as it does not create a variable.
I used the web control as an example to prove to myself that if you add a control to a windows form, a variable is created.
I do not intend to use a web control on a web form, that would be silly I agree.
Is it possible to do what I want or can I only add special web form controls to web forms ?
Hope you can help,
Cheers
Users.
Can't live with 'em, can't kill em!
|
|
|
|
|
I don't think you can add an ActiveX control to a web form. My understanding is there is something extra that needs to be done. I don't know though, you should ask that question in the ASP.NET forums.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Cops & Robbers
Judah Himango
|
|
|
|
|
Hi All,
I'm new to C#, my first application should read a binary file in which each element is defined as a 'struct' in a C-style include file. This file is shared with C applications so I cannot modify it to fit the C# syntax.
What's the best way doing this?
TIA,
Cabbi
|
|
|
|
|
You can redefine the struct in C# and use it from there as if it were a C struct. For instance, here is a a C# equivalent to widely used POINT C struct:
[StructLayout( LayoutKind.Sequential )]
public struct POINT {
public int X;
public int Y;
}
I can now pass this POINT to a C function that takes the POINT struct as defined in C. Note that the LayoutKind.Sequential is necessary for interoping with C code; this attribute tells the CLR to layout the struct in memory exactly as shown in code, which is necessary for C to work with.
I recommend using this site[^] for correct interop definitions and practices.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Cops & Robbers
Judah Himango
|
|
|
|
|
Hi, codeprojecter
I use "checkboxlist" to show some information of the registeruser
-------------------------------------------------
for example:
I have 4 items in the checkboxlist,when first run there are 4 items in the page ,and when I check 2 and then click the submit button, the page will refresh and just show me the checked items,don't show unchecked items.
-------------------------------------------------
I don't know how to do this thing,
my code is below:
private void submit_Click(object sender, System.EventArgs e)
{
for (int i=0; i<(this.chkboxGroup.Items.Count-1);i++)
{
if (this.chkboxGroup.Items[i].Selected)
{
//I don't know the code here,please help me!!
}
}
}
-------------------------------------------------------------------------
Thank you very much!
shanzy
|
|
|
|
|
Try this:
private void submit_Click(object sender, System.EventArgs e)
{
for (int i = 0; i < this.chkboxGroup.Items.Count; i++)
{
if (this.chkboxGroup.Items[i].Selected)
{
this.chkboxGroup.Items[i].Remove(this.chkboxGroup.Items[i]);
i--;
}
}
}
www.troschuetz.de
|
|
|
|
|
Thank you for your replay!
But, the "chkboxGroup.Items[i]" doesn't have the method "Remove"
shanzy
|
|
|
|
|
Ups, my fault 
this.chkboxGroup.Items.Remove(this.chkboxGroup.Items[i]);
www.troschuetz.de
|
|
|
|
|
Thank you for your replay!
|
|
|
|
|
I need a robust way to insert some hidden information of 2 bytes in a text file which should not be visible in a normal text editor,I can't use Alternative data streams as when we unzip them the info gets lost,Plz help!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
