.NET (Core and Framework)

Re: asp.net updatepanel with dropdownlists-can not select a different item

6-Aug-10 8:48

1) This should have been posted to the ASP.NET forum
2) Format posted code using pre tags, look at forum guidelines
3) Use http://www.asp.net/ajax/ajaxcontroltoolkit/samples/CascadingDropDown/CascadingDropDown.aspx[^]

I know the language. I've read a book. - _Madmatt

T M Gray9-Aug-10 6:02

T M Gray

9-Aug-10 6:02

Don't use multiple Triggers tags. If that isn't the source of your problem it is as least making it tougher to read your code. And if these dropdowns are the only things in the UpdatePanel you should consider just settings ChildrenAsTriggers and not even bother with the individual ASyncPostBackTrigger elements.

Message Removed

5-Aug-10 23:51

sr159

5-Aug-10 23:51

Message Removed

Re: i created mysqldump application using C#. it is saving to some path which i given. but how to make that application to save dump automatically at every 3 or 4 hours once daily [modified]

Pete O'Hanlon6-Aug-10 0:26

Pete O'Hanlon

6-Aug-10 0:26

<quote>*Contents of removed message*
i created mysqldump application using C#. it is saving to some path which i given. but how to make that application to save automatically like every 3 or 4 hours daily. i written code like below
public void Dump()
{
try
{
DateTime Time = DateTime.Now;
int year = Time.Year;
int month = Time.Month;
int day = Time.Day;
int hour = Time.Hour;
int minute = Time.Minute;
int second = Time.Second;
int millisecond = Time.Millisecond;

string path;
path = "E:\\BackupMysql1\\" + year + "-" + month + "-" + day + "-" + hour + "-" + minute + "-" + second + "-" + millisecond + "_temple.sql";
StreamWriter file = new StreamWriter(path);
ProcessStartInfo psi = new ProcessStartInfo();
psi.FileName = @"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump";
psi.RedirectStandardInput = false;
psi.RedirectStandardOutput = true;
psi.Arguments = string.Format(@"-u{0} -p{1} -h{2} {3}", "xyz", "abcd", "localhost", "database");
psi.UseShellExecute = false;
Process process = Process.Start(psi);
string output;
output = process.StandardOutput.ReadToEnd();
file.WriteLine(output);
process.WaitForExit();
file.Close();
process.Close();
}
catch (IOException ex)
{
MessageBox.Show("Error , unable to backup!");
}
}
anybody knows please reply me.
*End*
The easy way to do this is to use a scheduled job in the windows scheduler that is set to run at a set interval. Don't muck about attempting to write code to do this when the OS provides a perfectly serviceable method.

"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

modified on Friday, August 13, 2010 12:24 PM

Expan/Collapse Table

All Time Programming5-Aug-10 23:12

All Time Programming

5-Aug-10 23:12

Hello,

I have a special requirement where I need to show grouped data in expandable form. For eg:
Order Date Total Amt
+ 1 05/06/2010 100.00
Item Qty Rate Amt
A 5 10 50.00
B 2 25 50.00

This format we normally see in Access when the data is grouped or a primary key of table A is the foreign key of table B. If I clikc "+" sign next to order #, I get to see the item details belonging to that order. If the order is already expanded "-" sign lies and if their are no item details pertaining to any order their should be no sign.

I know I can do this format using Tree, but that looks too off profesional.

Can you suggest me any idea to implement this using Vb.NET.

Thanks,

Thanks & Regards,

