|
I have a .NET C# application that connects to databases and creates tables and such and works on MSSqlServer and an Oracle Server I've tested it on and now I would like to get it sorking on DB2 as well. I've noticed there aren't the same components for DB2 as there are for Oracle and Sql so I did some research and it seems the only good looking components come from IBM and/or cost $. I've tried using the code already in place with an OleDbConnection and Command and it works for creating the tables but I haven't gotten it to insert without throwing an error. I think the error is has to do with the parameter field of the command. I have tried it with @ before the column names as with SQL and : as with Oracle, but neither solution works. If anyone has any experience with similar problems I would appreciate any help.
|
|
|
|
|
IIRC OleDbCommand does not support named parameters. Use a ? character as a parameter placeholder, and add OleDbParameters to the Parameters collection in the order that they appear in the query text.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
I've tried this solution, and I think it makes sense for select statements, but for inserts the syntax doesn't look right and it doesn't work.
Ex:
Insert into table(col1, col2, col3), (?, ?, ?)
parameters:
@col1, value, type
@col2, value, type
@col3, value, type
I have tried this with @before the column names, :before them and nothing but the column names.
These statments have worked for me (with the column names instead of ?'s) in SQL and Oracle, so I have a hard time believing it can't be done in Db2.
|
|
|
|
|
It seems that if I use dataview in my app, and a change is made to the dataset, and I call Update(ds). It does not update the datasource.
Here is my code in the form_load section:
<br />
sqlDataAdapter1.Fill(dataSet11);<br />
<br />
SqlCommandBuilder cb = new SqlCommandBuilder(sqlDataAdapter1);<br />
<br />
dt = dataSet11.Tables[0];<br />
dataView1.Table = dt;<br />
<br />
cm = (CurrencyManager)this.BindingContext[dataView1];<br />
<br />
cm.CurrentChanged += new System.EventHandler(OnCurrentChanged);<br />
lblRecord.Text = "Record " + (cm.Position + 1) + " of " + cm.Count;<br />
and the code in my save record section:
<br />
if (dataSet11.HasChanges())<br />
{<br />
cm.EndCurrentEdit();<br />
<br />
sqlDataAdapter1.Update(dataSet11);<br />
}<br />
<br />
I'm not sure why it does not update. If I remove the dataview then it updates the datasource. Suggestions?
Thanks
Tom Wright
tawright915@yahoo.com
|
|
|
|
|
What do you mean "it does not update the datasource"? Have you inspected the DataSet with the debugger to see if the data has truly been changed and therefore needs to sync against the source? A common problem I see is that someone mishandles validation, transfer, etc where they think the input changed the data but in actuality it ignored or threw it out. If dataSet11 never changed, as far as the system is concerned there is nothing to update.
|
|
|
|
|
See the code that says..."if (dataSet11.HasChanges())" I would think that it would not drop into this "IF" statement if nothing had changed.
Tom Wright
tawright915@yahoo.com
|
|
|
|
|
Okay Time to eat crow.....I stepped thru the code and the dataset is not refelcting the changed made. If I just assume that there are changes it updates the datasource just fine. So now the question is why doesn't the dataset see the changes?
Tom
Tom Wright
tawright915@yahoo.com
|
|
|
|
|
i am trying to load user control and aspx pages from different namespace (project), in my namespace Template i have my user control and aspx files, and i am trying to load those files from namespace Test1.
Thanks
|
|
|
|
|
using Template;
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
i try that, but i could only read the class in that namespace but not user control, when i try to load the user control from 2nd namespace i the get error saying file not found. i have those two projects in different folder. when i try to load the user control it looks in my Test1 folder not in Template.
Thanks for you help
|
|
|
|
|
Hi.
I have a band object on my taskbar. it works fine, but the problem is that when I restart, it kinds of resets the startbar, I loose all the taskbars (including the quicklaunch), and I have to re-open them every time.
I imagine there is something that is forcing windows to reset the taskbar, but can't figure where to start looking.
tahnks
|
|
|
|
|
Is this a C# related question?
Ed
|
|
|
|
|
well, the program was done in c#. I'm asuming the bug is c# related. I'm not sure, well, because I don't know what's causing it. If someone thinks the problem lies elswere, please let me know.
|
|
|
|
|
I have a program which creates multiple threads. Each thread sends a WebService request.
What I am finding using sniffer is that even if I have 10 threads sending request, all requests are sent from one or two ports. I would like to have each thread use different port to send the WebService request.
Is there any ways to accomplish this?
Thank you for help.
|
|
|
|
|
Hi guys.Im trying to plot Bode graph in C#.Anybody knows where to find any algorithm for that?
|
|
|
|
|
Do you need to know how to calculate the points, or how to draw them ? If the former, google will help. If the latter, you could use SetPixel, or any of the line/shape drawing methods exposed by the Graphics object.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I want to display a simple Crystal Report (already, I think this is an oxymoron) in a Windows Form using a dataset (I'd prefer to do all the database work in my code, rather than letting CR do it).
All of my C# code is using Oracle.DataAccess.Client, but when I tried to create a new DataSet, VS said I had to use the Microsoft Oracle object. I did, created a DataSet with one table, EMPLOYEE. I then created my report that lists four items from the table -- no grouping, no counting, just a list.
Then, I created a Windows Form that gathers the required parameters for my query, and using those parameters, build the SQL. I use the SQL to fill the EMPLOYEE table in the DataSet created earlier. If I look, the table has 700+ rows after filling.
Then, I create a report object, set the datasource to the filled dataset, and set the Crystal Reports Viewer's ReportSource to the report. Seems straightforward, no errors. However, when I try to display the new form (that contains the crystalReportViewer), I am presented with a logon dialog box, asking for server, database, username, password. Even if I supply all of these items, it fails to logon. The form containing the viewer is shown, but there is no report.
I tried filling the dataset with the MS Oracle connection/command/dataadapter, but it made no difference. I also tried setting the username/password for each table in the report after the report object was created, but no luck either.
I read http://support.businessobjects.com/forums/message.asp?fid=251&sk=5&ps=25&pn=1&mid=152400#m152400, and a couple of other articles as well (http://www.codeproject.com/aspnet/crystal_report.asp#xx852522xx, http://aspalliance.com/265, and http://www.dotnetjunkies.com/Article/790775A0-C493-46D8-ABE0-40CA588D33D3.dcik).
Any thoughts on how to make this work, and/or a better place to ask?
DatasetReportPositiveEmployees ds = new DatasetReportPositiveEmployees();
string sSQL = "SELECT DISTINCT empID, empFName, empLName, empAcctNum from Employee " +
"LEFT INNER JOIN TestResult ON empID = testEmployeeID " +
"WHERE (testResult IN (SELECT resultID FROM Result WHERE resultTreatAsPositive=1))";
System.Data.OracleClient.OracleConnection localConn = new System.Data.OracleClient.OracleConnection(settings.ConnectionString);
localConn.Open();
System.Data.OracleClient.OracleCommand localCmd = new System.Data.OracleClient.OracleCommand();
localCmd.Connection = localConn;
localCmd.CommandText = sSQL;
localCmd.CommandType = CommandType.Text;
System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter();
adapter.SelectCommand = localCmd;
adapter.Fill(ds, "EMPLOYEE");
CrystalReportPositiveEmployees report = new CrystalReportPositiveEmployees();
Tried with/without this section
CrystalDecisions.Shared.TableLogOnInfo login = new CrystalDecisions.Shared.TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in report.Database.Tables)
{
login = tbl.LogOnInfo;
login.ConnectionInfo.ServerName = "myComputer";
login.ConnectionInfo.UserID = "myUser";
login.ConnectionInfo.Password = "myPass";
tbl.ApplyLogOnInfo(login);
}
report.SetDataSource(ds);
formReportViewer dlg = new formReportViewer();
dlg.crystalReportViewer1.ReportSource = report;
dlg.ShowDialog();
Thanks,
Glenn
|
|
|
|
|
Hi
I've been doing some diggin in the uxTheme.dll, and have managed to some stuff, but now I need to get mu buttons to look as the taskbar buttons, maybe the quicklaunch buttons. Yet I've looked all arround this file, and can't find them. I've used tools like this http://www.codeproject.com/managedcpp/ManagedUxTheme.asp to see the resources, but nothing.
can anyone help?
Thanks
|
|
|
|
|
I have wrote an article at this website on transparent menus and system-titlebar buttons. This article goes into detail on how to use UxTheme dll to paint titlebar buttons on a form using Visual Styles. This may be part of what you need to find what you are looking for.
Regards,
1tg46
Check out 3D Game Development with Dark Basic Professional [^]programming.
|
|
|
|
|
hi all i want to save images to database. I use this code
private int SaveToDB(string imgName, byte[] imgbin, string imgcontenttype)
{
//use the web.config to store the connection string
MySqlConnection connection = new MySqlConnection(ConfigurationSettings.AppSettings["DSN"]);
MySqlCommand command = new MySqlCommand( "INSERT INTO Image (img_name,img_data,img_contenttype) VALUES ( @img_name, @img_data,@img_contenttype )", connection );
MySqlParameter param0 = new MySqlParameter( "@img_name", MySqlDbType.VarChar,50 );
param0.Value = imgName;
command.Parameters.Add( param0 );
MySqlParameter param1 = new MySqlParameter( "@img_data", MySqlDbType.LongBlob );
param1.Value = imgbin;
command.Parameters.Add( param1 );
MySqlParameter param2 = new MySqlParameter( "@img_contenttype", MySqlDbType.VarChar,50 );
param2.Value = imgcontenttype;
command.Parameters.Add( param2 );
connection.Open();
int numRowsAffected = command.ExecuteNonQuery();
connection.Close();
return numRowsAffected;
}
I have no errors it tells me that the image is save but when i go to my database there is only new row with no data. Where i am wrong
P.S. I use MySql connector
-- modified at 13:09 Friday 17th March, 2006
|
|
|
|
|
i want to call a function dynamically which will differ according to my need. thing i need something like this:
<br />
private void FUNCTION_NAME(string ANY_STRING)<br />
{<br />
string ANOTHER_STRING="func"+ANY_STRING;<br />
ANOTHER_STRING.ANY_STRING();<br />
}<br />
i'll get ANY_STRING from some other source and that's the name which will refer the class name and part of function name too.
any help will be great 
-- modified at 11:50 Friday 17th March, 2006
|
|
|
|
|
It's possible to do that using reflection, but I doubt that you really need that.
Why don't you explain what you are trying to accomplish, instead of asking how to do it the way that you think it's done?
---
b { font-weight: normal; }
|
|
|
|
|
Guffa wrote: It's possible to do that using reflection, but I doubt that you really need that.
Why don't you explain what you are trying to accomplish, instead of asking how to do it the way that you think it's done?
well.. i'm trying to do is, i have one xml file which maintains which modules user has choosen to use. then my app. will load those module detail in menu(this far i've completed). when user clicks one menu that particular module's entry function will be called. now menu click event passing me the 'SENDER', from which i can extract the menu name which i've to use as identifier(nothing else i've got better than this after having many suggestion from people). after clicking the menu i'll run the entry function of that particular module. the important thing is, one user may have choosen completely different modules than other.
|
|
|
|
|
Make a base class or an interface for the modules, so that you can call the method without caring which of the modules it is. To get the right module you can do a lookup-table, like putting references to the modules in a hash-table.
---
b { font-weight: normal; }
|
|
|
|
|
thanks for your reply i've fixed the problem with the help of reflection
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
