I use the following code to login to a crystal report based arround an ms access database ConnectionInfo crInfo = new ConnectionInfo(); crInfo.DatabaseName = appSettings.Settings["AccessDB"].Value; crInfo.ServerName = appSettings.Settings["AccessDB"].Value; crInfo.UserID = ""; crInfo.Password = ""; I need to do this now to a secured version. I have modified the above code to ConnectionInfo crInfo = new ConnectionInfo(); crInfo.DatabaseName = appSettings.Settings["AccessDB"].Value; crInfo.ServerName = appSettings.Settings["AccessDB"].Value; crInfo.UserID = "Goldmine"; crInfo.Password = "orielgold"; BUT how do I specify the location/path/name of the system.mdw file? In previous version there was a .add property but this does not appear in VS2005/CR XI R2 system.

Robert T Turner

We use Active Directory on a Windows 2000 server and Microsoft Exchange. Our workstations are mix of OS from Windows 98 to XP Pro. Our Microsoft Office versions also vary from 2000 to XP to 2003. My problem is that I need users to be able to logon on to any machine and be able to read their mail without coming to me to go and set up the properties of outlook/exchange to change the user. I have found some scripts etc to find out the current user, to get details from the Active Directory but I have not been able so far to find how to change the mailbox setting from a script. Has anybody any idea? :doh: Regards Robert T Turner

I did not have a problem when running in Framework 1.1 but since I am running in 2.0 I am getting the following error: SqlException (0x80131904): XML parsing error: Switch from current encoding to specified encoding not supported. The code I am using is: (snippet) - [XmlRoot ("pledges")] /// /// Summary description for pledge. /// public class pledge { private string strName; private string strAddress1; private string strAddress2; private string strTown; private string strPostcode; private string strEmail; private string strTelephone; private int intAmount; private int intGiftAid; private string strMessage; [XmlAttribute (AttributeName = "name")] public string Name { get { return this.strName; } set { strName=value; } } [XmlAttribute (AttributeName = "address1")] public string Address1 {.............. and the routine to process: public void sponsorship(pledge details) { MemoryStream memoryStream = new MemoryStream(); XmlSerializer serlizer = new XmlSerializer(typeof(pledge)); SqlCommand cmdInsert; SqlParameter paramReturnValue; string strXML = null; int intSuccess; try { XmlTextWriter xmlTextWriter = new XmlTextWriter(memoryStream, Encoding.UTF8); serlizer.Serialize(xmlTextWriter, details); memoryStream = (MemoryStream)xmlTextWriter.BaseStream; strXML = UTF8ByteArrayToString(memoryStream.ToArray()); }catch (Exception e) { System.Console.WriteLine(e); } SqlConnection conPledge = new SqlConnection(Settings.GetConfigValues("appSettings","databaseConnectionString")); cmdInsert = new SqlCommand("p_xmlPledgeInsert",conPledge); cmdInsert.CommandType = CommandType.StoredProcedure; cmdInsert.Parameters.Add("@strXML",SqlDbType.NText); cmdInsert.Parameters["@strXML"].Value=strXML; paramReturnValue = cmdInsert.Parameters.Add("ReturnValue", SqlDbType.Int); paramReturnValue.Direction=ParameterDirection.ReturnValue; conPledge.Open(); cmdInsert.ExecuteNonQuery(); intSuccess = Convert.ToInt16(cmdInsert.Parameters["ReturnValue"].Value); conPledge.Close(); } } I wonder if you can help me? Robert T Turner

I am trying to use the Autodesk Express Viewer in a c# asp.net project. I have added references to adCommon.dll,adview.dll (ExpressViewerDll), eplotviewer.dll, eplotcore.dll.eplotcommon.dll, and eplotrenderer.dll I have placed a placeholder on the form and in the form load I would like to set up and display the viewer. As I very new to asp.net I seem to missing pieces of the jigsaw, and any documentation that comes with the viewer is confusing to me. I need to create an instance of the viewer, load the SourcePath property, and then add it to the placeholder. My attempts so far have come up with problems such as 'cannot convert ExpressViewerDll.CExpressViewerControl to System.Web.UI.Control Can anybody give me some assistance Thanks Robert T Turner South Gloucestershire Council

