Hi, I just want to know how can i get next value from linq query..this is exactly what i want... in my table i have ID(int),venueID(int),VOM(bit) let say this will be on 1st month... ID : venueID : VOM 1 : 21 : 1 10 : 92 : 0 25 : 102 : 0 on next month i want to set table like this... ID : venueID : VOM 1 : 21 : 0 10 : 92 : 1 25 : 102 : 0 and on 3rd month should be ID : venueID : VOM 1 : 21 : 0 10 : 92 : 0 25 : 102 : 1 like wise VOM value should rotate every month.how can i achieve this from linq... need help...
amalatsliit
Posts
-
how to get next row value -
nettier problem...Hi i have a major problem in nettier framwork...... this is my find method.. TList<ContactDatabase.Domain.Contacts> contacts = ContactDatabase.Domain.Contacts.Find(string.Format("Email = '{0}'", Emailaddress.text)); if (contacts.Count > 0) { } this will nt work if the domain of email has word called "Email"..for example if i search adeam@ozemail.com.au it wont detect from my database.but it works all other emails like these...abla.smrh@bigpond.com.au,aditya@gmail.com,atsnel@yahoo.com.au can u please give me a solution... regards
-
hi i'm having problem with linq query datetime...finally manage to get done the work...maybe this is nt the correct way bt it works fine... var query = from venue in db.Venues where ((venue.ExpiresDate < DateTime.Today.AddDays(1).Date && venue.ExpiresDate > DateTime.Today.AddDays(-2).Date) || (venue.ExpiresDate < DateTime.Today.AddDays(7).Date && venue.ExpiresDate > DateTime.Today.AddDays(5).Date)) && venue.IsDisplay select venue;
-
how to connect to the pop3 server from web pagecan any u provide few examples...
-
how to connect to the pop3 server from web pageHi, I need to develope web site which connect to the pop3 mail server and populate all emails in a grid. so after user can select emails from grid and can delete unnecessary mails through grid. i have search lot of samples most of them are windows based.does any body know or can direct me to correct path. i'm using .net 3.5 with sql server 2008. thankx
-
hi i'm having problem with linq query datetime...hey J4amiec thankx for reply.i hv tried u r solution bt it gives this error Method 'System.TimeSpan Subtract(System.DateTime)' has no supported translation to SQL. ....
-
hi i'm having problem with linq query datetime...hi i'm having problem with linq query... this is what i have var query = from venue in db.Venues select venue; query = query.Where(q =>; SqlMethods.DateDiffDay(q.ExpiresDate, DateTime.Now) == 7); query = query.Where(q =>; q.IsDisplay).OrderByDescending(q =>; q.ExpiresDate); what i want is to populate venues which are expired 7 days from todate..but date formats are different of q.ExpiresDate and DateTime.Now. how to solve this problem...is thr anyway that i can format datetime.now to expiredatetime... need help urgetly...
-
web service problemhi guys i have problem with inter communication of web services... in my solution i have client form(windows project),web service called broker(in web site1) and another two web services A and B (in web site 2). i added web reference of A and B to website 1. also i added web reference of Broker to my windows project. now i just wanna call method in A or B from my client form.to do this i wanna call broker to get URL of A or B. prob:how can i call method of a A(web service) or B(web Service) using that url... can somebody give me a solution....
-
problem in SQL server 2005 desktop engine instalationhi guys' I have repaired my windows xp and i can't reinstall the sql 2005 desktop engine. I have removed all previous installation folders.....but still having prob to install new instance... can someone give me better solution...rather than formatting the xp...
-
how to extract from excel to sql 2005hi guy's , i just want to extract data from my excel sheet to sql server 2005.how do i do this task in asp.net 2.0 please be kindly give me a solution or a sample soon as possible. regards amal
-
prob of Janus controlsDear friends...i'm developing windows base c# application by using Janus controls. In my application i'm use XSD to populate data to various controls. e.g: In my XSD there r 3 tables. 1.tblSales : populate sales person combo 2.tblcustomer : populate customer combo 3.tblItems : Populate items grid when i load particular windows form it takes 1 to 2 minute load.i think this is problem with data binding to controls. therefore does any one know how to reduse this loading time. -- modified at 21:58 Sunday 15th January, 2006
-
how to restrict paste optionhey guys i want to restrict paste option for my textbox control in windows application. how do i do this in c#
-
prob with activexWhen i load dialog box on top of my activex control twice,my web page getting stuck. how can i solve this problem. thanks
-
how to develop run time reportsDear friends, I just want to create run time report in my new asp.net project,which use to print receipts.system should allow user to change the positions of data fields. it should more flexible to change the view of the report at run time... Can any one provide better solution to do this. Thankx
-
prob with developing smart device applicationi just want to develop smart device application to mysql by using c#.i just want to know is thr any mysql provider to do this.currently it support only sql...? Does any one know solution for this. Please let me know soon as possible. thankx Amal
-
IE PluginDear friends, i just want to develop IE plugin which should add a item to context menu.or display customized rectangle box when the user right click on some word. can any body knows better solution. Thankx amal
-
Prob with delegatesDear Mike, Thanx for the reply.any way what i want is to create common web page to display all the nesessary data request from other pages.not to create a common function and call it on other pages. i just want to create common data view page for other child pages.so when the user select the filling criteria from child page the top.aspx page have to display the correct data. e.g : say user going to modify the project details.but before that he wants to view entered project details.when he click the button which is in bottom.aspx my common data fill page that is top.aspx should fill out all entered project details. at the movement i use querystring for this.but i think it's not practical for this.. as a another solution i can do this by creating user control also.but i just want to do that another way. Thanx
-
Prob with delegatesDear Mike, Can you please provide me a sample code to do above task.it will more help full for me to complete my task. Thankx Amal
-
Prob with delegatesHello mike, Thank you very much for your answeer.but i have done this by using query string.what i want is to implement common data fill page to all other web ages of my application. you know we can add datagrid individualy by page by page and fill out accourding to parameter fields which we send. In my new web application most of pages has to display entered data from that page.so i want to send these request to one page and fill the DG.also after when user select the griddata,i want to fill out data entry form agin. like :- for the modification.... so this my issue.how can i do this. thankx amal
-
Prob with delegatesIn my Asp.net application i have divided my web form in to 2 colums.top frame will load a page and it has datagrid control.bottom one have a dropdownlist with few codes. iwant to fill my data grid accourding to the change of my DDL. therefore i create a delegate in my top.aspx form and a function to fill data from DB.and i call above function when change the SelectedIndex of my DDL.now my parameter values passed to top.aspx page but can't fill my DG. it gives error called object reference not set..... how can i fill my DG from another page. note:Also these two pages are in two diff namespace.