from A in dataClass.vwPLANODINs
join B in dataClass.LANCADAs on new { A.Codplano, Data = data }
equals new { Codplano = B.Subord, Data = Convert.ToString(B.Data) } into B_join
from B in B_join.DefaultIfEmpty(new LANCADAs{Data == null})
select new
{
A.Codplano,
A.Secao,
A.Setor,
A.Subsetor,
A.Contato,
Situacao = (B.Subord ?? "N/A")
};

something like this will work.

You can use IComparer or IComparable interface to compare the list of objects.

i have chechked several time sthe code is correct.evwerythinworks finebut the error comes at line:

return DAC.SelectDS("insertreg", dbparamcoll);

afterb this line the control skip to exception block.

i have a stored procedure named insertreg: DELIMITER $$DROP PROCEDURE IF EXISTS `naukri4u`.`insertreg`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `insertreg`(emailaddress varchar(50),firstname varchar(50),lastname varchar(50),username varchar(50),password varchar(50),conformpassword varchar(50),mobile varchar(50),currentloc varchar(50),prefferedjobloc varchar(50),gender varchar(50),totalexp varchar(50),industry varchar(50),function varchar(50),keyskills varchar(50),highestqual varchar(50),yearofpass varchar(50),institute varchar(50),resumetitle varchar(50),resume varchar(50)) BEGIN insert into registration(emailaddress,firstname,lastname,username,password,conformpassword,mobile,currentloc,prefferedjobloc,gender,totalexp,industry,function,keyskills,highestqual,yearofpass,institute,resumetitle,resume) values(emailaddress,firstname,lastname,username,password,conformpassword,mobile,currentloc,prefferedjobloc,gender,totalexp,industry,function,keyskills,highestqual,yearofpass,institute,resumetitle,resume); END$$DELIMITER ; i want to submit a regisration form using this stored proc.this registration table have primary key reg_id which auto increments so i have not taken it in my query.the code i have written is:

public DataSet insert(Common.com_registration objcom_reg)
{
registration reg = new registration();
try
{
DbParameter dbparama0 = DAC.Parameter("emailaddress", objcom_reg.Emailaddress, DbType.String, ParameterDirection.Input);
DbParameter dbparama1 = DAC.Parameter("firstname", objcom_reg.Firstname, DbType.String, ParameterDirection.Input);
DbParameter dbparama2 = DAC.Parameter("lastname", objcom_reg.Lastname, DbType.String, ParameterDirection.Input);
DbParameter dbparama3 = DAC.Parameter("username", objcom_reg.Username, DbType.String, ParameterDirection.Input);
DbParameter dbparama4 = DAC.Parameter("password", objcom_reg.Password, DbType.String, ParameterDirection.Input);
DbParameter dbparama5 = DAC.Parameter("conformpassword", objcom_reg.Conformpassword, DbType.String, ParameterDirection.Input);
DbParameter dbparama6 = DAC.Parameter("mobile", objcom_reg.Mobile, DbType.String, ParameterDirection.Input);
DbParameter dbparama7 = DAC.Parameter("currentloc", objcom_reg.Currentlocation, DbType.String, ParameterDirection.Input);
DbParameter dbparama8 = DAC.Parameter("prefferedjobloc", objcom_reg.Prefferedjobloc, DbType.String, Parame

hi am using stored procedure to submit a registration form. i have checked lot of time but get the same error can yuo plz guide me. Message = "Key cannot be null.\r\nParameter name: key"

hi all i have used an open source cms named "kentico cms".i have integrated it locally at my system it successfully exexcuted but when i uploaded it online it is giving me following error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. how can i upload it online.plz help its urgent... the process which i have folowed is corect or wrong.. thanks ....

k thanks...

hi all i am working on a cms project.I want a editor where i can place my content easily along with image also.ajax editor have no such tool for uplaoding image along with text.can anybody guide me plz.thanks....

In my site there is a portal where user can upload the you tube URL in my web page.Once the user will provide the URL of you tube video my intention that i can save the url link in my databse and then i want to show the uploaded videos in my web page.plz guide...thanks

i wan to upload image to a folder.can u give me an idea...thanks

i want to save image in my sql database and also i want to show image from database. what shud i do and how plz guide.m new to win application....

can u suggest some books based on win applications

on menu click i am opening the purchase form and vedor form.i want that when i open vendor/purchase form the previously opened form get closed..

private void addNewVendorToolStripMenuItem_Click(object sender, EventArgs e)
{

        Vendor frm = new Vendor();
        frm.MdiParent = this;
        frm.Show();
      
    }

    private void purchaseToolStripMenuItem1\_Click(object sender, EventArgs e)
    {
        Purchase frm = new Purchase();
        frm.MdiParent = this;
        frm.Show();

    }

i have made one of my form as mdi form. now i am trying to display other form in this form. i want that when new form is loaded the old one hides or get closed.plz guide how to do this. m new to win application.thanks

hii all m new to windows application.I want to create a desktop application but dont have idea where to start with.Can anybody give me any gud link or tutorial or name of ebooks which would help me in my project.however i have worked on web application(asp.net using csharp).plz guide me ...thanks..

As far as i think you can have particular id for each bussiness and according to that id you can dynamically use the connection string as you want.

you can redirect to new site using response.redirect and what exactly you want i dont get you. for trigger just google it.there is lot of matter about trigger....

i agree there is no such facility with fileupload control...

thanks alot...

you can use triggers to generate mails automatically. to redirect to other site jst give Response.Redirect(url)...