.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

PLZ help me Does not know how to do this thing(very important for me)

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :Sql Server
 
Hi. Even does not know if this forum is the suitable I have sql table with "division" i have column " name division " and "code division" ok. NAME DIVISION CODE DIVISION TRANSPORT 1000 ELECTRICITY 2000 AND THIS DATA DISPLAY IN COMBOBOX. Now User wont to add new company UNDER DIVISION "TRANSPORT" he is select in combobox value " TRANSPORT" AND CODE 1000 OK NOW I NEED AUTOMATICLY TO GIVE NEW (show to user in textbox) CODE TO COMPANY for example 1000\1 because he chose transport division (code division 1000) but before i give the new code to new company i need to check if not already company with identical code if not to take a last company with 1000\n and add 1 example 1000\n+1  and put the new company name with new code  1000\n+1 to some table in sql or acces. IN THE END I NEED TO PUT INTO THE TABLE THIS VALUES COMPANY NAME COMPANY CODE TRANSAUTO 1000\1 EUROTRANS 1000\2   Diagram like this I have code 1000 now I go in to sql table CUSTOM2 and seeks a company with code 1000\max_num after obtained the company with the maximum code I adds to the code + 1(1000\max+1) and display the cod in new text box/ Request will help me very important matter for me. I h


View Complete Post


More Related Resource Links

PLZ help me.Does not know how to do this thing(very important for me)

  
Hi. Even does not know if this forum is the suitable I have sql table with "division" i have column " name division " and "code division" ok. NAME DIVISION CODE DIVISION TRANSPORT 1000 ELECTRICITY 2000 AND THIS DATA DISPLAY IN COMBOBOX. Now User wont to add new company UNDER DIVISION "TRANSPORT" he is select in combobox value " TRANSPORT" AND CODE 1000 OK NOW I NEED AUTOMATICLY TO GIVE NEW (show to user in textbox) CODE TO COMPANY for example 1000\1 because he chose transport division (code division 1000) but before i give the new code to new company i need to check if not already company with identical code if not to take a last company with 1000\n and add 1 example 1000\n+1  and put the new company name with new code  1000\n+1 to some table in sql or acces. IN THE END I NEED TO PUT INTO THE TABLE THIS VALUES COMPANY NAME COMPANY CODE TRANSAUTO 1000\1 EUROTRANS 1000\2   Diagram like this I have code 1000 now I go in to sql table CUSTOM2 and seeks a company with code 1000\max_num after obtained the company with the maximum code I adds to the code + 1(1000\max+1) and display the cod in new text box/ Request will help me very important matter for me. I h

Wicked Code: 3 Important Tips For Silverlight Development

  

As a Web platform, Silverlight should be fast. Don't keep your users waiting by not heeding these performance tips.

Jeff Prosise

MSDN Magazine March 2009


important

  
 i have 3 dropdown lists for birthdate one for the day, month and the third for the year and i want to store the date of birth of the user how can i make that,please????????????

Important events in a calendar

  
Hi all forum   I am using an asp calendar which mark the current day with a certain color. But I wish to extend this functionality. I wish to assign certain important events will happen in the future and highlight their days, and when the user clicks this certain day he will be directed to the page of the event.In other words If today is 7-9-2010 it is already highlighted in my calendar I wish to high-light  15-9-2010 cell and may write some tip with it  and when the user click on 15-9-2010 cell he will be directed to events.aspxalso How about binding it to a sql table containing events and the events diplayed highlighted. as if it is a gridview binding to a datasource and on its row command event some funtions will happen

