|
Yeah, I'm not into having socket puppets.
|
|
|
|
|
OriginalGriff wrote: V is absolutely right
I should print this in large curly letters and frame it
|
|
|
|
|
I recommend that you do not use paypal.
I was scammed by someone buying a key to my software then telling paypal the transaction was a fraud - they got to keep the key and were refunded.
So due to this terrible service from paypal I now broadcast this negative experience far and wide
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
Hey Guys,
I need your assistance, am struck up with an issue.
Issue: I have retrived a SQL data into a DataGridView, It has the below column header names like (Package_ID, Package_Name etc.)
I used the below code to copy the data in DataGridview to Excel.
Copying is fine, but am not getting the colum headers which are visible in my DatagridView. (Package_ID, Package_Name etc.)
Other than the Column headers all other data are getting copied.
the code i used:
private void copyAlltoClipboard()
{
dataGridView1.SelectAll();
DataObject dataObj = dataGridView1.GetClipboardContent();
if (dataObj != null)
Clipboard.SetDataObject(dataObj);
}
private void btn_Export_Click(object sender, EventArgs e)
{
copyAlltoClipboard();
Microsoft.Office.Interop.Excel.Application xlexcel;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlexcel = new Excel.Application();
xlexcel.Visible = true;
xlWorkBook = xlexcel.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
Excel.Range CR = (Excel.Range)xlWorkSheet.Cells[1, 1];
CR.Select();
xlWorkSheet.PasteSpecial(CR, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, true);
}
i want my column headers also need to be copied to Excel.
Please assist.
|
|
|
|
|
Mohan Subramani wrote: i want my column headers also need to be copied to Excel. The headers aren't "data"; if you copy the data to Excel, then that's what get's copied. You could loop through the columns before exporting and write those to the first row.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
|
hello,i wanna create a software with c# that i will use datagridview,and will use LINQ,how can i fetch data from database in to datagridview that when scroll into down data one by one fetch from database? please help me!!!
|
|
|
|
|
If you fetch a record when the user scrolls down, scrolling will become painfully slow. It'd be executing a query for each row that becomes visible.
If you want something faster than data-binding look into Virtual Mode[^].
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
hello,i wanna create a software that i will use datagridview,and will use LINQ,how can i fetch data from database in to datagridview that when scroll into down data one by one fetch from database? please help me!!!
|
|
|
|
|
How to create Help Provider?
|
|
|
|
|
Google, amazing tool, if you use it...
If I feed it your whole question: Google "How to create Help Provider"[^] it gives me over 700 million hits...
Number two on this list is MSDN: Introduction to the Windows Forms HelpProvider Component[^]
In future, please try to do at least basic research yourself, and not waste your time or ours.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
What is the purpose of a .edmx file? It is a XML formatted file in Visual Studio. It has database table information. But how is it used in a Visual Studio C# asp.net web app?
Online search engines say that "an .edmx file is an XML file that defines a conceptual model, a storage model, and the mapping between these models. An .edmx file also contains information that is used by the ADO.NET Entity Data Model Designer (Entity Designer) to render a model graphically."
But how is it used, and how is it made?
|
|
|
|
|
|
It's a file that is used by the Entity Framework. That is an ORM (Object Relational Mapping) Framework. To access a database without the need to manually write SQL queries and the like. They exist to make the life of a development (hopefully) easier.
Those files are generated from the designer integrated in Visual Studio but you can also manually edit them if you like. There will/should also be some autogenerated .Net Code which then provide access to the data model defined in those edmx files.
|
|
|
|
|
Hi,
I am trying to communicate with a HID device, using feature reports.
When using normal input and output reports, I use the FileStream to read and write reports. This works great, even with async communication.
My problem is that I am using feature reports instead. This means using the HidD_SetFeature and HidD_GetFeature from the Windows hid.dll file.
This also works, but the HidD_GetFeature cannot be used async. When called it does not block until there is a report, so I end up having to poll when I expect there to be data.
So I am looking for a way to do feature reports async, or have the HidD_GetFeature method to block until there actually is a report.
Any insight is appreciated!
|
|
|
|
|
I'm curious why you need to constantly get feature information from a HID device since the feature set of a device should be static and fetching it once in response to a connection event I would think would be sufficient. However, it's not for me to judge...
If the function doesn't support async there is no way to make it act that way without implementing some sort of polling. Unlike making an async call synchronous, there is no 'await' for functions that don't use a callback and immediately return.
That being said, it isn't too hard to implement your own. Setting up a background worker or some other threading solution (even a system.threading.timer can be used) so you check at a given interval is very common. It used to be used a lot with serial comms to check the input buffer. The only gotcha is to make sure you have an abort so your app doesn't hang at close. If you use a timer with a polling interval it will automatically abort when your app shuts down. Also, make sure you handle the cross-thread marshal if anything is going up to the UI.
|
|
|
|
|
Hi Jason
Thank you for your input, appreciated!
Unfortunately, I did not write the firmware for the device. It uses feature reports as a 'bidirectional' report instead of input/output reports.
I have already implemented a polling solution, with best guess of how long to wait for, and what the polling frequency should be.
It works, but burns a lot of clock cycles in an already loaded system.
Thanks again and good luck with the fireworks - be careful
|
|
|
|
|
Ugh! Why do some vendors insist on doing things their own way instead of the way everyone else in the world does it!
Good luck. Polling is always a fine art of balancing responsiveness against overhead.
Thanks for the good wishes. We are buried in snow here in the Midwest US and I am VERY ready for fireworks season to return!
|
|
|
|
|
What about polling in a different thread and adding a custom event when data are available? With the current multi-core computers, that should help to remove load from the main (UI) thread of the application. Beware of Control.Invoke/BeginInvoke when you then update the UI on data received from the device.
|
|
|
|
|
Hi all,
I'm trying to build a SOAP message from scratch in C# for a webservice-consuming application. The WSDL provided for the service specifies using as a paramter to a particular method a class generated by the WSDL that includes roughly 70 different properties. When such a class is returned as the result of a method on this webservice, the proxy has no trouble moving the data from the SOAP message into this class, regardless of whether all 70 properties are present or not. Those missing fields are represented in the incoming message as self-closing tags. However, when the proxy generates a SOAP message *to* the webservice using this class, generating self-closing tags for empty fields, the webservice rejects the call. It's only when it's presented with non-empty tags--and at that, not all of the properties, if they contain a value, will be accepted--will it accept the message.
About 6 months ago I figured out how to create the message from scratch in C#, using the HttpWebRequest/Response classes (I think so, anyway), but since then I've lost those code files and can't figure out how I did it. Does anybody have an example of how to do it? Or, even better, any suggestions about what I can do to force the proxy to ignore empty properties when creating the SOAP message?
|
|
|
|
|
If all else fails you could of course just hand craft everything.
So rather than trying to use the C# soap classes just use http or even TCP and just create exactly the SOAP that you need.
|
|
|
|
|
That's what I'm working on right now, actually. I suppose the most specific my question could be is this:
Given a class with various members, how can I turn that into a SOAP message? For instance, if my class is wsRecord, and wsRecord has a String field called ID, a String field called Title, a DateTime field called RecordDate, and a String field called Comments, how do I put that into the message? None of the examples I've found online include any messages, only empty requests that return a response.
|
|
|
|
|
Easiest way I have found to do this.
- Create something that you know works to the target system using the existing API libraries
- Get it to work so it sends and receives.
- Set up a packet capture tool
- Run the message and capture the packets.
- Use the packets to create your HTTP message.
|
|
|
|
|
using System;
using System.IO;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace Applica
{
class Program
{
static void Main(string[] args)
{
long Totbyte = 0;
DirectoryInfo da = new DirectoryInfo("C:\\Folder");
FileInfo[] Arr = da.GetFiles();
foreach (FileInfo ap in Arr)
Totbyte = ap.Length;
Console.WriteLine("Total Bytes = {0} bytes", Totbyte);
string temPath = Path.GetTempFileName();
string temPath2 = Path.GetTempFileName();
if (File.Exists(temPath))
{
byte[Totbyte] data = File.ReadAllBytes(temPath);
File.WriteAllBytes(temPath2, data);
}
}
}
}
|
|
|
|
|
computerpublic wrote:
Well, it runs, but it might not be doing what you think it's doing. You're displaying the length of the last file in the directory, but your loop and variable name suggest you want to display the total length of all files in the directory. That's quite a simple change:
foreach (FileInfo ap in Arr)
Totbyte += ap.Length;
Note the "+=" instead of just "=".
computerpublic wrote:
Firstly, what would the length of the files in C:\Folder have to do with the length of a temporary file?
Secondly, the ReadAllBytes method will return an array of the correct size to contain all of the bytes in the file you're reading. You don't need to specify the size of the array.
byte[] data = File.ReadAllBytes(tempPath);
Thirdly, since you're just copying one file to another, why not simple use the File.Copy method?
if (File.Exists(temPath))
{
File.Copy(temPath, temPath2, true);
}
Finally, look at the documentation of GetTempFileName :
Creates a uniquely named, zero-byte temporary file on disk and returns the full path of that file.
That means that temPath will always exist, and will be an empty file. Copying it over another empty file will have no effect.
Perhaps if you explain what you're trying to do, we might be able to point you in the right direction.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|