|
my sql server procedure is
"
Collapse | Copy Code
CREATE PROCEDURE [dbo].[Attendence]
@EmployeeId int
as
if not exists(select * from TblAttendence where convert(varchar(10) ,CreateDate,23) =convert(varchar(10) ,GETDATE(),23) and EmployeeId =@EmployeeId)
select * from TblAttendence where convert(varchar(10) ,CreateDate,23) =convert(varchar(10) ,GETDATE(),23) and EmployeeId =@EmployeeId
Else
update TblAttendence set LastLoginTime=GETDATE() where EmployeeId=@EmployeeId and convert(varchar(10) ,CreateDate,23) =convert(varchar(10) ,GETDATE(),23)
GO
|
|
|
|
|
Try putting the error in the body of the post and not the heading!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i am working on lexical analyzer phase of compiler construction.... i have written a code that display a that the given number is real if it contain one dot int it but if it contains two dot i does not generate error....
here is my code
bool containReal = ss.Any(char.IsDigit) && ss.Contains('.');
if (containReal)
{
MessageBox.Show("this is a Real Number");
break;
}
string str2 = ss.Substring(1, ss.IndexOf('.'));
string str3 = ss.Substring(ss.IndexOf('.') + 1);
bool chk_dot = (str2.Any(char.IsLetter) || str3.Any(char.IsLetter) || str2.IndexOfAny("!@%^&*()#$-_+<>".ToCharArray()) != -1 || str3.IndexOfAny("!@%^&*()#$-_+<>".ToCharArray()) != -1);
if ( chk_dot)
{
MessageBox.Show("Error: Line num " + linecount + " Invalid b/c of two dots in a real number");
errorcount++;
break;
}
can you help me to correct it......
modified 11-Apr-14 21:26pm.
|
|
|
|
|
Please ask your question in only one place.
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
Cả nhà giúp mình viết code thuật toán này trong c# bằng windows form với!
hương dẫn cụ thể luôn hi.thank nhiều
|
|
|
|
|
This is an English-language site.
Đây là một trang web tiếng Anh.
http://translate.google.co.uk/[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Error msg conveying that a number is invalid because of Two dots within a real number in c#
Anyone can please help me
|
|
|
|
|
Help you with what? All you've given us is a statement that doesn't make any sense and no context information to work with. We have no idea what you're doing, what your code is doing, what you expect it to do, what it's actually doing, any error messages you're getting, ..., absolutely NOTHING to work with.
You've basically walked into a room with a bunch of people who don't know you and said "Error msg conveying that a number is invalid because of Two dots within a real number in c#" and then walked out of the room. Everyone in the room is now thinking "Who the hell was that guy and what was that about?"
|
|
|
|
|
He found another room to mess with ^^
[Flags]
public enum Bool {
True, False, ForSure, Maybe, ProbablyNot, Depends, NotDecidedYet, Undefined
}
private interface IShy { }
|
|
|
|
|
..that kind of error-message yells to me that I should try a number with three dots. And scientific notation. And Little Bobby Tables' age.
What was your question again?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Example:
I take a picture with webcam and save it whit name "A" at desktop (fixed)
How can I open it without using opendialog and select it?
I want to click a button and winform default open image with name "A" and path.
Thanks for your help 
|
|
|
|
|
Then you're going to have to write code to create the filepath to that image. All a OpenFileDialog does is let the user select a file or files and return their filepaths, that's it. It doesn't actually do the "open" operation on the file. That's up to your code.
|
|
|
|
|
Thanks for your guide, but can you give me the code, I am beginner and I can't write the code by myself! I can read the code and try to understand it. Thank you
|
|
|
|
|
Code for WHAT? I have no idea what you're doing or what you need code for. This site is not in the business of writing code for people on demand.
|
|
|
|
|
Hai all,
i need a solution, to download file from google drive using c#.
|
|
|
|
|
|
A classically bad question deserves a classically bad answer[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I need to add deserialized data from xml file to the model in Entity Framework cod efirst in order to generate my database in SQL Server CE.
The problem was that I have two tables , the first was done without problems but when I added the second model I got an exception :
{"Exception has been thrown by the type initializer for 'DAL.MyModel.InformationContext."}
I will be so thankful if someone could help me .
Here my source code in the Program.cs:
using (InformationContext db = new InformationContext())
{
db.Balances.Add(new Balance_Model()
{
EuroBookingBalance = Bal.ElementAt(0).EuroBookingBalance,
Id = Bal.ElementAt(0).Id,
ABI = Bal.ElementAt(0).Account.ABI,
BBAN = Bal.ElementAt(0).Account.BBAN,
CIN = Bal.ElementAt(0).Account.CIN,
Currency = Bal.ElementAt(0).Account.Currency,
Description = Bal.ElementAt(0).Account.Description,
Number = Bal.ElementAt(0).Account.Number,
AccountId = Bal.ElementAt(0).Account.Id,
Date = Bal.ElementAt(0).Date.ToString(),
AccountHolder = Bal.ElementAt(0).Account.AccountHolder,
CAB = Bal.ElementAt(0).Account.CAB,
CurrencyBookingBalance = Bal.ElementAt(0).CurrencyBookingBalance
});
db.Transactions.Add(new Transaction_Model()
{
ABI = tra.ElementAt(0).Account.ABI,
AccountDescription = tra.ElementAt(0).Account.Description.ToString(),
Amount = tra.ElementAt(0).Amount,
TransactionDate = tra.ElementAt(0).TransactionDate.ToString(),
AdditionalDescription = tra.ElementAt(0).AdditionalDescription,
AccountHolder = tra.ElementAt(0).Account.AccountHolder,
CAB = tra.ElementAt(0).Account.CAB,
Currency = tra.ElementAt(0).Currency,
Description = tra.ElementAt(0).Description,
Id = tra.ElementAt(0).Id,
Number = tra.ElementAt(0).Account.Number.ToString(),
ValueDate = tra.ElementAt(0).ValueDate.ToString(),
AbiReason = tra.ElementAt(0).AbiReason.ToString()
});
db.SaveChanges();
Here my Initializer class ;
class DbInitializer : DropCreateDatabaseAlways<InformationContext>
{
protected override void Seed(InformationContext context)
{
string pathXml = @"C:\Users\Mohamed amine sifi\Desktop\balancess.xml";
Balances Bal = new Balances();
XmlSerializer serializer = new XmlSerializer(typeof(Balances), null, null, new XmlRootAttribute("Balances"), "urn:Cedac:WebContoc:Balances:v1");
StreamReader reader = new StreamReader(pathXml);
var xmlReader = XmlReader.Create(reader.BaseStream);
object deserialized = (Balances)serializer.Deserialize(xmlReader);
Bal = (Balances)deserialized;
string pathXmlt = @"C:\Users\Mohamed amine sifi\Desktop\transactions.xml";
TransactionsList tra = new TransactionsList();
XmlSerializer serializert = new XmlSerializer(typeof(TransactionsList), null, null, new XmlRootAttribute("Transactions"), "urn:Cedac:WebContoc:Transactions:v1");
StreamReader readert = new StreamReader(pathXmlt);
var xmlReadert = XmlReader.Create(readert.BaseStream);
object deserializedt = (TransactionsList)serializer.Deserialize(xmlReader);
tra = (TransactionsList)deserializedt;
context.Balances.Add(new Balance_Model()
{
EuroBookingBalance = Bal.ElementAt(1).EuroBookingBalance,
Id = Bal.ElementAt(1).Id,
ABI = Bal.ElementAt(1).Account.ABI,
BBAN = Bal.ElementAt(1).Account.BBAN,
CIN = Bal.ElementAt(1).Account.CIN,
Currency = Bal.ElementAt(1).Account.Currency,
Description = Bal.ElementAt(1).Account.Description,
Number = Bal.ElementAt(1).Account.Number,
AccountId = Bal.ElementAt(1).Account.Id,
Date = Bal.ElementAt(1).Date.ToString(),
AccountHolder = Bal.ElementAt(1).Account.AccountHolder,
CAB = Bal.ElementAt(1).Account.CAB,
CurrencyBookingBalance = Bal.ElementAt(1).CurrencyBookingBalance
});
context.Transactions.Add(new Transaction_Model()
{
ABI = tra.ElementAt(1).Account.ABI,
AccountDescription = tra.ElementAt(1).Account.Description,
Amount = tra.ElementAt(1).Amount,
TransactionDate = tra.ElementAt(1).TransactionDate.ToString(),
AdditionalDescription = tra.ElementAt(1).AdditionalDescription.ToString(),
AccountHolder = tra.ElementAt(1).Account.AccountHolder,
CAB = tra.ElementAt(1).Account.CAB,
Currency = tra.ElementAt(1).Currency,
Description = tra.ElementAt(1).Description,
Id = tra.ElementAt(1).Id,
Number = tra.ElementAt(1).Account.Number.ToString(),
ValueDate = tra.ElementAt(1).ValueDate.ToString(),
AbiReason = tra.ElementAt(1).AbiReason
});
base.Seed(context);
}
}
|
|
|
|
|
And the exception message would be .....?? Without it, there's nothing anyone can do to help you.
|
|
|
|
|
I have a Menustrip, in which there are 2 toolStripMenuItems called File and Help and their fore color is White while back color is a shade of blue
Help in it's dropdown has 4 other toolStripMenuItems, now when i click Help, the 4 items display but their parent toolStripMenuItem(Help) and it's back color goes white.
Can somebody tell me what i can do for it.
|
|
|
|
|
Hi i want to design account class. with lock keyword in withdraw method.
|
|
|
|
|
|
Unless you are using threading within your application, lock is pretty much irrelevant. It will not prevent other instances of your application from making changes, even if they are on the same PC.
However, the MSDN[^] article on lock covers it prety well if you are threading.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Ok, but that's not a question. What do you want to know?
|
|
|
|
|
I am attempting to filter a list, nothing unusual, done it 1000s of times.
List<NBAggDB> lAgg = lNBAgg.Where(x => x.NodeKey.StartsWith(oParentNode.NodeKey)).ToList();
ParentNode is populated and has a NodeKey, lNBAgg is a List<nbaggdb> and is populated and all have valid NodeKeys
Yet I get the following exception an the only null object is x and the following is highlighted by the exception.
x.NodeKey.StartsWith(oParentNode.NodeKey)
{System.NullReferenceException: Object reference not set to an instance of an object.
at Texas.ViewModels.NewBusinessVM.<>c__DisplayClass11.<LoadAggRows>b__10(NBAggDB x)
at System.Linq.Enumerable.WhereListIterator`1.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Texas.ViewModels.NewBusinessVM.LoadAggRows(TreeNodeNB oParentNode)
at Texas.ViewModels.NewBusinessVM.LoadBudgetCells(TreeNodeNB oNode)
at Texas.ViewModels.NewBusinessVM.LoadNodeChildren(TreeNodeNB oParentNode)
at Texas.ViewModels.NewBusinessVM.LoadNodeChildren(TreeNodeNB oParentNode)
at Texas.ViewModels.NewBusinessVM.LoadNodeChildren(TreeNodeNB oParentNode)
at Texas.ViewModels.NewBusinessVM.LoadNodeChildren(TreeNodeNB oParentNode)
at Texas.ViewModels.NewBusinessVM.<LoadNBBudget>b__2(String sErrorMsg, ObservableCollection`1 lResult)
at Texas.DataServices.NBBudgetDS.NBBudgetForPeriodCompleted(Object sender, NBBudgetForPeriodCompletedEventArgs e)
at Texas.TexasSvc.TexasSvcClient.OnNBBudgetForPeriodCompleted(Object state)}
How the hell am I supposed to debug that?
[edit] lNBAgg is populated with null objects  [/edit]
Never underestimate the power of human stupidity
RAH
modified 10-Apr-14 20:38pm.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
