|
Hi,
i have a collection of items in list box in the format:
1,1
1,2
1,3
1,4
2,1
2,2
..
now i want to store these values in database.
how to do this.
|
|
|
|
|
By calling your data layer. I can't tell you more, because you didn't provide any of the details. In fact, if you instead type the details into google, you're bound to find lots of info on calling a database from C#, whatever database that may be (Access/SQL Server/Oracle/etc )
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 )
|
|
|
|
|
Thanks for the reply..
I am using SqlServer. I am having a listbox with items in format:
1,1
1,2
..
2,1
2,2
..
Now I want to store them in a database table say testtable. I am a little confused and need a little help.
will u focus a ray of light to show me the path?
Regards
Sangram ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
sangramkp wrote: I am a little confused and need a little help.
You are not clear on what you need help with...Please give a bit more detail...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
I need help on the context:
How to store the items og a listBox into a table in SqlServer Database.
|
|
|
|
|
I have a file(s) that contains text and binary data, the data in the file looks as follows (this is partial data):
LO50,207,692,8
A195,344,0,1,4,4,N,"{SZ}"
A400,221,0,4,3,3,N,"{LOT}"GW388,450,48,160, ÿ<ð<0ð<ÃÌ< 0<ðð3ÀÃ<<0óÀÃÏÃÌ<ÀóÀðÌóÀÌ? ÿ<ð<0ð<ÃÌ<
A463,349,0,1,3,3,N,"{UOM}"
A616,358,0,1,3,3,N,"/59 ML"
A369,345,0,3,2,2,N,"FL."
Here is the problem, I need to have my program replace the tags (data enclosed in parenthesis) with some other information, then stored the new data in a second file. However, this must be done w/out affecting the binary data within the file, which does not need to be modified.
I do not know what encoding type is used for the binary part of the data, hence when writing to the destination file, the binary data is in the incorrect encoding type.
I know that I should probably be using "unicode" as opposed to "UTF" when reading/writing from/to the files, however, if I use "Unicode" how do I replace the tags by their value?
Thanks for any help on this,
Peter
The code that I'm using is something as the following:
//Read data from Source
FileStream fs = new FileStream(strSource, FileMode.OpenOrCreate,FileAccess.Read);
byte[] MyData= new byte[fs.Length];
fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
fs.Close();
string sData = Encoding.UTF8.GetString(MyData);
//Replace tag with correct value
sData = System.Text.RegularExpressions.Regex.Replace(sData,"{SZ}","21231");
//Write to Destination File
byte[] bData = Encoding.UTF8.GetBytes(sData);
FileStream fs1 = new FileStream(strDestination, FileMode.OpenOrCreate,FileAccess.Write);
BinaryWriter bw = new BinaryWriter(fs1);
bw.Write(bData);
bw.Close();
fs1.Close();
|
|
|
|
|
Hi,
some information is missing: in the parts that are non-binary it is easy enough
to find parentheses and do whatever is required; but in the binary parts there
might be bytes that have the exact same value as a regular parenthesis has.
So you must know when to switch from non-binary (interpreting) to binary (dont
touch me) mode, and back. As long as this is undefined, no one can come up with
an approach that works.
You showing the file as if it is line oriented does not help either, since
the carriage return, line feed, new line, or whatever control character you
consider could also occur in the binary data and make you switch incorrectly from
binary to non-binary mode.
So you need extra knowledge; could be things such as:
- in binary mode some byte values will never occur; when they do, they exit
binary mode and are considered a non-binary symbol.
- optionally: and when they are needed as a binary value, they will be
escaped (i.e. prefix an additional special byte value), or produced twice.
- in non-binary mode only a selected list of commands will switch to binary mode
etc.
|
|
|
|
|
Hi,
I have a button with an event attached (This made me smile because there's not much point with a buttin that hasn't  )
Anyhow - how can I get the value of the button.Tag to use within the code that is fired? It seems to be passed to the method but I can't see how to retrieve it?
TIA.
Glen Harvy
|
|
|
|
|
((System.Windows.Forms.Button) sender).Tag ?
|
|
|
|
|
That's it 
I was very close to working it out and was on the right track - it was changing the object sender to a button object that actually had me stumped.
Thanks heaps.
Glen Harvy
|
|
|
|
|
Glen Harvy wrote: changing the object sender
The thing to remember is that you're not changing it; it is a Button, but you need to tell the compiler that it is.
In some cases you may also need to test what type the sender is
if ( sender is System.Windows.Forms.Button ) { ... }
|
|
|
|
|
I would always use the 'as' keyword.
Button btn = sender as Button;
if (btn != null)
{
// process here
}
The other answer you got is correct, it *will* always be a button, and he mentioned 'as', which is also correct. But, for me, casting is a bad habit best avoided, even when I know I can get away with it.
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 )
|
|
|
|
|
Hi,
I have developed a web service and then I need to create a private UDDI registry for publishing that web service and allowing others to access UDDI for service consumption. Can some one help me that how can one create private UDDI registry (from start to end). I reed UDDI specification and lot of other stuff but I am not sure from where to start.
|
|
|
|
|
I have written a class that stores user options throughout the program. (Color preferences, startup windows, etc.) When the program initializes, a FileStream object is used to open then file then a binary formatter is used to deserialize the stream. The FileStream is then closed.
The problem is that when the program closes and the FileStream object trys to open the file to save the updated user options. A file exception is sometimes threw: "Cannot access file because it is being used by another proccess". Whats so annoying about the error is that it only happens SOMETIMES! A debugging nightmare! I assume that the object handle is not being released somewhere in memory. Can anybody give me any pointers on overcoming this problem?
may your code be error free
|
|
|
|
|
Have you tried using ApplicationSettings? Is there a reason why you need something different than what is already available?
only two letters away from being an asset
|
|
|
|
|
programmingAddict wrote: "Cannot access file because it is being used by another proccess"
Make sure you only have one instance of your application running at any one time. This is a shot in the dark, admittedly, but when I've run into similar problems, it's been when I'm running an application in debug mode, it appears to crash for whatever reason, and I start another instance of the application. Unbeknownst to me, the previous instance is still lurking somewhere, still running and has not released its resources.
Again, this may not have anything to do with your problem, but it's worth looking into. Use the Windows Task Manager to see what processes are running when you encounter this problem.
|
|
|
|
|
Telling from the symptomes, you are not closing the file stream properly. Sometimes the garbage collector is finalizing the object, which closes the file stream.
What does your code look like for reading the file?
---
single minded; short sighted; long gone;
|
|
|
|
|
I agree with Guffa.
Showing all the code involved with opening, reading, closing the options file
might give us a chance to give you some hint.
|
|
|
|
|
I would be happy to show you the code
This class is being used in a VB.NET project. But I plan to use the framework in C# apps.
'Here is the code for Initializing (reading) the options class:
If IO.File.Exists(_FileName) Then
Dim fs As FileStream
Try
fs = File.Open(_FileName, FileMode.Open)
Dim bf As BinaryFormatter = New BinaryFormatter()
userOp = CType(bf.Deserialize(fs, Nothing), ArrayList)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
Try
fs.Close()
fs.Dispose()
Catch
End Try
End If
GC.Collect()
'************************
'Here is the code for saving. (Where the error sometimes occurs)
Public Sub SaveToFile()
Dim fs As FileStream = Nothing
Try
'where the error occurs
fs = File.Open(_FileName, FileMode.Create)
Dim bf As BinaryFormatter = New BinaryFormatter()
bf.Serialize(fs, userOp)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
Try
fs.Close()
Catch
End Try
End Sub
Thanks for all the help!
may your code be error free
|
|
|
|
|
Hi,
I looked at your code (did not run it, I'm a C# guy) and have two suspicions
and several comments; here they are:
1.
it seldom is a good idea to have an empty catch block, since that really
hides any problems that might occur; you should fix that.
2.
rather than printing or showing Exception.Message I strongly advice everyone
to always use Exception.Totring since that gives a traceback plus additional
information depending on the kind of Exception, something Message cannot do
(e.g. the full file name if a file fails somehow, but also some inner exception
in case that occured)
3.
the reason your fs.Close() is in a try-catch with empty catch is, I guess,
that the file might not be open (because the open failed), hence now the
close will fail, and you dont want to see that. Fair enough, but then
you should test for it, as in:
if fs!=Nothing fs.Close() // I hope this is correct syntax for "fs is not nothing"
4.
I did not like GC.Collect() at the end of the reader. It seldom is wise to
attempt and help the GC, it normally is smart all by itself.
5.
suspicion 1:
I did not like ths fs.Dispose() that is present in the reader (but not in
the writer !?); I think it should not be there since fs.Close() takes care
of all resources, and MSDN says File.Dispose() is new since 2.0 but should
not be called ! Not sure how it would influence things tho.
6.
suspicion 2:
maybe, just maybe, your writing method is (sometimes) active while your reading
mehtod is active too, on a different thread. Make sure it is not. If both
do get called from different threads, try to devise a scheme in which the
reader gets aborted so the writer can succeed (a simple lock might not be
good enough since I guess you want to write upon app closure, and an ongoing
reader should not delay the closure)
You could inspect your code for threading stuff, and/or you could set a flag
while the reader is busy (and clear it when it's done), and test for that flag
inside the writer; doing so might confirm the occasional failure coincides with
concurrent reading/writing.
Hope this helps.
|
|
|
|
|
Hi
i am using a udp client for recieving..i used beginrecieve method of udp client
byte[] buff = new byte[1024];
soUdp.BeginReceive(new AsyncCallback(ReceiveCallback), buff);
but when i execute i am getting an error
An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full"} System.Exception {System.Net.Sockets.SocketException}
Why is that coming
Thanks in advance
Regards
DilipRam
|
|
|
|
|
Hi!
Seems as if you got more than 1K of data reaching the port you're listening to.
Try increasing buff to 4K and see if it's getting better.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
mav is right, your buffer is too small.
there is a maximum packet size for TCP/IP (IIRD it is around 1500 B)
and there is one for UDP, but I dont recall, might be the same number.
Your buffer should be large enough to contain such packet.
|
|
|
|
|
Hi Luc!
Just to clear things up: I think you refer to the MTU, not the maximum packet size for TCP/IP.
The MTU (maximum transfer unit) is the largest chunk of data that can be transmitted unfragmented. For Ethernet, this is 1500 bytes (this leaves 1472 bytes of data for UDP because of 20 bytes of IP header and 8 bytes of UDP header).
Once the amount of data to send is larger than this, it's split into single, smaller packets and transmitted separately. IP then reassembles the packets automatically so that you can have UDP packets with > 1472 bytes of data.
I found a quite extensive overview of TCP/IP here[^], just in case you're interested.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
Hi mav, yes that's what was simmering in my memory.
So there would be no maximum size at all ?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