Strange thing in my db!

  
I have a problem that I never have had before. I'm inserting ip, datetime when user fails to log in. It has been working great until today. Now it gets inserted but only one time, if same ip fails to log in the only thing that changes is date and time. Before there was a new record inserted, thats what I want to do so I can count the fails from every ip. can you please help me with this? I don't get any errors.SQL ALTER PROCEDURE LoginAddLogin @ip VARCHAR(25) AS INSERT INTO Login(LoginDate, Ip) VALUES(GETDATE(), @ip)  public static bool AddLogin(string ip) { // get a configured DbCommand object DbCommand comm = GenericDataAccess.CreateCommand(); // set the stored procedure name comm.CommandText = "LoginAddLogin"; // create a new parameter DbParameter param = comm.CreateParameter(); param.ParameterName = "@ip"; param.Value = ip; param.DbType = DbType.String; param.Size = 25; comm.Parameters.Add(param); // result will represent the number of changed rows int result = -1; try { // execute the stored procedure result = GenericDataAccess.ExecuteNonQuery(comm); } catch { // any errors are logged in GenericDataAccess, we ignore them here }

Windows forms important question

  
Hi, I have a windows forms application with a number of forms. I have added a new form to it and now i want this form to appear first at runtime. Actually the new form that i added is a mainn menu form so that is why i wanted it to appear first at runtime. Please tell me how can i make this main menu form to appear first at runtime. Thank you, Syed

Session cast - loss of session? and other weird thing :D

  
Hey all..I have a 2 questions (yes they should be in 2 seperate posts)1.) (more of a statement) when I was on my windows XP pro with asp.net 4.0 installed - I was able to use "response"  in the global.asax ......now that I have windows 7 with asp.net 4.0 I come up with an exception (which is odd) and yes i know it should come up with an exception  it just doesnt make sense why it works on my old 32bit system2.) when I call a static method in a class to  create a dataset in the "session_start" section of the "global.asax" - it creates a dataset and stores it as a session for the userwhen im any web page - and cast the session to a dataset - it works... but when I refresh the page - the session is lost.... any ideas why?

Did a dumb thing with Sql Server Loging IS / Offline / Single Integrated User / sa disabled [dumb?]

  
Have been using a single database (targetDb) outside of the master with Integrated Security Fairly new installation.... sa login is not enabled (?) Default database for my integrated ID is this "targetDb" And then took targetDb "offline", instead of Detaching during a machine swap process. No I can get in to the server/database, because the IntegratedWindowsLogin cannot login, because the tragetDb (default database) is offline.  sa cannot login, either - because is is not active. What do we do?  Travis McGee

Calender control. Displaying important dates.

  
I have a calender control tht you can click on. When you click on a date you see all the events that happens that date. But i want the calender to show what dates have events. I want these dates to have a seperate styling. In the code behind i catch the DayRender event. I have a list will all important dates called "eventDates".   if (eventDates.Contains(e.Day.Date) == true)         {             Calendar1.SelectedDates.Add(e.Day.Date);                       }   if (eventDates.Contains(e.Day.Date) == true)        {            Calendar1.SelectedDates.Add(e.Day.Date);                     }Ive stepped through this method and its triggered once for every day of the month and the dates are addes succesfully. Ive also changed the SelcetedDates property in the mark up, like this: <SelectedDayStyle BackColor="AliceBlue" BorderColor="Red" />But nothing happens. I was hopping that the important dates in the calender would turn into blue background with red borders. I know its sounds horrible but i just wanted to really see if i could make it work. But as i said, nothing ha

can't show any thing else except img in datalist

  

Plz need urgent help

can any one tell me why my datalist or any other data control can't show any thing except img 

m using following code 

<asp:DataList ID="DataList2" runat="server" DataSourceID="ObjectDataSource5"
RepeatColumns="2" RepeatDirection="Horizontal" ShowFooter="False"
ShowHeader="False" Width="181px">
<ItemTemplate>
<img src='../Pics/<%#Eval("cmupic")%>' height="80px" width="80px" />
  <%#Eval("cmunam") %>
</ItemTemplate>
</asp:DataList>
<asp:ObjectDataSource ID="ObjectDataSource5" runat="server"
SelectMethod="dspjoncmu" TypeName="snetwork.clscmu">
<SelectParameters>
<asp:SessionParameter Name="prfcod" SessionField="cod" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>

cmunam is not visible

 not even a static string is visible


i tried other controls as well but no solution

changed the place of data control but still problem is unsolved 


MBSA claims .NET needs important update

  

Windows XP SP3

No one of all apps installed on this machine needs the .NET environment.

Some version of .NET framework was installed in the far past for one app.

But now not any more. Neither that app nor .NET installed any more.

Control Panel -> Add & Remove Programs - no .NET items visible

 

Astebner's .net clean-up and verfification tools applied more times.

 

Anyhow, the MBSA and 3rd party AV solution claim the machine needs an important

.net framework security update.

 

I wish to prevent MBSA, the AV and all similar solutions from notifying me of it.

I want to prevent them from that by completely removing .NET - non-present stuffs do not need any updates at all -

the simplest approach. But my all previous removal attempts apparently didn't succeed.

 

How to clean up this machine from all .NET versions?

The machine should be free of .NET because no one application needs it.


