Hi I'm using Linq to sql with following Connection string "Data Source=sqlAddress;Initial Catalog=DB;Integrated Security=False;User ID=userName;Password=myPass" Program working fine and I can protect code, string in exe using nonreverse protection but how can i protect that connection string from snifers over TCP Thanks

Hi all Now i finished My program, got it's EXE works. is there is any way to get the code from EXE and how to protect my EXE from this Thank you..

I can Enable/Disable Serial Port through device manager. But I have to do it through programming . How can i do that in C#? Thanks in advance Moustafa..

ok, got it solve but it is very straing this not work: -------

var q = (from d in sdc.student
where d.id == 2
select d).FirstorDefault();

try {if (q != null) q.school_ID = null;} cathc{ }

------- following works:

int k = 0;
var q = (from d in sdc.student
where d.id == 2
select d).FirstorDefault();
// make exception Division by constant zero
try {if (q != null) k = 1/k;} catch { q.school_ID = null;}

--------------------------- Really don't know why when write this inside catch{} it works if write outside not work Pleae check Thanks

var q = from d in sdc.student where d.school_ID == 4 select d; q.school_ID = null;

hi have following table student id name school_ID 1 john 5 2 sara 2 3 luije 4 school id name 1 area1 2 area2 3 area3 4 area4 5 area5 need to save "null" to school_ID with student ID(2)..?? thanks in advance

MessageBox.Show(tempnum.ToString()); } //second loop .. .. Remove the '}'

Thank you will try

J4amieC wrote:

Im guessing your field "Location_ID" is an int rather than an int?, in which case the default is 0 which can be assigned to the int? you could try this: int temp = (from s in sdc.Locationswhere s.Name == listViewEx4.Items[i].SubItems[7].Textselect s.Location_ID).SingleOrDefault();int? loct = (temp == 0) ? null : temp;

Hi if no element return from this i need "loct" to be null int? loct = (from s in sdc.Locations where s.Name == listViewEx4.Items[i].SubItems[7].Text select s.Location_ID).SingleOrDefault(); First() return error message Sequence contains no elements SingleOrDefault() return 0 i need null from this sequence how can i do

modified on Wednesday, November 12, 2008 10:46 AM

we devlop program for big ISP company have 3 SQL table Provider Table [Combobox1] ID Name 1 prov1 2 prov2 3 Prov3 //// Location Table [Combobox2] ID Name 1 Loc1 2 Loc2 3 Loc3 //// End_User Table [Listview1] ID Name Provider_ID Location_ID 1 ab 1 2 2 bc 1 3 3 cd null 1 4 de 2 null //// Actually we add "All Provider" to provider combo also "All Lcoation" for location combo to get all even null. value for both "All Provider" & "All Location" set to 0 I can get fill listview user with specific provider like var user = from s in db.End_User where s.Provider_ID == comboprov.value... slect s foreach(....... this good if all location slected in comoboboxlocation or nonvalue select) i need to fill full four condition in this one statement for Linq to sql A- prov = 2 & Loc = 0(all) B- prov = 0(all) & loc = 1 c- prov = 1 & loc = -1(nothinselect) D- prov = -1(nothinselect) & Loc = 3 something like var user = from s in db.End_User where s.Provider_ID = {"*" @(if combopro.value == 0) || combopro.value} + {s.Location_ID = {"*" @(if comboloc.value == 0) || combopro.value} select s. foreach(....... Thank you...

modified on Tuesday, November 11, 2008 10:39 AM