|
//The problem is that bytes written to a FoxPro General Field are not being read back in correctly.
//This code will write 10 bytes to a general field and then read them back in. When the data is read back it will be incorrect.
//Part 1 of 2. Write a byte[] with values 0..9 to a foxpro 'General Field'
OleDbConnection oleDbConnection = new OleDbConnection(@"Provider=VFPOLEDB.1;Data Source=c:\blobTest\");
oleDbConnection.Open();
byte[] adtByte = new byte[10];
for(Int16 i = 0; i < 10; i++)//load the array with values 0,1,2,3,4,5,6,7,8,9
adtByte[i] = (byte)i;
OleDbCommand command = oleDbConnection.CreateCommand();
command.CommandText = "DELETE FROM image"; //clean up past attempts
command.ExecuteNonQuery();
command.CommandText = "INSERT INTO image (image_len, image_val) VALUES (?, ?)";
//foxpro table 'image' has two fields. image_len of type interger and image_val of type general.
OleDbParameter p1 = new OleDbParameter("?", OleDbType.Integer);
p1.Value = adtByte.Length;
command.Parameters.Add(p1);
OleDbParameter p2 = new OleDbParameter("?", OleDbType.Binary);
p2.Value = adtByte; //write the byte array as type binary - I think this is my problem????
command.Parameters.Add(p2);
command.ExecuteNonQuery();
command.Dispose();
//At this point we should have one row in the table and the values should be;
// image_len = 10
// image_value = 0123456789
//--------------------------------------------------------------
//Part 2 of 2. Read the row just created back into a pair of variables.
OleDbCommand oleDbCommand = new OleDbCommand("Select * from image", oleDbConnection);
OleDbDataReader oleDbReader = oleDbCommand.ExecuteReader();
while (oleDbReader.Read())
{
object objFieldImage = oleDbReader["image_val"];
byte[] inBytes = (byte[])objFieldImage;
object objFieldLen = oleDbReader["image_len"];
int iLen = Convert.ToInt32(objFieldLen);
//At this point image_len is 10 as expected.
//but inBytes has doubled in size and the value is all wrong.
}
thanks
|
|
|
|
|
Hi everyone.
I have to develop an MDI app and in the main window I want to put a sizable panel on the left (like Solution Explorer in VS).
So I created a SplitContainer (in which there is an other splitContainer) and set it vertical and "Dock = Left".
My problem is that while internal panels are sizable, the container itself isn't sizable (so it has the right border fixed) and it stands fixed in a portion of my main window.
How can i make the splitcontainer sizable? otherwise: is there a workaround (such as other controls instead of splitContainer)?
thanks!
|
|
|
|
|
Use two split container controls; drop one on the form and set its dock property to fill, then drop another one in the left hand panel of the first split container and set its dock property to fill also but set its orientation property to horizontal. The main container and the subordinate container will adjust to fill the window during use and in response to resizing the form. You can still adjust the size of the panels by moving the splitter bars up and down or left and right.
|
|
|
|
|
Hi, thanks for replying me.
I've already tried this way, but using 2 splitContainers and setting one with Dock = Fill, opening a child window of the MDI container this is not visible because it appears (hide) under the container.
the problem is that my application should have a left panel as described before, but the rest of the main window shoud not be tabbed (as VS), but free for child windows.
any other suggestions?
-- modified at 4:25 Monday 23rd October, 2006
|
|
|
|
|
Hello,
Oh, the issue is with the MDI parent. Here is a solution:
1. Get rid of the split containers altogether.
2. Add a panel to the MDI form
3. Dock the panel to the left side
4. Drop a splitter control (not the split container, just the splitter) to the right of the panel.
5. Put a panel inside the left docked panel.
6. Dock this new panel to the top.
7. Drop another control beneath the new panel.
8. Dock the splitter control to the top.
9. Drop another panel under the new splitter control.
10. Dock the new panel to the full extent.
This will give you two panels that will adjust in size on the left hand side, you can put whatever controls you want to inside those panels. This also leaves the MDI form clear to accept adding forms to it.
I tested this and it works fine for both the splitters and as an MDI parent. If you have any additional problems with this, I would be glad to send you a working copy of it; just email me an address and I will forward it along.
Scott Lysle
|
|
|
|
|
Could anyone explain to me how to format a long value as a date time value?.
This is because I am using Btrieve as a data base and the datetime fields are store as long types.
Any help is greatly apreciated.
Regards,
|
|
|
|
|
Oh, btrieve, I'm sorry. We, unfortunately, also use btrieve here. But our dates are stored as a string. Probably because it's just a date and not a datetime. Do you know if the long represents seconds or milliseconds? There's probably also a starting date like 1/1/1980 or 1/1/1900. If you had this information you could probably have a constant defined for the start date and just use the AddSeconds or AddMilliseconds methods to add the long value.
|
|
|
|
|
If the Ticks for Btrieve equals Ticks for the System.DateTime then you can use this:
DateTime theTime = new DateTime(_longValue);
Otherwise you'd have to find out what the startday is for Btrieve and if it counts in milliseconds or nanoseconds etc, then modify the returnvalue to equal the format for System.DateTime before using the above codesnippet.
-Larantz-
for those about to code, we salute you
|
|
|
|
|
I have arrise a problem in c#. that is i have two string variables like StartTime and Endtime. StartTime is 2100 ( i.e. 9 p.m) and 0600 ( i.e. 6 a.m). How i get the accual hour. i.e 9 hours.
xzv
|
|
|
|
|
Well, here's an example of what you could do. I guess if you get a negative number, you could always add 24 to it. Or you could use AddDays to change the day used by DateTime. By default, it will use the current date.
string strStart = "0600";
string strEnd = "2100";
DateTime dtStart = DateTime.ParseExact(strStart, "HHmm", null);
DateTime dtEnd = DateTime.ParseExact(strEnd, "HHmm", null);
Console.WriteLine(dtStart);
Console.WriteLine(dtEnd);
TimeSpan ts = dtEnd - dtStart;
Console.WriteLine(ts.Hours);
|
|
|
|
|
Hi everyone,
In a bit of a knot here chasing my tail. I have a webbrowser control embedded in a C# windows app which is calling a .CFM page to provide XML data as an output. I need a way to get this content into a text box in the C# application so as further processing can be carried out.
I am new to C# and would welcome any help that may be provided. The interface works and the webbrowser carries out the action required on the .cfm page it is just the farming of the form fiedl data that is required.
Thank you in advance.
Jarlath
|
|
|
|
|
hi everyone
does anyone have an idea about how i can develop a desktop application via C#. NET?? what differantiates it from web based application?
yasemin
|
|
|
|
|
Desktop apps use client-side Windows Forms technology (unless it's a console app). The target machine must have the .NET framework installed.
Web apps use ASP.NET to generate client-side HTML and javascript which renders in a browser. The target machine does not need to have the .NET framework installed.
|
|
|
|
|
thanks for your reply! i wonder how they differ from each other while coding in the c# .Net environment? let's say I'm developing a desktop app using c# in the ASP.NET environment, how should I begin? Are there any specific reguirements?
thanks a lot..
Yasemin
|
|
|
|
|
You don't build desktop apps using ASP.NET. ASP.NET is purely web apps.
|
|
|
|
|
Can anyone help?
I want to pass in some custom key values from my web config. I have been researching and can not get get it to work. ConfigurationSettings.GetConfig("OrgPaths") does not seem to work. So, do I need to set up a function that loops through my values in the web config?? Not sure.
Thank you
-------------------------------------------------------------
Web Config:
<configuration>
<configSections>
<sectionGroup name="DirectoryInfo">
<section name="Common" type="System.Configuration.NameValueFileSectionHandler, System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<section name="OrgPaths" type="System.Configuration.NameValueFileSectionHandler, System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
</sectionGroup>
</configSections>
<DirectoryInfo>
<Common>
<add key="Root" value="C:\temp" />
</Common>
<OrgPaths>
<add key="name1" value="\folder1" />
<add key="name2" value="\folder2\folder2.1" />
</OrgPaths>
</DirectoryInfo>
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
My Page:
public void Execute()
{
//I Create a Directory object using DirectoryInfo
string mydir = (@"C:\Temp\folder1");//I WANT THIS PASSED IN FROM THE
//WEBCONFIG?
DirectoryInfo dir = new DirectoryInfo(mydir);
//Pass the Directory for displaying the contents
getDirsFiles(dir);
}
|
|
|
|
|
Hi,
in order to add you own values into web.config file, you need to have a node
<appSettings>.
The structure will be following:
<code><configuration>
<system.web></system.web>
<appSettings></appSettings>
</configuration> </code>
Then, inside appSettings node add
<code> <add key="name1" value="\folder1" /></code>
In order to read the values:
<code>string value1 = ConfigurationSettings.AppSettings["name1"];</code>
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it! 
|
|
|
|
|
Can anyone give ideas on developing Toolbars in C# compatible with WebBrowsers. Please suggest me some links that explains this or has some tutorials on this, also that could give a sample demo of the code.
chandu
|
|
|
|
|
How do you mean ? Do you mean
1 - a toolbar that appears in a web page ? If so, it needs to be javascript
2 - a toolbar that runs in a browser ? If so, I'm not sure there's a unified framework for this, I suspect it would be per browser if it was supported at all, and how. I'm not sure if IE supports toolbars in C#, I'm sure other browsers do not.
http://www.codeproject.com/Purgatory/VB-IE-Toolbar.asp[^]
Seems like it can be done in .NET, it should be fairly simple to convert this article code to C#.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Could someone please recommend me some books on Dot Net with Author name
1. C#
2. ASP with C#
3. VB.Net
4. ADO.Net
5. XML
6. SQL/MySQL/Oracle
chandu
|
|
|
|
|
Do you mean ASP.NET with C# ? Which version ?
By SQL, do you mean SQL Server ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Yes we meant ASP.NET with C#, any latest version and SQL Server
chandu
|
|
|
|
|
clife537 wrote: C#
Inside C# Second Edition by Tom Archer
|
|
|
|
|
Anyone can tell me if it's possible to create a generic webservice proxy? I found an article that explained it, but I don't trust it because the code he posted is a big mess 
http://www.c-sharpcorner.com/Code/2004/Feb/GenericWebServiceProxy.asp
WM.
What about weapons of mass-construction?
|
|
|
|
|
Clickety[^]
Make sure you use the link[^] command below to make your link usable!!!!
The article quite clearly spells out the steps to take. If you don't like his code then just follow his steps and write your own code with the article as a guideline.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