Thanks very much. I knew it would be something stupid. I very new to .net and I flitting back and from between asp and asp.net. You help is very much appreciated Robert T Turner South Gloucestershire Council

Code in page_load is if (!IsPostBack) { Label x = new Label(); x.ID="lblQuestionX"; x.Text="Robert"; plhQuestions.Controls.Add(x); } pressing submit button private void Button1_Click(object sender, System.EventArgs e) { if (Page.IsValid) { Label lblTemp = new Label(); lblTemp = (Label)plhQuestions.FindControl("lblQuestionX"); string strNumber = lblTemp.Text; last line generates error: Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. What stupid thing am I doing wrong this time? cheers Robert T Turner South Gloucestershire Council

Thanks to you and all who replied Robert T Turner South Gloucestershire Council

I am using the article Inserting XML formatted data into SQL Server 2000 By faisal abdul aziz as a template for some work I doing. I have create a class, in a separate class file, to cover the 'child' elements. I have called this Answers.cs. The begining of the file looks like this: using System; using System.Xml.Serialization; namespace SGC.Apps.Consultations { public class Answers { public Answers() { } private int intQNo; private int intAns; [XmlAttribute] public int Question_No { get { return this.intQNo; } set { intQNo = value; } etc..... In web form I have button_click event routine private void Button1_Click(object sender, System.EventArgs e) { if (Page.IsValid) { XmlSerializer serlizer = new XmlSerializer(typeof(Replies)); int intCount = 2; Answers[] ans = new Answers[intCount]; ans[1].Question_No = 3; etc...... I get the error Object reference not set to an instance of an object The highlighted line is 'ans[1].Question_No = 3; Full error is [NullReferenceException: Object reference not set to an instance of an object] Can anyone help with what stupid thing I am doing wrong? cheers Robert T Turner South Gloucestershire Council

I need to create an unknown number of objects, for example DataReaders at runtime. In c# how would I create these names so that the first is dtrFred1 and the next is dtrFred2 etc. Obvisiuosly this will be in the form of a loop. In JScrpit/JavaScript one could use the eval() command, how is this achieved in c# Robert T Turner South Gloucestershire Council

<%# DataBinder.Eval(Container.DataItem,"title")%>

<%#DataBinder.Eval(Container.DataItem,"ward")%>
In the code behind I want to set the datasource property of the repeater control. I have be trying to use the FindControl("rptWards") but I can't seem to get the right combination. Repeater rptTemp = new Repeater(); rptTemp = (Repeater)dlstConsultation.FindControl("rptWards"); rptTemp.DataSource=dvwWards; Error on line (rptTemp.DataSource=dvwWards) is 'Object reference not set to an instance of an object' I am coding in c#, can anybody point me in the right direction Robert T Turner South Gloucestershire Council

Is there a way adding to the list of formats supplied on the autoformat list? Robert T Turner South Gloucestershire Council

Microsofts IE Treeview Web Control is nice and smooth in working until you put in AutoPastBack = True. The section of the screen that holds the treeview then refreshes/flashes everytime a level is selected. I put the autopostback to true so that I could use the OnSelectedIndexChange. The event does not fire at every level but the screen refresh does. My code in the event is very simple: public void TreeView_SelectedIndexChanged(object sender,Microsoft.Web.UI.WebControls.TreeViewSelectEventArgs e) { lblTitle.Text = "Fred"; } private void InitializeComponent(){ this.TreeView2.SelectedIndexChange += new Microsoft.Web.UI.WebControls.SelectEventHandler(this.TreeView_SelectedIndexChanged); this.Load += new System.EventHandler(this.Page_Load); } Is there something I am missing so that the screen refreshes only when the event method is actioned. Robert T Turner South Gloucestershire Council