using System; using System.Collections.Generic; using System.ComponentModel; using System.Configuration.Install; using Microsoft.Win32; using System.Reflection; using System.IO; using System.Diagnostics; using System.Windows.Forms; namespace WindowsControlLibrary1 { [RunInstaller(true)] public partial class CustomInstaller : Installer { public CustomInstaller() { InitializeComponent(); } protected override void OnAfterInstall(System.Collections.IDictionary savedState) { string programName = "\"" + CeAppMgrExe + "\""; string programArg = "\"" + IniFilePath + "\""; MessageBox.Show(programName + " " + programArg); Process.Start(programName, programArg); base.OnAfterInstall(savedState); } const string _ceAppMgRegistryPath = @"software\Microsoft\Windows\CurrentVersion\App Paths\CEAppMgr.exe"; const string _iniFileName = "PDARAM.ini"; const string _filePrefix = @"file:\"; string CeAppMgrExe { get { RegistryKey subKey = null; string exePath = null; try { subKey = Registry.LocalMachine.OpenSubKey(_ceAppMgRegistryPath); exePath = (string) subKey.GetValue(""); } finally { if (subKey != null) subKey.Close(); } return exePath; } } string IniFilePath { get { string installFolder = Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase); string iniFilePath = Path.Combine(installFolder, _iniFileName); if (iniFilePath.StartsWith(_filePrefix)) { int index = _filePrefix.Length; iniFilePath = iniFilePath.Substring(index); } return iniFilePath; } } } } Can anyonehelp me? I am buliding the Desktop installer, and it starts the install proccess, but tells me there is an error in my setup file? This is my INI file [CEAppManager] Version = 1.0 Componet = DeviceApplication1 [DeviceApplication1] Description = PDA RAM Data

no one? Computer Programmer Web/Mobile .NET

Well I know I didn't do it the correct way.. However it does work... private void R1RecCount() { R1Count.Visible = false; conn = new SqlCeConnection("Data Source = \\My Documents\\RAM.sdf"); conn.Open(); SqlCeCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM R1Time"; SqlCeDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { countr1 = countr1 + 1; if (countr1 >= 1) { //MessageBox.Show(rdr.GetValue(0).ToString()); //Eventually will ad button to this screen this.rAMDataSet.R1Time.AddR1TimeRow( rdr.GetValue(0).ToString(), rdr.GetValue(1).ToString(), rdr.GetValue(2).ToString(), rdr.GetValue(3).ToString(), rdr.GetValue(4).ToString(), rdr.GetValue(5).ToString(), rdr.GetValue(6).ToString(), rdr.GetValue(7).ToString()); } } R1c.Text = countr1.ToString(); R1c.Enabled = false; this.r1TimeTableAdapter.Fill(this.rAMDataSet.R1Time); conn.Close(); } Computer Programmer Web/Mobile .NET

Ibuprofen wrote: Anyone that uses my application, has a security clearance The vast majority of security breaches are inside jobs. Ibuprofen wrote: if any of the people cause a SQL Injection attack. Well then, that will end with a nice prison sentence. If they get caught! Ibuprofen wrote: I am not a trained programmer, the article is a bit above my head I wrote the article. If I can help you understand it then let me know what you'd like help with. Upcoming FREE developer events: * Developer! Developer! Developer! 6 * Developer Day Scotland My website

Sorry, I meant to type SQL Server 2000 and Visual Studio 2003. Thank you, that worked for me.

I rewrote the try, and also put in something to catch the Handle the Error. private void UpdateFeedback_Click(object sender, System.EventArgs e) { bool bNoError =true; OleDbConnection con = new OleDbConnection(strConnection2); string strSQL=""; DataSet ds = new DataSet(); CUsers user =new CUsers(); user=(CUsers)Session["SessionUser"]; switch(user.Role) { case "TL": //string strStatus=""; if(TicketStatus.SelectedValue=="Closed") { string strStatus="Closed"; TicketClosedBy.Text = strStatus; } else { TicketClosedBy.Text=""; } strSQL="UPDATE UserFeedback set [TLComment]='"+TLComment.Text+"', [TLwho]='"+TLwho.Text+"', [TicketStatus]='"+TicketStatus.SelectedValue+"', [TicketClosedBy]='"+TicketClosedBy.Text+"', [NeedAction]='"+NeedAction.SelectedValue+"' WHERE autoNum="+TicketNum.Text; break; case "CP": if(TicketStatus.SelectedValue=="Closed") { string strStatus="Closed"; TicketClosedBy.Text = strStatus; } strSQL="UPDATE UserFeedback set [CPComment]='"+CPComment.Text+"', [CPwho]='"+CPwho.Text+"', [TicketStatus]='"+TicketStatus.SelectedValue+"', [TicketClosedBy]='"+TicketClosedBy.Text+"' WHERE autoNum="+TicketNum.Text; break; case "ORA": if(TicketStatus.SelectedValue=="Closed") { string strStatus="Closed"; TicketClosedBy.Text = strStatus; } strSQL="UPDATE UserFeedback set [ORAComments]='"+ORAComments.Text+"', [ORAwho]='"+ORAwho.Text+"', [TicketStatus]='"+TicketStatus.SelectedValue+"', [TicketClosedBy]='"+TicketClosedBy.Text+"' WHERE autoNum="+TicketNum.Text; break; case "DMO": if(TicketStatus.SelectedValue=="Closed") { string strStatus="Closed"; TicketClosedBy.Text = strStatus; } strSQL="UPDATE UserFeedback set [DMComments]='"+DMComments.Text+"', [DMwho]='"+DMwho.Text+"', [TicketStatus]='"+TicketStatus.SelectedValue+"', [TicketClosedBy]='"+TicketClosedBy.Text+"' WHERE autoNum="+TicketNum.Text; break; case "User": if(TicketStatus.SelectedValue=="Closed") { string strStatus="Closed"; TicketClosedBy.Text = strStatus; } strSQL="UPDATE UserFeedback set [Comments]='"+Comments.Text+"', [TicketStatus]='"+TicketStatus.SelectedValue+"', [TicketClosedBy]='"+TicketClosedBy.Text+"' WHERE autoNum="+TicketNum.Text; break; } try { OleD

Just had to create the string for my autoNum field.

Just pass the string to the required page or store it and retrieve it from some location and do the same thing.

Well, it truly does prove how much better it is to just have someone elses eyes on your code, I sent it to a friend and fellow programmer, and as he was reviewing it, I found my TYPO's. Fixed and counts were correct.

Ibuprofen wrote: Why would you want to compile a whole websites piece of code into a DLL file? Because that's how it is done - the business logic and data access exist in different assemblies to the presentation layer. In theory, it means different parts can be replaced. This does not happen in the real world. However, it does help with organising the code, nonetheless. Certainly having all the DB code in one place is invaluable. And, using stored procs is even better. Ibuprofen wrote: there is lots of devlopment done to it, and there is no way I could go back and change it all is what I was getting at. Well, you may be able to improve new parts at least. Or, at a minimum, learn how to do it, so you can tell your bosses that you're not happy having to work with a monolithic structure, that it will cause maintenance issues in the future, but you have no choice. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Timing out, how ? If they can see the whole thing, there shouldn't be any timeout while they are filling it in. 105 items doesn't seem like a lot to load, either ? Perhaps you need to break it over several pages ? Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

I am sorry I was tired last night and mistyped, I was actually trying to get it were it wouldnt pull any NULL values in.

I never did get this to work, however, I just used a Session Variable. Thanks for your time Guffa!

Hi, Insted of allowing user to download live database you can provide facility to dowonload backup. You can write code to take backup at every some period of time and store that to some place on the server and provide the user with link to that location to download the database. I hope this will help you. Thanks and Regards, Chetan Ranpariya