|
Hi,
i have a doubt about how to display a grid view in ASP.NET from SQL server 2012 according to the instruction given by drop down list from multiple tables. For example say, I have created 2 tables Members and Item where Member.Mid=Item.Mid set as primary and foreign key. okay, now my question is how should write or set code for to display according to the value selected from dropdown list in one gridview.
Once again, I want display in one gridview from multiple tables according to the value from dropdownlist...
I am using C# in VS2012 and SQLserver 2012.
Thank you in advance...
S.Thomas.
S.Thomas
|
|
|
|
|
Use a stored procedure which gives you the results back.
To merge the results from multiple tables in a SQL query, you need to use joins[^].
There are furthermore different types of joins:
-inner join[^]
-left join[^]
-right join[^]
-full join[^]
|
|
|
|
|
Hi All,
I want to connect to a SQL Server database saved on URL
database name fc000xststsql01.IVRCallCenterTest
server address http://ma001xsicmw91/IVRControllerAppProd/Home/
what would be the connection string I will use in web config file ?
Thanks
|
|
|
|
|
|
hi Vani,
the examples in these pages are just talking about a SQL Server database that is local on the same hard drive but how to connect to a database on a URL
Thanks
|
|
|
|
|
<connectionStrings>
<add name="REOU_DB" connectionString="Data Source=AMT-03;Initial Catalog=reouLive11-sep-2012;Persist Security Info=True;User ID=sa;Password=amt12345" providerName="System.Data.SqlClient" />
</connectionStrings>
Aatif
|
|
|
|
|
I have an application/Web application on VS2010 , I need to fetch data from Oracle database without having client installed on my VS2010 machine. I have done this in J2EE through connectivity jars available freely. Can anyone please help me how to do this without oracle client. Is there any DLL available which i can add as a reference...
thanks in Advance 
|
|
|
|
|
Add a reference to System.Data.OracleClient.dll which is part of the .Net Framework. Then you can use the System.Data.OracleClient namespace in your project. Note: You'll get a lot of warnings that that is obsolete, but you said you don't want to install the client...
|
|
|
|
|
Thanks Hiller for this quick response, i can't find System.Data.OracleClient.dll while adding the reference.
|
|
|
|
|
|
You can use the Microsoft DLL, but it's been discontinued and no longer supported, or use the Oracle DLL, which is pretty fast in operation. I used the Oracle DLL's, and it took me a couple of days to figure out the whole thing.
I think there was a installation program I had to run on the web server that installed some stuff to connect to the Oracle Server.
ODAC1120320Xcopy_32bit - This program
Oracle.DataAccess.dll
Oracle.Web.dll
a sample connection string, and reader programming. All types, integer, string ended up being just GetValue.
Dim conStr As String = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SQL1.domain.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE))); User Id=RC_PUBLIC_USER; Password=SECURE;"
Dim con As New OracleConnection(conStr)
Dim cmd As New OracleCommand(cmdQuery, con)
cmd.CommandType = Data.CommandType.Text
con.Open()
Dim oReader As OracleDataReader = cmd.ExecuteReader
While oReader.Read()
pI(rC).p_ID = oReader.GetValue(0) 'PN_ID
pI(rC).c_ID = oReader.GetValue(1) 'C_ID
pI(rC).c_Name = oReader.GetValue(2) 'C_Name
Anyways, I really like the Oracle Platform 11.g, hard to understand at first, because they don't use tables, Technically they say there are no such thing as tables. It's really fast, wow
Others told me to use I think ADO, or some other universal way to connect, your choice.
|
|
|
|
|
This IS the best way. Oracle uses local and server settings in a funny way, and the Oracle library uses all that stuff correctly. We use this method a lot - millions of calls per day - and it works great!
|
|
|
|
|
That's good to hear, it was a coin toss in terms of which method to use for me, glad I choose the right one.
I'm happy with it, works great.
|
|
|
|
|
We have code that is both ways right now but we're changing over to the new one whenever we encounter the old one being used. Killing it by attrition.
|
|
|
|
|
|
System.Data.OracleClient.dll is still in some old code. It's pretty easy to switch.
|
|
|
|
|
hi everybody
can anyone let me know what is worker process...and expansion of w3wp...how can i download it?i have VS2010,iis7,SQLSERVER 2008 R2..and win 7 ultimate OS...what is R2 in sqlserver 2008R2
|
|
|
|
|
Member 8701813 wrote: what is R2 in sqlserver 2008R2
There was SQL Server 2008. Afterwards, Microsoft fixed some problems and bugs and released it again but called it
SQL Server 2008 R2, where R2 stands for Release 2.
Member 8701813 wrote: worker process
MSDN - The ASP.Net Worker Process[^]
|
|
|
|
|
Can you please tell me what is SSPI full form in sql server in integrated security?
Thank you,
S.Thomas.
|
|
|
|
|
SSPI - Security Support Provider Interface - Security Support Provider Interface (SSPI) is an API used by Microsoft Windows systems to perform a variety of security-related operations such as authentication.
Refer: MSDN: SSPI[^]
|
|
|
|
|
|
for my page i have 88 CheckBox when the page is load i want set the selected to false. so any one can help me create a for loop when page is load all the checkbox set to false by using
<asp:CheckBox ID="CheckBoxXS" runat="server" Text=" XS" onClick="forXS(this)" class="checkboxS" OnCheckedChanged="CheckBoxXS1_CheckedChanged"/>
function forXS(sender) {
var tb1 = document.getElementById('<%= txtXS.ClientID %>');
tb1.style.display = sender.checked ? 'inline' : 'none';
if (tb1 != null) {
tb1.focus();
ValidatorEnable(document.getElementById('<%= val1.ClientID %>'), sender.checked);
}
}
________________________________________________
can use Java Script fumction for this and call on page load as below: but i dont know how to place inside my script
function UncheckAll(){
var w = document.getElementsByTagName('input');
for(var i = 0; i < w.length; i++){
if(w[i].type=='checkbox'){
w[i].checked = false;
}
}
}
|
|
|
|
|
To set all the checkboxes to false on the whole page, you can use JQuery...
$('input').find(':checked').each(function() { $(this).removeAttr('checked'); });
|
|
|
|
|
|
Hey Everybody.
I have created crystal report in asp.net project in VISUAL STUDIO DOT NET 2010. These reports are running fine when I run the application by pressing F5 in my development machine. But i want to know how to publish these reports to web server.
<%@ Register assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" namespace="CrystalDecisions.Web" tagprefix="CR" %>
The above line will help you to know the version of Crystal Report.
Following ERROR Occurs
Quote: Server Error in '/' Application.
Invalid file name.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Invalid file name.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x800001fb): Invalid file name.]
CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options) +0
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options) +95
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() +270
[CrystalReportsException: Load report failed.]
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() +333
CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) +876
CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename) +84
WebPathLab.AgentList.Page_Load(Object sender, EventArgs e) +504
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
Thanks in advance.
modified 21-Apr-13 21:32pm.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
