how to write to a specific range in excel ? [modified] - C# Discussion Boards

First Prev Next

Re: Events from c# DLL not visible in VB7 project (Visual Studio 2008)

hoernchenmeister3-Mar-10 5:49

hoernchenmeister

3-Mar-10 5:49

Sorry for the confusion, I was accidentally referring to VB.NET as VB7...
But nevertheless, I will go check the versions used to compile the projects.

Anyway, thanks a lot for the idea Dave, I really appreciate that.

Unicode

Maninandan2-Mar-10 21:18

Maninandan

2-Mar-10 21:18

Hi,
my font style is courier view i want to display the string m4 like m³ in my reports. i used character map tool to make power 3 like m³ but i am unable to make that power 4.

regards,
selva

Find a word using regular expression in c#

PeriyasamyRamachandran2-Mar-10 19:48

PeriyasamyRamachandran

2-Mar-10 19:48

Hi,

I need to find a word using regular expression in c#.
Can anybody have an idea? Please..

Thanks,

Regards,
Periyasamy

Re: Find a word using regular expression in c#

sanforjackass2-Mar-10 19:51

sanforjackass

2-Mar-10 19:51

string s="sanforjackass";
s.Contain();

Re: Find a word using regular expression in c#

Arindam Tewary2-Mar-10 20:26

Arindam Tewary

2-Mar-10 20:26

Use Regex and MatchCollection class from System.Text.RegularExpression... sample code here

Pattern "\w" stand for word ....

Read here http://www.regular-expressions.info/charclass.html

Regex obj = new Regex("\\w+");
MatchCollection c = obj.Matches("3 idiots is an wonderful movie");
foreach (Match m in c)
{
    MessageBox.Show(m.Value);
}

Thanks,
Arindam D Tewary

Re: Find a word using regular expression in c#

PeriyasamyRamachandran2-Mar-10 20:28

PeriyasamyRamachandran

2-Mar-10 20:28

Hi,

Thanks to your reply.It helps me.

Regards,
Periyasamy.

datagridviewrow conversion

Member 5903102-Mar-10 19:28

Member 590310

2-Mar-10 19:28

hi,
how can i convert or cast datagridview row to datarow?

how to write to a specific range in excel ? [modified]

tonyonlinux2-Mar-10 19:15

tonyonlinux

2-Mar-10 19:15

For some reason this code is not writing to my excel file and I can't figure out why.
I have a premade template and it has a worksheet in it called bsheet and I also took and selected my range and hit insert/name and gave it the name btable

I then put this in a button click event to test but the xls is not effected what might i be doing wrong?

private void button1_Click(object sender, EventArgs e)
        {
            string connectionString = "Provider=Microsoft.Jet.OleDb.4.0; data source=c:\\BookList.xls; Extended Properties=Excel 8.0;";
            string selectString = "INSERT INTO btable VALUES('12345′, 'Acme Inc', 'Acme Way', 'CA')";

            OleDbConnection con = new OleDbConnection(connectionString);
            OleDbCommand cmd = new OleDbCommand(selectString, con);

            try
            {
                con.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                con.Dispose();
            }
        }

modified on Wednesday, March 3, 2010 1:52 PM

Re: how to write to a specific range in excel ?

tonyonlinux3-Mar-10 8:22

tonyonlinux

3-Mar-10 8:22

well i got it sorta working. The thing I'm having trouble with is one of the cells is merged
D to G
if i insert values "('A,'B','C','D')"; i get an error saying it can't expand.
I also tried putting '' for column e,f,g and that didn't work either.

Any idea how to insert a value into the merge cell? i tried to find some info online about this but came up try.

C# win application with web-browser control HANGS after some time

BalajiRamasamy2-Mar-10 18:55

BalajiRamasamy

2-Mar-10 18:55

I have developed a C# application. The application's main page contains a Web-Browser control. I will load a dynamic website in that web-browser control.

The application runs on the task bar. The application works fine for some time, after that it hangs. I am not able to continue to work on that application. Finally i have to kill the process and then have to restart to work on that.

The dynamic website is also developed using asp.net, C#.

My Question is

Is there any possibility that my application hangs due to some problems in dynamic website?.

I have checked the win application code, i couldn't find any hanging loops.

Please advice on the various possibilities that an application can hang.

Thanks,
Balaji.R

Re: C# win application with web-browser control HANGS after some time

Saksida Bojan2-Mar-10 19:06

Saksida Bojan

2-Mar-10 19:06

BalajiRamasamy wrote:
Is there any possibility that my application hangs due to some problems in dynamic website?.

Imposible. Server creates HTML corresponding script. It isn't limited to ASP.NET, even Python and PHP does that. Webcontrol only renders your HTML. It does not get aspx page it self or a php script.

BalajiRamasamy wrote:
I have checked the win application code, i couldn't find any hanging loops.

This could happen because inproper use of threads. It isn't limited to loops.

Re: C# win application with web-browser control HANGS after some time

BalajiRamasamy2-Mar-10 19:19

BalajiRamasamy

2-Mar-10 19:19

Hi Saksida,

Thank you for your reply. I will check all the threads now and I will post if I have any problems.

Thanks,
Balaji.R

Re: C# win application with web-browser control HANGS after some time

Luc Pattyn3-Mar-10 1:57

Luc Pattyn

3-Mar-10 1:57

There is an infinite number of ways for an application to hang; the majority of them involve programming errors. Since you didn't tell much about the content of your app, I have to speculate. I suggest you carefully read this[^].

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

datagridview insertion

Member 5903102-Mar-10 18:21

Member 590310

2-Mar-10 18:21

hi,
i have a datagridview bound to a datatable.now i want to swap the rows in datagridview but it is giving exception dat row insertion is not possible in datagridview bound to a datatable.is there any way to do that.

