|
Hi,
Can any one tell me, How to combine byte array with sql command in c#?
i have written code in c# like
bytes[] byteData
Update table1 SET col1="'" + byteData + "'" where colid=1
But this command convert in formate like
Update table1 SET col1='System.Bytes' where colid=1.
|
|
|
|
|
If you are trying to save an image to a database, you can take a look at this article here.
My signature "sucks" today
|
|
|
|
|
Thankx for help, but i alrady familiar with this example as you shown to me.
but i want to append the bytes array with sql command. Do you have any other example which can be help full?
|
|
|
|
|
Please use input parameter.
sql_string = "update table_name set field_name = @field_value where ...";
SqlParameter param = new SqlParameter();
param.Parameter = "@field_value";
param.DbType = DbType.Binary;
SqlCommand.Parameter.Add(param);
|
|
|
|
|
If you try to inline the array into a string C# compiler will create a ToString() call, that's why you're getting a 'System.Bytes' instead of array values. I think you should try to use SqlCommand parameters instead.
SqlCommand cmd = new SqlCommand("Update table1 SET col1=@ByteArray where colid=1", conn) ;
cmd.Parameters.Add("@ByteArray", <Correct Column Type>).Value = byteData;
cmd.ExecuteNonQuery() ;
Almost the same as the image example....
Greettings.
|
|
|
|
|
Hi all,
I have a word file in a format (means some text ans a table, etc...) and I want to create different files by changing different places on it. How can I do this in C#.
I've heard that dot file use as templates and work on. But I couldn't find any article. Can anyone of you guide me.
Thanks.
I appreciate your help all the time...
CodingLover
|
|
|
|
|
The nmost likely API set you want is the VSTO interface from Microsoft. It's a .NET Interop Assembly to the MS Office COM API's.
It is an enormous set of API's, a COM wrapper with all the COM pitfalls plus the myriad versions of MS Office, so test thoroughly. There is a ton of information on using VSTO you can find on the web. Here is a starting point:
http://msdn.microsoft.com/en-us/vsto/dd164295.aspx[^]
-- Christo
|
|
|
|
|
Thanks a lot.
I'll go through it and let you know if I'm stuck on anything.
I appreciate your help all the time...
CodingLover
|
|
|
|
|
Hey, no problem. VSTO is pretty huge -- there are many API's for each of the Microsoft Office applications, particularly Word and Excel. As a tip, I've found one is better off using Google or some other web search engine to ask questions about VSTO API's and how to do things. Programmers frequently post questions about VSTO workings, and the programmers' forums on the web (including CodeProject!) are often a much better resource than the Microsoft documentation. VSTO is an interop assembly for the long term established COM interface to Office, it has been under development for a long, long, time, and it is enormous.
|
|
|
|
|
I have a class like this:
<pre>
public class EmpCtg
{
public int ID { get; set; }
public string Name { get; set; }
public EmpCtg Parent { get; set; }
}
</pre>
Collection of this class:
<pre>
List<EmpCtg> ListEmpCtg = //....get list<empctg>
</empctg></pre>
I want binding ListEmpCtg to TreeView, and show look like this:
<pre>
EmpolyeeCategory
|
---------Ctg1
|
|
---------Ctg2
| |
| |
| --------Ctg3
| |
| |
| --------Ctg4
| |
| |
| --------Ctg5
.
.
.
</pre>
I know that I can write in the code by hand, but I would like to know whether to use DataTemplate?
What should I do?
Thanks!
|
|
|
|
|
I use TreeView extensively. It is a rather "unique" control with a lot of pitfalls. I strongly suggest you expend the effort and write custom code around your TreeView controls.
Otherwise, if you really want to just use binding, refer to this article on CodeProject:
Data Binding TreeView in C#[^]
|
|
|
|
|
i want delete image file.
very well insert image file to listbox.
but, do not delete image file ,
please, take me a error,,
attached the source project files,
reply send to me(sonic747@esolgorup.co.kr)
---env
c#, wpf, .net3.5
/....
source file download
//imagefile insert to listbox///
private void button1_Click(object sender, RoutedEventArgs e)
{
savepath = System.Environment.CurrentDirectory.ToString();
foreach (string f in Directory.GetFiles(savepath + "/image", "*.jpg"))
{
BitmapImage my;
my= new BitmapImage();
my.BeginInit();
my.CacheOption = BitmapCacheOption.OnLoad;
my.UriSource = new Uri(f, UriKind.RelativeOrAbsolute);
my.EndInit();
listBox1.Items.Add(my);
}
}
/////////delete image file (error) ///
private void button2_Click(object sender, RoutedEventArgs e)
{
string makestr1, item1;
item1 = listBox1.Items[0].ToString();
makestr1 = item1.Substring(8, item1.Length - 8);
listBox1.Items.Remove(listBox1.Items[0]);
if (System.IO.File.Exists(makestr1))
{
System.IO.File.Delete(makestr1); //<--error point
}
else
MessageBox.Show("Nothingfile");
}
|
|
|
|
|
sonic747 wrote: listBox1.Items.Add(my);
start here, you are adding BitmapImage object to your ListBox
sonic747 wrote: item1 = listBox1.Items[0].ToString();
what do you get when you do ToString() on that object? huh? Got Clue?
|
|
|
|
|
Again?
You can't delete an image that is in use.
And it remains in use until you:
- remove all references to it (as in ListBox.Items)
- AND call Dispose() on that image
And please show code snippets inside PRE tags.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
So, what is the error message and what is the value of makestr1 when it gives the error?
It would be easier to read if you use <pre> tags to format
sonic747 wrote: reply send to me(xxxx@yyyyy.zzzz)
Good luck with that!
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
modified on Tuesday, May 18, 2010 10:26 PM
|
|
|
|
|
Yikes, publishing someone's e-mail address is very naughty.
He could still have removed it in his message, but he can't change yours though. It is *not* fair.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
Yes, Luc, you're right. Thanks for pointing that out -- I've modified my message.
I honestly wasn't paying attention.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Now you're again being the fair person we are used to.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
Well, I try ... and sometimes do a fair job of it.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
My Project:
http://rapidshare.com/files/388966495/bandwidth_meter.rar.html[^]
This program is working but my LCD doesnt show anything. By the way LCD is working a normal condition. I am waiting for your advice. Thank you...
public partial class MainForm : Form
{
private const double timerUpdate = 1000;
private NetworkInterface[] nicArr;
private System.Windows.Forms.Timer timer;
public MainForm()
{
InitializeComponent();
InitializeNetworkInterface();
InitializeTimer();
}
public int data = 888;
public int control = 890;
private void InitializeNetworkInterface()
{
nicArr = NetworkInterface.GetAllNetworkInterfaces();
for (int i = 0; i < nicArr.Length; i++)
cmbInterface.Items.Add(nicArr[i].Name);
cmbInterface.SelectedIndex = 0;
}
private void InitializeTimer()
{
timer = new System.Windows.Forms.Timer();
timer.Interval = (int)timerUpdate;
timer.Tick += new EventHandler(timer_Tick);
timer.Start();
}
private void UpdateNetworkInterface()
{
string title, duration;
NetworkInterface nic = nicArr[cmbInterface.SelectedIndex];
IPv4InterfaceStatistics interfaceStats = nic.GetIPv4Statistics();
int bytesSentSpeed = (int)(interfaceStats.BytesSent - double.Parse(lblBytesSent.Text)) / 1024;
int bytesReceivedSpeed = (int)(interfaceStats.BytesReceived - double.Parse(lblBytesReceived.Text)) / 1024;
lblSpeed.Text = nic.Speed.ToString();
lblInterfaceType.Text = nic.NetworkInterfaceType.ToString();
lblSpeed.Text = nic.Speed.ToString();
lblBytesReceived.Text = interfaceStats.BytesReceived.ToString();
lblBytesSent.Text = interfaceStats.BytesSent.ToString();
lblUpload.Text = bytesSentSpeed.ToString() + " KB/s";
lblDownload.Text = bytesReceivedSpeed.ToString() + " KB/s";
title = lblDownload.Text;
duration = lblUpload.Text;
writetoLCD(title, duration);
}
void timer_Tick(object sender, EventArgs e)
{
UpdateNetworkInterface();
}
private void writetoLCD(string title, string duration)
{
PortAccess.Output(data, 1);
PortAccess.Output(control, 8); Thread.Sleep(1);
PortAccess.Output(control, 9); Thread.Sleep(1);
int a;
char[] line1_ch_buffer, line2_ch_buffer;
string line1_st_buffer, line2_st_buffer;
line1_st_buffer = title;
line1_ch_buffer = line1_st_buffer.ToCharArray();
line2_st_buffer = duration;
line2_ch_buffer = line2_st_buffer.ToCharArray();
HangiSatir(1, 1);
for (a = 0; a < line1_ch_buffer.Length; a++)
{
PortAccess.Output(control, 4); Thread.Sleep(1);
PortAccess.Output(data, (int)line1_ch_buffer[a]);
PortAccess.Output(control, 5); Thread.Sleep(1);
}
HangiSatir(2, line1_ch_buffer.Length);
for (a = 0; a < line2_ch_buffer.Length; a++)
{
PortAccess.Output(control, 5); Thread.Sleep(1);
PortAccess.Output(control, 4); Thread.Sleep(1);
PortAccess.Output(data, (int)line2_ch_buffer[a]);
PortAccess.Output(control, 5); Thread.Sleep(1);
}
}
private void HangiSatir(int line, int column)
{
PortAccess.Output(control, 8);
if (line == 1)
PortAccess.Output(data, 127 + column);
if (line == 2)
{
int sayi = 39 - column;
for (int i = 0; i <= sayi; i++)
{
PortAccess.Output(control, 4); Thread.Sleep(1);
PortAccess.Output(data, 16);
PortAccess.Output(control, 5); Thread.Sleep(1);
}
}
}
public class PortAccess
{
[DllImport("inpout32.dll", EntryPoint = "Out32")]
public static extern void Output(int adress, int value);
[DllImport("inpout32.dll", EntryPoint = "Inp32")]
public static extern int Input(int adress);
Please help me. Thank you for your answers
modified on Tuesday, May 18, 2010 9:48 PM
|
|
|
|
|
THeKiNG20 wrote: I am waiting for your advice
My advice is ask properly to get an answer.
|
|
|
|
|
my english is not very good. I am sorry
|
|
|
|
|
Probably nobody is going to download your code and investigate it; if you want any help here, it is your task to explain properly and show the relevant code snippet (inside PRE tags!).
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
OK. I see you. Thank you
|
|
|
|
|
|