|
I am doing a project in .net c# 2.0 with sqlserver2005
i have a listbox in the form in which i need to display some data from database.
i need to get the loginnames of those clients who have levelid= 2 and 3, and who r logged in.
For levelid and logindatetime are stored in 2 different tables 'login' and 'dealerlogin' respectively.
Now to get his data i queried (in sqlserveranalyzer):
select loginname from login as a, dealerlogin as b where ((b.levelid = 2) or (b.levelid = 3)) AND ((a.logindatetime is not null) and (a.logoutdatetime is null))
But there is some error. There is some problem in joining the 2 diff. clauses of 2 diff. tables.
How can i do this?
Hope to get a reply.
regards nekshan.
|
|
|
|
|
How are the two tables related? You are missing a part of your where clause, the part where you must specify a.[Some Column] = b.[Some Column]
|
|
|
|
|
Can you please give me a regular expression in c# to remove single line comments from a string and its urgent
Criteria
a. // text --- Should be removed
b. file:///text.txt -- should be retained
c }//abc -- hear //abc should be removed
Thanks in Advance
Thanks and Regards
Irsh
|
|
|
|
|
Is there any way to get the country names in dot net using the system time zone. Or else, is there any other way to generate the country names.
Regards,
LEE
|
|
|
|
|
Application.CurrentCulture.DisplayName
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
To use this wat namespace we need to specify
Regards,
LEE
|
|
|
|
|
System.Globalization.CultureInfo.CurrentCulture.DisplayName;
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Hi Friend'z...
I want to update the database table from datagrid itself placed on form. how can i do that?
I placed one datagrid,one button for showing table data in datagrid, one update button for updating database.
what i mean is after the table is shown in datagrid, if we change the data in datagrid, then by clicking the update button, the database table should be updated.
pl help me friend'z.......
|
|
|
|
|
update the data source....
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
if u don't know the answer shut up & keep quiet ok? mind it.
|
|
|
|
|
tamimi-code,
i mean to say u only. ok shut up.
|
|
|
|
|
man !!!!!!!!!!!!!!! 
i am trying to help you , idiot.
what is the data source for you data grid ??
just update the data adapter, if it has a valid sql commands
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Tamimi code,
pl mind ur language. ok? then try to help others...
|
|
|
|
|
I can able to view my entire assembly using Lutz Roeder’s Reflector Tool.
.NET Reflector, which is a class browser and decompiler that can examine an assembly and show you just about all of its secrets.
but, How do I encrypt or protect my MSIL and cannot be read? Which means, I would like to completely eliminate the metadata information stored in my assemblies such as class and methods names. I can do so using the obfuscator tools offered by various vendors. But, how do I enforce a restriction on a class or method and all its members by pure code.
Karthik
|
|
|
|
|
You can't, as far as I know. You need to obfuscate the compiled assemblies.
|
|
|
|
|
Thanks for the reply. how do i obfuscate my assembly through code or project settings?
|
|
|
|
|
I guess you could use a Post-build event to call the obfuscator, although I've never done that.
|
|
|
|
|
You cannot remove the metadata information, it's required for the .NET runtime.
What you can do is renaming all yours classes, methods, and variables. One can still get the code, but its nearly impossible to understand it when everything is named a,b,c,...
Obfuscators are tools that automatically do this renaming in compiled assemblies. They also change the assembly in other ways to make it harder to understand; or try to introduce IL constructs that crash the decompiler.
|
|
|
|
|
Is there any free obfuscator tools?
|
|
|
|
|
hi,
xmlDocument doc=new xmldocument();
doc.Load(@"D:\workjjf\scripts\xml\MajorKeys.xml");
if the file doesn't exsist how to handle the error and how to create a root node to enter values..
pls help me
with regards
prasad
|
|
|
|
|
XmlDocument doc=new XmlDocument();
if (File.Exists(@"D:\workjjf\scripts\xml\MajorKeys.xml"))
{
doc.Load(@"D:\workjjf\scripts\xml\MajorKeys.xml");
}
else
{
XmlTextWriter tw = new XmlTextWriter(filename,null);
tw.Formatting = Formatting.Indented;
tw.WriteStartDocument();
tw.WriteStartElement("cd");
tw.WriteStartElement("genre","Rock and Roll");
tw.WriteAttributeString("SKU","3224554");
tw.WriteElementString("artist","Crystal Method");
tw.WriteElementString("title","Crash Vegas");
tw.WriteEndElement();
tw.WriteEndElement();
tw.WriteEndDocument();
tw.Flush();
tw.Close();
}
-----------------------------
In just two days, tomorrow will be yesterday.
|
|
|
|
|
|
Yes. If your array has 20 numbers in it, generate a number between 0 and 19 and use it as an index into that array.
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 )
|
|
|
|
|
Random r = new Random((int) DateTime.Now.Ticks);<br />
yourValue = yourArray[r.Next(yourArray.Length - 1)];
Cheers,
Vikram.
The cold will freeze our stares
We won't care... Join the CP group at NationStates. Password: byalmightybob
|
|
|
|
|
No but you can always post a thread here asking for one.
led mike
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