See this [http://mosesofegypt.net/post/Building-a-grouping-Grid-with-GridView-and-ASPNET-AJAX-toolkit-CollapsiblePanel.aspx]

Prosanta Kundu online5-Aug-10 23:24

Prosanta Kundu online

5-Aug-10 23:24

All Time Programming6-Aug-10 0:02

All Time Programming

6-Aug-10 0:02

Thanks.

But I need it for VB.NET application and not a web application. It doesn't seem that I can use this component in Vb.NET desktop application. Any idea or suggestions are welcome.

Thanks & Regards,

Not Active6-Aug-10 8:55

6-Aug-10 8:55

Perhaps you should have specified the technology was Windows not Web.

There are plenty of examples here. Like this one, Collapsible Panels in VB.NET[^]

All Time Programming wrote:
I need it for VB.NET

Not every example will be in VB.NET and you should learn to read and understand other languages and how to translate it to your needs.

I know the language. I've read a book. - _Madmatt

Compare column names in Excel in each sheet by SSIS

All Time Programming6-Aug-10 19:47

All Time Programming

6-Aug-10 19:47

Thanks alot, Mark. Thumbs Up | :thumbsup:

Your links answered my query much better. Thanks once again.

Yes Mark, I can read and translate from any to any among C#, VB, Java. But needed some guideline for start up also.

Thanks & Regards,

Member 32222645-Aug-10 3:35

Re: Compare column names in Excel in each sheet by SSIS

5-Aug-10 3:35

Hi,
Is it possible to compare two excel sheets ie column names in each sheet by using SSIS package?

Need some urls or some examples

Notify user when there is no matching in column names and exlude that file and pick the next excel file placed in server.mappath.

Thanks
Guhananth.S

Not Active5-Aug-10 6:27

SSIS package VS 2005,porting data from Excel to DB

5-Aug-10 6:27

Stop posting and read the guidelines

I know the language. I've read a book. - _Madmatt

Member 32222645-Aug-10 2:41

5-Aug-10 2:41

Hi,
In SSIS is possible to check
a) Excel template check ie comparing the column names of each sheet with another standard sheet

The SSIS must check if the uploaded excel is matching the standard excel.

b)The SSIS must pick any excel sheet placed in server.mappath ie able to pick any excel file names.

c)Also the SSIS must read the excel sheets and port data to respective tables.
How to do?

How to do these tasks in SSIS package.

If we deploy this,will the package check excek sheet format and notify admin,if any things goes wrong.

Thanks
S.Guhananth

Message Removed

4-Aug-10 19:59

Re: SSIS PACKAGE VS 2005 - IMPORT EXCEL TO DATABASE.

4-Aug-10 19:59

Message Removed

Richard MacCutchan5-Aug-10 2:32

Richard MacCutchan

5-Aug-10 2:32

Please read the guidelines[^] and don't use capitals for your entire message. Also please clarify what your quesstion has to do with the .NET framework.

It's time for a new signature.

SSIS Package VS2010

Member 32222644-Aug-10 19:54

Team Foundation Server vs Visual Source Safe

4-Aug-10 19:54

HI,
How to create SSIS package in VS 2010

which option we need to choose

guhananth.S

Re: SSIS Package VS2010

gablock5-Aug-10 2:58

gablock

5-Aug-10 2:58

You cannot create an SSIS package in VS 2010. The installation of SQL Server 2008 can install the Business Intelligence Development Studio (BIDS) which is a variant of VS 2008. BIDS provides the templates and capability of creating and deploying SSIS packages

CARisk34-Aug-10 8:29

CARisk3

4-Aug-10 8:29

I'm not sure this is the right place to ask this question. We are currently using Visual Source Safe and VS 2002/2003. We are looking to upgrade to Visual Studio 2010. I need to know if Visual Source Safe will work with VS 2010 or do I need to move to Team Foundation Server? And does Team Foundation Server come with VS 2010? And what are the pros and cons of using one over the other?

And before any one suggest a different version control software package, that is not an option. I work for a university and with our licensing agreement I have to go with one or the other.

Thanks,
Carolyn

If you can’t have fun at work, then why go to work?

Not Active4-Aug-10 8:39

4-Aug-10 8:39

VS2010 will work with VSS. TFS does not come with Visual Studio, it is a separate server that VS connects to via the Team Explorer.

As for the pros and cons of each, that would entail a long and, for some, hated debate. There is plenty of information available that describes TFS. Essentially though if you have a small team of developers, three or less, then VSS will probably work best for you. However, if you want to including continuous integration builds, work item tracking, etc. then TFS is the tool.

I know the language. I've read a book. - _Madmatt

CARisk34-Aug-10 8:44

CARisk3

4-Aug-10 8:44

Will VSS need to be upgraded? The version is probably as old as my VS. This was the setup when I came on board a couple of years ago and I'm just now getting the okay to upgrade so I want to get everything that possibly needs done at once. It'll probably be another six or eight years before they upgrade again. This department is not very good about being on the cuttng edge or even at the front of the pack.

Thanks for replying.

Carolyn

If you can’t have fun at work, then why go to work?

Not Active4-Aug-10 8:52

4-Aug-10 8:52

VSS should be fine, it hasn't been updated in years anyway. Given that it may be a very long time until you have budget to upgrade again I would certainly go with TFS. In another few years VSS probably won't be supported or won't meet your needs. TFS is very extensible so it can keep pace with you. Also, there are feature that you will probably find very useful, if not now, certainly in the future.

I know the language. I've read a book. - _Madmatt