|
How m i going to test this kind of function?
private void saverecord()
{
OleDbConnection savecon = new OleDbConnection(constring);
OleDbCommand savecom = new OleDbCommand("insert into Employee_Details values (?,?,?)", savecon);
OleDbParameter param;
param = savecom.Parameters.Add("@empcode", OleDbType.VarChar, 10);
param.Value = txtcode.Text;
param = savecom.Parameters.Add("@empname", OleDbType.VarChar, 25);
param.Value = txtname.Text;
param = savecom.Parameters.Add("@empjoin", OleDbType.Date);
param.Value = DateTime.Now.ToShortDateString();
savecon.Open();
int rows = savecom.ExecuteNonQuery();
MessageBox.Show(rows.ToString() + "rows affected");
btnref.PerformClick();
savecon.Close();
}
[TestMethod()]
public void saverecordTest()
{
Form1_Accessor target = new Form1_Accessor(); // TODO: Initialize to an appropriate value
target.saverecord();
//Assert.Inconclusive("A method that does not return a value cannot be verified.");
}
|
|
|
|
|
Hi,
I am trying to enable password recovery, with the following settings:
<membership defaultprovider="SqlMembershipProvider" userisonlinetimewindow="15">
<providers>
<clear />
<add name="SqlMembershipProvider">
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="Gendac.Grintek.Abatis.DataAccess.Properties.Settings.PerimeterMainConnectionString"
applicationName="Abatis ClientUI"
enablePasswordRetrieval="true"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
requiresUniqueEmail="false"
passwordFormat="Encrypted"
minRequiredPasswordLength="3"
minRequiredNonalphanumericCharacters="0"/>
</add></providers>
</membership>
I know that I have to change the default machineKey, but I don't know how.
I think the machine key must be set in one of the files in C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG, but I don't know where and how.
Any help would be much appreciated.
This is my error:
You must specify a non-autogenerated machine key to store passwords in the encrypted format. Either specify a different passwordFormat, or change the machineKey configuration to use a non-autogenerated decryption key
Kind regards,
Higs
|
|
|
|
|
|
|
mostafatajamolian wrote: please give me code
Read the documentation[^] and try it yourself 
I are troll
|
|
|
|
|
Well, you could do this using regular expressions, but personally I'd write a little function which iterates over the string and works it out (using StringBuilder) - that'd be quite a bit quicker.
Regards,
Rob Philpott.
|
|
|
|
|
easy...
string text = "abokf.okhj.jkoklk.";
string start = "ok";
string end = ".";
string replace = "D";
string answer = "abokD.okD.jkokD.";
console.WriteLine(answer);
of course you could optimise it...
console.WriteLine("abokD.okD.jkokD.");
...or perhaps you wanted something different 
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
You sarcastic bunch!
This is a really difficult problem (if you have no experience and your IQ is smaller than your shoe size) so give the chap a break.
Just because it would take us less than a minute to complete (or two if we did it manually, rather than use built in members) doesn't mean we should take the piss out of really lazy students who want us to do thier homework for free.
So, the complete solution:
string s = "abokf.okhj.jkoklk.";
string startString = "ok";
string endString = ".";
string replacementString = "D";
while (ReplaceAllIncidencesOfDataDelimitedByTwoStringsWithAnotherStringForReallyLazyStudentsWithNoIdeaNoExperienceAndAnIQSmallerThanTheirShoeSize(ref s, startString, endString, replacementString))
{
}
Console.Writeline(s);
Obviously, you will need the method "ReplaceAllIncidencesOfDataDelimitedByTwoStringsWithAnotherStringForReallyLazyStudentsWithNoIdeaNoExperienceAndAnIQSmallerThanTheirShoeSize" and it is here, with all the others:
http://PleaseDoMyHomeworkForMe.com/ComputerProjects/UnbelievablySimple/Index.html
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced
|
|
|
|
|
|
I created an Animal class, then I created a Dog class and a Cat class that inherited from the Animal class. Then the Dog class ate my homework.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
|
Hi
Wonder if anyone out there can help me.
I have been working on retrieving data from xls files using ole and have had no problems until i received a file that is causing me considerable greif.
The file in question is 26k in size and is a simple headed workbook with 2 pages.
When I connect to the file and try to retreive schema info (using schema = GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" })) no table rows (pages) are found (ie schema.Rows is null).
If I open the file in Excel and click on the save button (without making any changes) the file grows by 10k in size and the data can then be retrieved without any problems!!???
Has anyone out there ever experienced an issue of this nature and if so, could you possibly explain what is making this happen.
Many thanks in advance to anyone who can help,
Steve 
|
|
|
|
|
Now you begin to understand why most devs avoid Excel like the plague. We force the supplier to send us CSV files, this would mean you get 2 files for multiple pages.
Excel OLEDB connections are too fragile in my opinion, you have no control over the excel sheet, I could go on for many additional reasons not to use Excel. This is not helping you, sorry.
You may end up in the position where you need to read in each cell from each sheet.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I work with this:
conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables_Info, null);
check the excel version maybe it is related
Natza Mitzi
|
|
|
|
|
{"DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'UserId'."}
|
|
|
|
|
It looks like you have a control (e.g. GridView) for which you have specified a column with the DataItem UserId but the UserId does not exist in the object you are binding to the gridview. Check your gridview data source contains a UserId column/property.
|
|
|
|
|
The answer is the same as it was yesterday. And the day before.
You need to do three things:
- Read what people have said.
- Take action based upon it.
- Discover magical fairy la la land where your grade school code works.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
|
It means you're too stupid to use a computer. Put it in it's box, take it back to the store, and choose a different course.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
You really need to read the answers from your last post. And get a book about data binding!
|
|
|
|
|
It means the psychic link has failed to update your code to supply a UserId.
"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
|
|
|
|
|
The error code will be 119047 (convert it to hexadecimal to read it). It means that something bad happened. Don't panic, if it doesn't run well it probably won't be shipped (unless the lead developer is the CEO's relative) and people won't have to maintain it
Additional option: plug the error message into Google
Final option: blame someone else. It works in government all the time
|
|
|
|
|
|
Just use a loop to read out the array and add every element to the existing string.
|
|
|
|
|
string[] arr = new string[] { "one", "2", "three", "IV" };
string x = String.Join("\", \"", arr);
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
