|
a) Don't -- never put data access in your UI layer.
b) Once you have a Data Access Layer -- access it from your UI layer.
|
|
|
|
|
do it like this.. 
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
namespace Access
{
public class Connection
{
private string getConnectionString()
{
return "connetionString";
}
public static void ExecuteCommand(string command)
{
OleDbConnection con;
OleDbCommand com;
try
{
con = new OleDbConnection(getConnectionString());
con.Open();
com = new OleDbCommand(command);
com.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
}
}
//Call Connection Method
public void MyMethord()<br />
{<br />
Connection.ExecuteCommand("command write here");<br />
}
|
|
|
|
|
public void connection()
{
con = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=practice;Data Source=HOME-78F3176757");
con.Open();
}
public DataSet filldata(string mystring)
{
connection();
adp = new SqlDataAdapter(mystring, con);
ds = new DataSet();
adp.Fill(ds);
return ds;
}
|
|
|
|
|
Hi experts,
I am under the impression that .NET programs (C# with VisualStudio 2008) always compile to an executable (programname.exe) and a settings file (programname.exe.config). Sometimes there is more to a program, but these two persist. They end up being in the same directory.
I logged on to a WinXP Prof as Admin and installed a .NET program. This program allows to store some data in its programname.exe.config file, which resides in %PROGRAMFILESFOLDER%/Programname/ anlongside with programname.exe.
To 'store' means to
Properties.Settings.Default.MyIntValue = 25;
Properties.Settings.Default.Save();
here.
I ran the program, it worked as expected. Then I logged out and back on as restricted user. The program still worked like a charm.
If I understand correctly, changing and saving in Settings.Default.* is achieved by changing programname.exe.config. How can it be that restricted user is allowed to do so? He's not allowed to change any file through notepad.
And, will this stay possible in Windows Vista and 7?
Or will I have to re-direct the settings file somehow to some %APPSETTINGS% directory for those?
Ciao,
luker
|
|
|
|
|
You cannot. It resides on users computer and he can change the file. One of the options is to get rid of the setting itself. If it is an important value, why keep it in open?
Settings are to make the application configurable which you do not want.
|
|
|
|
|
Hi,
there are two kinds of settings.
1.
Application settings are the same for all users, and they cannot be changed by the app itself. Those are stored in the appname.exe.config file. You can edit the file with e.g. WordPad, other than that the information could as well have been stored inside the exe file itself.
2.
User settings are individual, they can be changed by the app itself. Those are stored twice: the default value is present in the appname.exe.config file (just like app settings), and it is read-only; the actual value chosen by the user however is stored in a similar file (named user.config) in a subfolder of the user's personal folder (that is under Documents and Settings on older Windows versions, and under Users since Vista).
So file appname.exe.config can be write protected, no problem; the user's folders should be (and normally are) fully accessible by their owner.
It is of course explained in the MSDN documentation, starting here[^].
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Thanks a lot, Luc.
You have enlightened what was one of universe's mysteries to me for months.
And, of course MSDN features an article on the topic, but it focuses on how to use settings while leaving out how the framework achieves this behaviour. Thank you for your additional information.
Ciao,
luker
|
|
|
|
|
You're welcome.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Hi can anyone tell me, how to bind a data to class objects from a list, so that i can pass it in xml request..
here is my code in xsd generated class.
<pre>public partial class SetValue
{
private string dANameField;
private string dAIDField;
private SetValueType setValueTypeField;
public string DAName
{
get
{
return this.dANameField;
}
set
{
this.dANameField = value;
}
}
public string DAID
{
get
{
return this.dAIDField;
}
set
{
this.dAIDField = value;
}
}
public SetValueType SetValueType
{
get
{
return this.setValueTypeField;
}
set
{
this.setValueTypeField = value;
}
}
}
[System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "2.0.50727.3038")]
[System.SerializableAttribute()]
[System.Diagnostics.DebuggerStepThroughAttribute()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Xml.Serialization.XmlTypeAttribute(AnonymousType = true, Namespace = "http://xml.abc.com/ns/msjava/lrm")]
[System.Xml.Serialization.XmlRootAttribute(Namespace = "http://xml.abc.com/ns/msjava/lrm", IsNullable = false)]
public partial class SetValueType
{
private string valueTypeIDField;
private string valueTypeField;
private string valueField;
private Function functionField;
private Field fieldField;
public string ValueTypeID
{
get
{
return this.valueTypeIDField;
}
set
{
this.valueTypeIDField = value;
}
}
public string ValueType
{
get
{
return this.valueTypeField;
}
set
{
this.valueTypeField = value;
}
}
public string Value
{
get
{
return this.valueField;
}
set
{
this.valueField = value;
}
}
public Function Function
{
get
{
return this.functionField;
}
set
{
this.functionField = value;
}
}
public Field Field
{
get
{
return this.fieldField;
}
set
{
this.fieldField = value;
}
}
}</pre>
here i have to do something, so that i can add the data in this list to class type(SetValueType), so that later i will convert it into xml format..
<pre> SetValue DAESetvalue = new SetValue
{
DAID=oSetValue.DAID,
DAName=oSetValue.DAName
};
DADirective.SetValue = DAESetvalue;
List<SetValueType> SetValueTypeList = new List<SetValueType>();
GetValueTypeCondition(gValueTypeCondition,SetValueTypeList);
public void GetValueTypeCondition(Grid gValueTypeCondition,List<SetValueType> SetValueTypeList)
{
int rowcount = 0;
if (gValueTypeCondition.RowDefinitions != null)
rowcount = gValueTypeCondition.RowDefinitions.Count;
for (int i = 0; i < rowcount; i++)
{
SetValueType oSetValueType = new SetValueType();
foreach (UIElement element in gValueTypeCondition.Children.Cast<UIElement>().Where(element => Grid.GetRow(element) == i))
{
if (element is ComboBox)
{
ComboBox cbvaluetype = (ComboBox)element;
if (cbvaluetype.Uid != null)
{
Object obj = ((ComboBoxItem)(cbvaluetype.SelectedItem)).Tag;
if (obj != null)
{
if (cbvaluetype.Uid == DataKey.FUNCTION_KEY)
{
DAFunction dafunction = (DAFunction)obj;
oSetValueType.ValueTypeID = "2";
oSetValueType.ValueType = "Function";
oSetValueType.Function.FunctionID = dafunction.FunctionID;
oSetValueType.Function.FunctionName = dafunction.FunctionName;
oSetValueType.Function.DataType1 = dafunction.DataType1;
oSetValueType.Function.DataType2 = dafunction.DataType2;
oSetValueType.Function.DataType3 = dafunction.DataType3;
}
else if (cbvaluetype.Uid == DataKey.COLUMN_CONDITION_KEY)
{
DAColumn dacobj = (DAColumn)obj;
oSetValueType.ValueTypeID = "3";
oSetValueType.ValueType = "Field";
oSetValueType.Field.FieldID = dacobj.id;
oSetValueType.Field.FieldValue = dacobj.name;
}
}
}
}
else if (element is TextBox)
{
TextBox txtValueType = (TextBox)element;
switch (txtValueType.Uid)
{
case DataKey.TEXT_VALUE_KEY:
oSetValueType.ValueTypeID = "1";
oSetValueType.ValueType = "Value";
oSetValueType.Value = txtValueType.Text.Replace("_", "").Trim();
break;
case DataKey.TEXT_FUNCTION_VALUE_KEY:
oSetValueType.Function.FunctionValue = txtValueType.Text.Replace("_", "").Trim();
break;
}
}
}
SetValueTypeList.Add(oSetValueType);
}
}</pre>
so any help like how to do it...
|
|
|
|
|
Hi,
I want to remove "Back-Slashes \" from string.
Kindly note the following example.
string strText = "(0,2,\"\",\"113.07\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\")";
Thank you
|
|
|
|
|
try the String replace method
this is the MSDN for it
|
|
|
|
|
I tried following method but it does'nt work.
strText = strText.Replace('\',String.Empty);
strText = strText.Replace(('\').ToString(),String.Empty);
|
|
|
|
|
You need to use the double backslash (single backslash in a string is the escape mark) and also use a String rather than character, thus:
strText = strText.Replace(("\\"), String.Empty);
See here[^] for full details.
The best things in life are not things.
|
|
|
|
|
use Replace to do it
string strText = "(0,2,\"\",\"113.07\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\")";
strText = strText.Replace("\\","");
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.cacttus.com
|
|
|
|
|
There are no backslashes in that string. \" is a quote.
|
|
|
|
|
Process is same what blueboy ellastrate.
|
|
|
|
|
Are you sure you want to remove the \'s, they are actually what allows you string to contain the character: "
You can't remove those because \" really means " in the string. If they were \\ it would mean \. So why are you trying to remove the characters that aren't even there?
Craigslist Troll: litaly@comcast.net
"I have a theory that the truth is never told during the nine-to-five hours. "
— Hunter S. Thompson
|
|
|
|
|
Hi every1,
I am building button dynamicaly and m trying to add the button id to a new ajaxupload.js(thebuttonid).. bt these does not help cos it not working..any1 pls help..
|
|
|
|
|
What C# code have you got?
|
|
|
|
|
else {
strEdit = "";
delet = "";
rtf = "<img src=\"images/rtf.png\" title=\"Download Conditions\" style=\"Border:0\"></img>";
}
var t = ("<tr class=\"displ\"><td id=\"brh\" style=\"display:none\">" + data[i].BRH_ID + "</td><td>" + data[i].var_deedOf + "</td><td align=\"left\">" + data[i].lib_name + "</td><td>" + data[i].lib_modifiedBy + "</td><td><a href=\"#\" id=\"download\" libid=\"" + data[i].lib_id + "\" class=\"link\">" + rtf + "</a><a id=\"uploadfile\" href=\"#\" class=\"link cl\" libid=\"" + data[i].lib_id + "\" deedsoffice=\"" + data[i].var_deedOf + "\">" + strEdit + "</a><a id=\"del\" href=\"#\" class=\"link\" libid=\"" + data[i].lib_id + "\" >" + delet + "</a></td></tr>");
$("#Result").append(t);
so m trying to bind
id=\"uploadfile\" to
new ajaxupload('#uploadfile'{ which is a jquery ajaxupload.. and i know Pete that this is th wrong forum for the question but i trust u guys 
|
|
|
|
|
You aren't going to get an answer for a JavaScript question in a C# forum. You acknowledge this yourself so why did you post it in this forum.
|
|
|
|
|
I will use fileUpload control.
Fileupload control has textbox(display file path) and button(text is Browser).
And i want to edit button's text from Browser to Search.
and i want to edit textbox from displaying file's path to only filename.
How can i do?
hi
My english is a little.
anyway, nice to meet you~~
and give me your advice anytime~
|
|
|
|
|
AFAIK you can not change these things in FileUpload control. You will have to write your own control or use a third party control for this.
|
|
|
|
|
A couple of things.
First, this is the C# forum. Your question has nothing to do with C#. You should have asked it in the web development forum.
Second, you cannot modify the file browse control. It is sandboxed for security, so you have no access to the constituent parts through JavaScript.
You may want to consider a third party alternative.
|
|
|
|
|
Hey you can try the jquery ajaxupload.js, it myt solve your problem..
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