Important: ASP.NET Security Vulnerability

  
A few hours ago we released a Microsoft Security Advisory about a security vulnerability in ASP.NET.  This vulnerability exists in all versions of ASP.NET. This vulnerability was publically disclosed late Friday at a security conference.  We recommend that all customers immediately apply a workaround (described below) to prevent attackers from using this vulnerability against your ASP.NET applications. What does the vulnerability enable? An attacker using this vulnerability can request and download files within an ASP.NET Application like the web.config file (which often contains sensitive data). At attacker exploiting this vulnerability can also decrypt data sent to the client in an encrypted state (like ViewState data within a page...(read more)

Important: Windows App deployment

  

Hi Friends,

I have to deploy a windows application on windows 7 home premium OS PC and i want this PC to act as a server or a database server where different PC's have an application installed on them and access the common database on the windows 7 PC through the application.

There are 2 scenarios that i have to implement

1. I can allow the user to work in a LAN and use the application from a maximum of 5-6 PC's .

2. I should also allow the users to work with the applicaion remotely from their laptops outside of the LAN. In this case, the application will be installed on the laptops but the database will be on the Windows 7 PC . 

Thanks and please help me on how to implement this.

Syed


Important: Deployment of Windows app

  

Hi Friends,

I have to deploy a windows application on windows 7 home premium OS PC and i want this PC to act as a server or a database server where different PC's have an application installed on them and access the common database on the windows 7 PC through the application.

There are 2 scenarios that i have to implement

1. I can allow the user to work in a LAN and use the application from a maximum of 5-6 PC's .

2. I should also allow the users to work with the applicaion remotely from their laptops outside of the LAN. In this case, the application will be installed on the laptops but the database will be on the Windows 7 PC . 

Thanks and please help me on how to implement this.

Syed


Upload Multiple: Works on some machines, not others. An Office 2010 thing? No? What's up?

  

Greetings,

We've received some feedback that Upload Multiple Files only works on some machines, for some people, and not on/for others. Tracking down this challenge, it seems that machines with Office 2010 have components that allow the Upload Multiple functionality to work, as machines with Office 2007 and prior are not working with Upload Multiple.


EDIT:  Multiple Upload works SOMETIMES on Non-Office 2010 machines with the following interface: http://img100.imageshack.us/i/muv2.jpg/  and ALWAYS on Office 2010-equipped machines with this interface: http://img819.imageshack.us/i/muv1.jpg/


This thread: http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/2decb33d-9e66-408c-b010-701b2fb4269f  may confirm my suspicion, but the relevant post is vaguely worded (doesn't specify office versions) and so it's hard to tell for sure.

Can someone please confirm, or suggest what else might potentially be going wrong?

Thanks!

--Dave


Are there any such thing as a class level try/catch?

  

Does anyone have any idea on how to handle a try/catch at a class level or Property level where a lot of coding isn't needed? I am using MVVM for my project.

Let's say you have Class A with 10 to 15 properties and in each property the data model that the ViewModel is binded to may or may not throw an exception depending upon certain criteria. How do I handle that, instead of writing a try/catch block in every setter of the properties?

The data models' properties setter may throw an exception and I want to find the cleanest way to handle it.

Any suggestion is much appreciated.

Thanks,


Better way to get the same thing? ODER BY / GROUP BY ??

  

Ok...so we are doing some crime comparisons for areas of the city...and want to get the list of the top 10 bad areas by a type for 5 crime types.

The query i use is as follows :

--DOPERS
select top 300 COUNT(*) as Total, Beat AS SubZone, LEFT(Beat,1) AS DISTRICT
from v_nopjf_crview
where TimeCreate >= '2010-01-01'
 and type like '966'
group by beat
order by total DESC 
--ACCIDENT
select top 300 COUNT(*) as Total, Beat AS SubZone, LEFT(Beat,1) AS DISTRICT
from v_nopjf_crview
where TimeCreate >= '2010-01-01'
 and (type like '20' or type like '100')
group by beat
order by total DESC 
--ACCIDENT(INJURY)
select top 300 COUNT(*) as Total, Beat AS SubZone, LEFT(Beat,1) AS DISTRICT
from v_nopjf_crview
where TimeCreate >= '2010-01-01'
 and (type like '20I' or type like '100I' or type like '20F' or type like '100F')
group by beat
order by total DESC 
--PERSONS
select top 300 COUNT(*) as Total, Beat AS SubZone, LEFT(Beat,1) AS DISTRICT
from v_nopjf_crview
where TimeCreate >= '2010-01-01'
 and (Type like '%30%' or Type like '42' or Type like '42d' or Type like '43'
 or Type like '43d' or Type like '64j' or Type like '64' or Type like '64g'
 or Typ

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend