C# Discussion Boards - CodeProject

First Prev Next

Re: C# have linq to sql access config file

sc steinhayse23-Jun-13 10:50

sc steinhayse

23-Jun-13 10:50

Can you tell me how to change the code so that it is better managed? I definitely need to obtain the database connections from the app.condif file.

Re: C# have linq to sql access config file

Richard MacCutchan23-Jun-13 21:01

Richard MacCutchan

23-Jun-13 21:01

You can get the configuration settings in your main program's code and then pass it in to the method that does the database access, the same as you would any method that accepts input parameters.

Use the best guess

Populate Products as Buttons

Jassim Rahma22-Jun-13 1:46

Jassim Rahma

22-Jun-13 1:46

Hi,

I have a products table in my database. I want to display the products from my table as Buttons on the form not as Grid so user will click the button of each product.

I want to display the product name (or image) on the button and assign the product id as button tag

How can I do this please?

Technology News @ www.JassimRahma.com

Re: Populate Products as Buttons

OriginalGriff22-Jun-13 3:48

OriginalGriff

22-Jun-13 3:48

Try:

Button but = new Button();
but.Image = Image.FromFile(pathToImage);
but.Text = "";
but.Tag = productId;
but.Click += new EventHandler(button_Click);
but.Location = new Point(X, Y);
but.AutoSize = true;
Controls.Add(but);

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software

jithintbr22-Jun-13 0:42

jithintbr

22-Jun-13 0:42

i want to use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software.i am using vs 2010 and SQL server 2005.

Re: use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software

Richard MacCutchan22-Jun-13 1:00

Richard MacCutchan

22-Jun-13 1:00

Very interesting; now do you have a question?

Use the best guess

Re: use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software

OriginalGriff22-Jun-13 1:01

OriginalGriff

22-Jun-13 1:01

Snap!

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

Re: use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software

Richard MacCutchan22-Jun-13 1:12

Richard MacCutchan

22-Jun-13 1:12

We really need to get out more ... Wink | ;)

Use the best guess

Re: use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software

jithintbr22-Jun-13 1:16

jithintbr

22-Jun-13 1:16

Do u have any idea?

Re: use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software

jithintbr22-Jun-13 1:17

jithintbr

22-Jun-13 1:17

How can i do this problem?.Please help me to solve this

Re: use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software

OriginalGriff22-Jun-13 1:00

OriginalGriff

22-Jun-13 1:00

Good for you!
That sounds like a good idea.

Now, what have you done so far to make it happen? (Other than tell us what you want here)

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

Re: use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software

jithintbr22-Jun-13 1:15

jithintbr

22-Jun-13 1:15

i can use the software offline.when it connect to server, the data should be synchronized. and all other users get this updated data.

Re: use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software

OriginalGriff22-Jun-13 1:20

OriginalGriff

22-Jun-13 1:20

So what you want is called Database Replication, and it is not a trivial subject in the least.
Start with Google: https://www.google.co.uk/search?q=Database+Replication&oq=Database+Replication&aqs=chrome.0.57&sourceid=chrome&ie=UTF-8[^] - but expect a lot of reading if you want to get this right!

The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

Re: use my windows application both offline and online. when it connect to internet ,it should synchronize my data and should visible to everybody those who use this software

Pete O'Hanlon22-Jun-13 4:15

Pete O'Hanlon

22-Jun-13 4:15

Take a look into the Microsoft Sync Framework.

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Error while saving XLS file.

Member 1002654421-Jun-13 3:58

Member 10026544

21-Jun-13 3:58

hi,
i am trying to create an .xls file from a data table and saving it in application local folder. all this i am doing for a web application. everything is fine until i end with an error. so please look into below error and help me out with a solution

Error :

Microsoft Excel cannot access the file 'E:\Syed Project\E-Comply_Project\E-Comply Source Code\COC_Export\'. There are several possible reasons:

. The file name or path does not exist.
. The file is being used by another program.
. The workbook you are trying to save has the same name as a currently open workbook.

Code :

public void DTToExcel(System.Data.DataTable dt, string filePath)
{
try
{
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;

xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

string data = string.Empty;
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
for (int j = 0; j <= dt.Columns.Count - 1; j++)
{
data = dt.Rows.ItemArray[j].ToString();
xlWorkSheet.Cells[i + 1, j + 1] = data;
}
}
xlWorkBook.SaveAs(filePath + "\\" + "BOM_Matched_ExcelReport.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
}catch(Exception Ex)
{ throw Ex; }
}

Thanks & Regards,
Sateesh kumar Singupuram

sateesh kumar singupuram

Re: Error while saving XLS file.

Simon_Whale21-Jun-13 4:01

Simon_Whale

21-Jun-13 4:01

Does the application / user have permission to write to that folder?

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: Error while saving XLS file.

Member 1002654421-Jun-13 4:09

Member 10026544

21-Jun-13 4:09

hi Simon_Whale,
thanks for the immediate reply and i would like to know how to set the folder permissions as i have added that folder to my assembly to maintain as a local folder to my hosting server.

Re: Error while saving XLS file.

Simon_Whale21-Jun-13 4:27

Simon_Whale

21-Jun-13 4:27

Have a read of this

deployment to a hosting provider/deployment to a hosting provider setting folder permissions[^]

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

ASP.NET and MATLAB deployment over web server

Mridul Bagani21-Jun-13 3:44

Mridul Bagani

21-Jun-13 3:44

Hello,
I have created an application in C#(Visual studio 2008),which pass some parameters to MATLAB(R2010a(x86) using "matlab builder ne"and output is a graph drawn by MATLAB.
Application is working fine when running in visual studio.
Then | uploaded it on IIS,application is running,but I am not getting graph on browser.
Please help me,i have been working in this problem for a week. Frown | :(

Re: ASP.NET and MATLAB deployment over web server

Eddy Vluggen21-Jun-13 7:26

Eddy Vluggen

21-Jun-13 7:26

Mridul Bagani wrote:
Then | uploaded it on IIS,application is running,but I am not getting graph on
browser.

You might have more luck in the ASP.NET forum. I don't know much about websites, but it sounds like the server-version might not have the referenced libraries from MATLAB (or one of their dependencies)

Is there an errorlog somewhere? An exception that's thrown? How did you deploy the application? Just copied the source-files?

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Editing Group Policies Using C#

piyushhgupta20-Jun-13 7:06

piyushhgupta

20-Jun-13 7:06

I am working on code for plugin installation in browsers

For the same, In plugin installation on Internet Explorer.. I need to make some modifications in group policy by my C# code at following path in group policy editor:

User Configuration\Administrative Templates\Windows Components\Internet Explorer\Security Features\Add-on Management\Add-on List

// You can find the same by "gpedit.msc" on RUN.
Confused | :confused:

Please help me out.

Thanks.

Re: Editing Group Policies Using C#

Pete O'Hanlon20-Jun-13 22:22

Pete O'Hanlon

20-Jun-13 22:22

Help you out with what? What code have you got? What's not working?

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Re: Editing Group Policies Using C#

piyushhgupta23-Jun-13 21:07

piyushhgupta

23-Jun-13 21:07

I need to initiate the process of communication with group policy via C# code so that I can read and edit the same, some API or method would be sufficient for me.

Re: Editing Group Policies Using C#

Rajesh Anuhya21-Jun-13 1:03

Rajesh Anuhya

21-Jun-13 1:03

See this Link

http://msdn.microsoft.com/en-us/library/windows/desktop/aa374177(v=vs.85).aspx[^]

Thanks
--RA

my Tip/Tricks[^] |Contact me[^]

After the application is closed, get the last used Path in a textbox when application start again

anubhavprabakar19-Jun-13 22:43

anubhavprabakar

19-Jun-13 22:43

Hi all,

I am using FolderBrowserDialog and a browse button which allows the user to select a desired folder.

However, what i really want is that when the user closes the application and restarts it, the textbox field should contain the last used path and when i open the FolderBrowserDialog, it should point to the last folder rather than starting from the root (C Smile | :)

Can anyone please help??

Last Visit: 31-Dec-99 18:00 Last Update: 27-Apr-24 21:45

Refresh

ᐊ Prev 1...1528 1529 1530 153115321533 1534 1535 1536 1537 Next ᐅ

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