|
I use datasets to connect to access 2003 mdb file, created an insert query to write to ole object field in one of my tables,when i want to write data which is a text file bytes, with size of more than 1 mb, only the first "1 kb" of the data is written to the field, when i get back the data from access file, i get truncated file with size of 1 kb. Why i cant write more than 1 kb to a ole object field??? i read from the help of access 2003 that the field holds up to 1gigabyte of data but i can write only 1 kb, i checked out the variables, traced parameters but i couldnt find my mistake mistake, i think there is a problem with Access.
Thank you for your concern.
---
TSTfile = File.ReadAllBytes(@OpenTSTFileDialog.FileName);
TSTfileBytes = new Byte[TSTfile.Length];
TSTfile.Read(TSTfileBytes, 0, TSTfileBytes.Length);
TSTfile.Close();
----
later i use
---
myGrupTablosuTableAdapter.grupTablosuInsertQuery(GroupNo,TSTfileBytes);
|
|
|
|
|
Hello,
I am having split container in Form application.
I am displaying another form in one pane of splitter. It is movable but it starts hiding if i want to move it across the pane of splitter.
I want to move it across the pane throughout the window.
How it is possible.
Thanks.
-- modified at 2:57 Friday 24th August, 2007
|
|
|
|
|
gajesh wrote: I am displaying another form in one pane of splitter
Is this possible?
I'm using .Net1.1 VS2003, and it's not possible to add a form to an panel container!
All the best,
Martin
|
|
|
|
|
Yes.
We can set MdiParent of form to current window and then Show().
|
|
|
|
|
Ok,
But where are you adding the SubForm.
Which one is the MDIContainer, panel (which doesn't work I guess) or mainform?
-- modified at 3:44 Friday 24th August, 2007
All the best,
Martin
|
|
|
|
|
I am sorry.
Bfore Show() we have to add form to panel.
Form1.MdiParent = this;
mButtonEmulator.Location = new(point...)
splitContainer1.Panel2.Controls.Add(Form1);
Form1.Show();
This should work.
Thanks
|
|
|
|
|
Ok,
What if you add the form to the splitcontainer.Controls instead of one of the panels?
Bring it to Front, will maybe do what you need.
All the best,
Martin
|
|
|
|
|
Have you tried Form.TopMost ?
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
All the best,
Martin
|
|
|
|
|
Setting Form.TopLevel (not TopMost) false would allow you to add it to a
Controls collection.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Ahhhh,
Thanks for the Info! (never needed it bevor)
All the best,
Martin
|
|
|
|
|
Sure it is! The Form class derives from Control, so it's possible to treat a form just like any other contorl on one. All you have to do is create a new instance of the form, then set it's TopLevel property to false.
Form2 myNewForm = new Form2();
myNewForm.TopLevel = false;
this.Controls.Add(myNewForm);
myNewForm.Show();
|
|
|
|
|
Hi,
How to check that USB Flash Memory is connected or not with Drive letter?
thank you in advance
|
|
|
|
|
Hello,
Look at the answere I gave here![^] or here[^]
All the best,
Martin
|
|
|
|
|
Hi all
I am writing a program in which I want to read all the column names of a table in db of sql server and against every column I want to check wether it is NULLABLE or not. I am using
MyDataset.Tables[0].Columns[j].AllowDBNull
property of dataset but it shows always a true. I mean all the columns are shown as NULLABLE.
Could someone help me?
-- modified at 1:44 Friday 24th August, 2007
Mujtaba
"If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
|
|
|
|
|
plz give to me new projects topics
nitin b saste
|
|
|
|
|
Why do people keep asking this ? How about a program that accepts speech input, and then takes requirements delivered in this manner, and spits out a working exe ?
Or was there some limit in scope of your request that you expected us to work out by voodoo or something ?
Think about what your skillset is, think about what you'd like to learn, and then come up with a project that fits. Or at least, give us something to go with.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
Control and monitoring system for a nuclear power plant
Flight control system for the Airbus A380
Satellite navigation system to compete with the U.S. GPS
Launch control system for the Space Shuttle
|
|
|
|
|
Port .net to OpenVMS... please? 
-- modified at 14:43 Friday 24th August, 2007
Oh, and IIS too.
|
|
|
|
|
Hi,
I have an SQL query
tring sql = "UPDATE employees SET Fullname = '" + textBox1.Text + "' Where EmployeeID = '" + employeeID + "'";
I am using Where EmployeeID = '" + employeeID + "'"; because I want the query to be based on what the user has selected in a seperato classes combobox. The above how, ever doesn't work. Nothing changes. Do you know if the query is somewhat incorrect?
Thank you 
|
|
|
|
|
First of all, your code is still insecure, I guess this is for a class then ?
Second, you should try to give your controls real names. What is textbox1 ? When you have 6 on the screen, how will you remember which one is textbox5 ?
Third, your id is a number as I recall, but you have it in quotes, which means you're passing it as a string. Why is it a string in the database ?
The best thing to do here, is to step through the debugger, and see what the SQL string is, then pass it through to your database manually and see how it responds. It will give you meaningful information if it can't process the SQL.
And, depending on what the rest of your code looks like, it's possible the SQL is not being called, but if it is, it should return to you the number of rows affected, you could check that and see if it's > 0.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
but I am concatenating C# with SQL so don't you use quotes so it knows what is C# code? EG. The SQL turns red and the C# remains black. If I don't use quotes it will be wrong. I have also used this for my insert statements which work perfectly. The ID is an int in the database. It has seemed that for my insert statements it only works when I use.Tostring which to me is strange.
Also the only reason I had to change everything to public was because I am using inheritance. I ahve decided against that now.
I am not on contracted work, I am a permanent worker who has been given the opportunity to learn C#.
|
|
|
|
|
falles01 wrote: Also the only reason I had to change everything to public was because I am using inheritance. I ahve decided against that now.
The two do not follow. Protected gives you things that are private, but visible in derived classes.
falles01 wrote: but I am concatenating C# with SQL so don't you use quotes so it knows what is C# code?
What I mean is, your final SQL will look like this:
where id ='323'
or something
The id should not be in quotes if it's a number, unless Access is different in that regard. I'm talking about the ' in your generated string, not the quotes around the static strings.
falles01 wrote: It has seemed that for my insert statements it only works when I use.Tostring which to me is strange.
You may have to use ToString to get a string when yuo're building the SQL, which is a string. Howver, if you concatenate a string and an int, the int should go tostring by itself.,
falles01 wrote: I am not on contracted work, I am a permanent worker who has been given the opportunity to learn C#.
I just read back on your older thread, so I get your situation now. Did you try getting the SQL out of the debugger and pasting it into Access ? Also, what does your data access code look like ?
Ideally, you'd have all your data access via stored procs, and seperated into a dll. For now, I'd recommend you create a class whose sole job is to manage any database calls, and put any data access in there. Make it static, and just call the methods to run the SQL, so in this instance, the method would take two params ( the name and the id ). you can then add methods to 'sanitise' your input against SQL injection attacks, but even if yuo don't, it makes sense to centralise your SQL, not least so you can reuse it if need be.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
falles01 wrote: but I am concatenating C# with SQL so don't you use quotes so it knows what is C# code?
No. The SQL String you built using this code is:
UPDATE employees SET Fullname = 'someTextBoxValue' Where EmployeeID = 'someIdValue'
Because of the single quotes around the IDValue, you've told SQL to treat it as a string. So, is this value a string in your table or are you telling SQL to find a string value in a numeric column?
You really need to translate this code into an SQL parameterized query. That way, you don't make the mistake of quoting numbers or haveing a user enter a quote in a textbox, then having that screw up your concatentated string, thereby making an invalid SQL statement.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
