|
Hi ,
This is in continuation of my previous post.
I am creating a windows application in which i query data from 5-6 tables in sql and display it in excel. My problem is:-
I also need to format my excel sheet as follows:
the data has different values in 5 columns for the same values in the first 10 columns.
I need to show the columns with same data only once and then just populate the columns which have different data for the same value in first 10 columns.
Any help or suggestions are greatly appreciated.
|
|
|
|
|
The first thing that comes to my mind is to use a template sheet that you keep filling over and over again.
I used the same thing some time ago and it worked
|
|
|
|
|
yeah , thanx that sounds good but the data i am returning is sizeable amount so if i refill several times for each to get the formatting it would be an overkill for my application. !!
|
|
|
|
|
Hi All, I am trying to get all the table name that exist in my database.
Can any body please help me.
thanks
|
|
|
|
|
SELECT name FROM sqlite_master
WHERE type='table'
ORDER BY name;
|
|
|
|
|
hi, MeLight,
using your code I get the first talble name. how do I get the rest.
con = new SQLiteConnection(@"Data Source= mydata;Version=3;New=False;Compress=True;");<br />
con.Open();<br />
cmd = new SQLiteCommand();<br />
cmd = con.CreateCommand();<br />
cmd.Connection = con;<br />
cmd.CommandText = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name ";<br />
object tablecount = cmd.ExecuteScalar();
how do i get the rest.
thanks.
|
|
|
|
|
Don't use a scalar - that returns a single value. Use a DataReader instead.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
con.Open(); // move it below
cmd = new SQLiteCommand(); // don't need it
cmd = con.CreateCommand();
cmd.Connection = con; // don't need it
con.Open();
|
|
|
|
|
ok , let me try it and I will let you know.
|
|
|
|
|
What do you use to connect to the database?
|
|
|
|
|
Try the following...
A simple example of SQL server admin tools.
Thanks
Md. Marufuzzaman
Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
Hi,
I'm trying to generate a key press with C#, so that it can be picked up by another app. I tried to use the SendKeys class to achieve what I'm looking for
while (true)
{
SendKeys.SendWait("{F1}");
Thread.Sleep(500);
}
which works for most apps I tried (FireFox, VS2008 etc), but not the app I'm looking to control - Frets on Fire[^]. I was told that the problem might occur because FoF doesn't deal with windows messages, but instead, polls the input device (keyboard) directly.
Is there an option to simulate the behavior of an actual keyboard (write directly to the memory responsible for keyboard or something), or applying some other workaround?
Thank you!
|
|
|
|
|
MeLight wrote: Is there an option to simulate the behavior of an actual keyboard (write directly to the memory responsible for keyboard or something), or applying some other workaround?
The only thing I can think of would be to write your own keyboard driver (cannot be done in C#!) and have it generate key states on demands of an external application.
Don't ask for examples, I don't have any.
|
|
|
|
|
I think I've found the problem. FoF reacts to the sendkey events, only I believe they are too quick to have any effect. I'm trying the SendInput solution now, which is not going so well, as I lost even the functionality I've had with SendKey (im probably doing something wrong).
How would "hold down" a button programatically?
Thanx
edit: I've also tried the keybd_event() thingie (with DllImport) and it gives same results as SendKey (only sending one command on key down), the key released command seems to have no effect also.
|
|
|
|
|
Hello,
I need to migrate a COM written in C++ to C#.
Is it possible to use the same CLSID (GUID) for both?
I ask this because after i remove the C++ component, i will install the C# one and i dont wan't to change any app that are using the old component.
is it possible? or will be some conflicts?
Thanks,
F
|
|
|
|
|
I am tryng to save my changes in one section the App.config, but I am not able, I get the values contained using the ConfigurationManager.GetSection, and the Class with inheritance of ConfigurationSection, but later I change the values of the properties and call to config.Save but the values don´t change in App.config.
Please any suggestion
|
|
|
|
|
Have look here[^] or here[^]
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi
I have to create a windows application which can connect to a remote host through SSH and can perform some operations on the remote host.
remote host is a cisco router 3745
Problem I am facing is which ssh client to use and how to use in the application.
If anybody knw please update me @ himanshu_agarwal@live.com / himanshu.agarwal@gmail.com
|
|
|
|
|
Dear all,
I have a two projects in in my solution.
the first one is a windows service and the second project is a asp.net project.
The purpose of the asp.net website is to cofigure the configuration file(xml file) that the windows service uses.
My question is where to put this configuration file so both projects can reach it?
I putted it in the solution items directory, bud i can't reach it in my code.
Can someone give me a hint?
Thanks in advance.
|
|
|
|
|
What exactly do you mean by solution items directory?
Remember that VS (by default) places your binaries in the \bin\Debug or \bin\Release directories..
|
|
|
|
|
Priya Prk wrote: The purpose of the asp.net website is to cofigure the configuration file(xml file) that the windows service uses.
And how do you propose to write a file outside of your web site?
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi,
I am having a strange problem when starting a process on a Windows Mobile based device.
RepsApp is the entry point for the application.
AppHandler is essentially a class that is used to maintain a bunch of global variables.
public class RepsApp
{
static void Main()
{
AppHandler.frmMain = new FormMain();
AppHandler.frmMain.ControlBox = true;
AppHandler.frmMain.MinimizeBox = false;
AppHandler.frmMain.FormBorderStyle = FormBorderStyle.FixedSingle;
Application.Run(AppHandler.frmMain);
if (AppHandler.GetUpdates)
{
int processID = Process.GetCurrentProcess().Id;
Process p = new Process();
p.StartInfo.FileName = Path.Combine(AppHandler.GetAppPath(), "AppUpdater.exe");
p.StartInfo.Arguments = string.Format("{0} {1}", processID, true);
p.Start();
}
Application.Exit();
}
}
In the MainForm class I simply set AppHandler.GetUpdates to True and close the form
public class FormMain : System.Windows.Forms.Form
{
private void menuItemGetUpdates_Click(object sender, EventArgs e)
{
AppHandler.GetUpdates = true;
this.Close();
}
}
When the MainForm closes :
if AppHandler.GetUpdates is True the main application stays in memory after it launchs the AppUpdater process.
if AppHandler.GetUpdates is False the main application closes as expected.
Is there any reason why calling Process.Start would prevent the main application from closing?
Thanks,
David
|
|
|
|
|
hi,
iam not sure if that could help..,
you set the current ProcessID from the running app at the arguemnts. don't know what your AppUpdater internal do with the ProcessID but maybe it supsends the thread on the processid so you "main" application could not close ?!?
greetz
|
|
|
|
|
hi sir,
i am work in c# then my problem public variable define in c#
|
|
|
|
|
A public variable is just a variable which is defined outside of a method and has the visibility specifier of public. Depending on how you look at it, a property could be a public variable in its most basic case (disregarding the generated get/set methods, no validation, etc).
modified on Friday, November 20, 2009 8:18 AM
|
|
|
|