Message Closed

2-Mar-10 18:35

stancrm

2-Mar-10 18:35

Message Closed

modified 23-Nov-14 6:42am.

Re: datagridview insertion

Member 5903102-Mar-10 18:37

Member 590310

2-Mar-10 18:37

how?any code example?

Re: datagridview insertion

Arindam Tewary2-Mar-10 20:16

Arindam Tewary

2-Mar-10 20:16

In the gridview control a data view is assicated with the grid. Hence you might not be able to change the Grid display without changeing its underlying control's "view" (I am refering to the DataView object here). Hence you may try changing the datatable as per your requirement and "re-bind" the updated DataTable object.

Thanks,
Arindam D Tewary

How to Create Virtual Drive?

Pawan Kiran2-Mar-10 18:17

Pawan Kiran

2-Mar-10 18:17

Hi
Can any body know how to create Virtual Drive using windows app.

exa:
Local drive (Z Smile | :)

25GB

and also i want to create & save the files in the Virtual Drive(Z Smile | :)

Thanks in advance..
Pawan

Re: How to Create Virtual Drive?

Saksida Bojan2-Mar-10 18:42

Saksida Bojan

2-Mar-10 18:42

you can use Kernel device driver wraper found here: http://dokan-dev.net/en/[^]

Re: How to Create Virtual Drive?

Pawan Kiran2-Mar-10 18:57

Pawan Kiran

2-Mar-10 18:57

Can you plz send me the actual link (Direct URL)

Thankyou.

Re: How to Create Virtual Drive?

Saksida Bojan2-Mar-10 19:00

Saksida Bojan

2-Mar-10 19:00

Pawan Kiran wrote:
Can you plz send me the actual link (Direct URL)

Let me think.......NO.
Cant you see a Download link?
And you need to download both Dokan Library and Dokan .NET binding

Message Removed

2-Mar-10 9:09

Kennebel

2-Mar-10 9:09

Message Removed

Re: WPF Nested Grid Sizing

AspDotNetDev2-Mar-10 17:12

AspDotNetDev

2-Mar-10 17:12

I'm having trouble following along with your question. I like that you've shown the layout of your XAML, but if you actually showed the XAML you used then I could paste it into Kaxaml or Visual Studio and give it a try myself (I'm not about to type the XAML myself only to find out that you left off some property in your pseudo-XAML). Also, here are some general suggestions for how to ask a question:

In the future, using the WPF forum will likely generate more replies, since this is really a WPF question.
When using a PRE block to surround code or text, make sure to specify the LANG attribute. For example, the PRE you have above should probably have a LANG attribute set to "text", which will make it so "this" isn't blue (I think the default LANG, when you don't specify one, is "C++"). A good LANG to use for XAML code is "xml".

Maybe I'm having trouble visualizing what you mean because I don't have the XAML to reproduce your issue, but you may want to restate your question... I don't quite understand it.

[Forum Guidelines]

Re: WPF Nested Grid Sizing

Kennebel3-Mar-10 3:13

Kennebel

3-Mar-10 3:13

I'm sorry. I hadn't realized there was a WPF forum. I will repost there with the specific details.

Not sure why second Access Rule is required for User account write access

CTaylor892-Mar-10 8:31

CTaylor89

2-Mar-10 8:31

While logged in as an administrator in Windows 7,I create a directory(RS)in the ProgramData directory and a text file. I then write a string to the file. When I log in as a User account, I am able to write to the created file as long as I add the second Access Rule for the user. It does not make any sense to me why I have to add this second rule. I have tried applying the same permissions from the second User rule to the first User rule, and it still will not allow the User account to write to the file. Why do I have to add this second rule? Also why is it that FileSystemRights.FullControl is not really what it claims to be? After all if I gave someone full control of my car they would assume they could do anything with it, wouldn't they?

StringBuilder sbPath = new StringBuilder(40);
sbPath.Append(Environment.GetEnvironmentVariable("ALLUSERSPROFILE"));
sbPath.Append(@"\RS");

// Create a DirectorySecurity object
DirectoryInfo dInfo = new DirectoryInfo(sbPath.ToString());

if (!dInfo.Exists)
{
// Add ACL entrys to Directory before it is created
DirectorySecurity dSecurity = new DirectorySecurity();

dSecurity.AddAccessRule(new FileSystemAccessRule(new NTAccount("Administrators"),
FileSystemRights.FullControl | FileSystemRights.Write, InheritanceFlags.None,
PropagationFlags.None, AccessControlType.Allow));

dSecurity.AddAccessRule(new FileSystemAccessRule(new NTAccount("Users"),
FileSystemRights.FullControl | FileSystemRights.Modify | FileSystemRights.Synchronize,
InheritanceFlags.None,
PropagationFlags.InheritOnly, AccessControlType.Allow));

// *** Need this rule added in order for a user login to get access. Why?
dSecurity.AddAccessRule(new FileSystemAccessRule(new NTAccount("Users"),
FileSystemRights.FullControl, InheritanceFlags.ContainerInherit | InheritanceFlags.ObjectInherit,
PropagationFlags.InheritOnly, AccessControlType.Allow));

dInfo.Create(dSecurity);

sbPath.Append(@"\thefile.txt");

// Create directory under C:\ProgramData
FileStream fs = File.Create(sbPath.ToString());
StreamWriter sw = new StreamWriter(fs);
sw.WriteLine("Some Data");
sw.Close();
fs.Close();

Craig

Last Visit: 31-Dec-99 18:00 Last Update: 23-Jun-24 1:46

Refresh

ᐊ Prev 1...3614 3615 3616 361736183619 3620 3621 3622 3623 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.