Re: what is trace listeners - ASP.NET Discussion Boards

Morgs Morgan4-Jun-10 2:37

4-Jun-10 2:37

Hi guys,
I have three different queries and i would like to put them as one huge query.
This will reduce the number of times i make a connection to Sql Server and hence load
time on my page.
I have already managed to put two queries like:

SELECT COUNT(Cellsmart_ussd.dbo.ussd_log.[msisdn]) AS totentries,
(
   SELECT COUNT(ussd_clean.dbo.ster_vouchers.sent) FROM ussd_clean.dbo.ster_vouchers 
   WHERE [sent] = '1' AND [sent_date] BETWEEN @start AND @end
) AS [totsent]
   FROM [Cellsmart_ussd].[dbo].[ussd_log]
   WHERE [request] = '*120*789#'

But i also want the query below to be part of the two subqueries above^:

SELECT COUNT([ussd_clean].[dbo].[unique_codes].[msisdn_pair]) AS tota FROM [ussd_clean].[dbo].[unique_codes]
WHERE [msisdn_pair] != '' AND [used] = '1'

Unfortunatly I can't use INNER JOINS because all these single queries refer to
different databases and tables.

Please help me D'Oh! | :doh:

Thanks, Morgs

Re: Subqueries

Peace ON4-Jun-10 2:47

Peace ON

4-Jun-10 2:47

You can join all the three queries as following.

SELECT COUNT(Cellsmart_ussd.dbo.ussd_log.[msisdn]) AS totentries,

(
   SELECT COUNT(ussd_clean.dbo.ster_vouchers.sent) FROM ussd_clean.dbo.ster_vouchers 
   WHERE [sent] = '1' AND [sent_date] BETWEEN @start AND @end
) AS [totsent],

(
SELECT COUNT([ussd_clean].[dbo].[unique_codes].[msisdn_pair]) FROM [ussd_clean].[dbo].[unique_codes]
WHERE [msisdn_pair] != '' AND [used] = '1'
) AS tota

   FROM [Cellsmart_ussd].[dbo].[ussd_log]
   WHERE [request] = '*120*789#'

It is in the same manner as you joined the first two query.

Also, please post database related question in General Database[^] section.

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Re: Subqueries

Morgs Morgan4-Jun-10 4:17

Morgs Morgan

4-Jun-10 4:17

hey thanks Jinal, that code worked and am so impressed now...thanks again

what is trace listeners

somasekhara7774-Jun-10 2:16

somasekhara777

4-Jun-10 2:16

hello my dear...
what is trace listeners and where we use this, and i know about <trace>

j somasekhar

Re: what is trace listeners

Peace ON4-Jun-10 2:28

Peace ON

4-Jun-10 2:28

Is is really so hard to find on google or bing ??

Try following link...

http://msdn.microsoft.com/en-us/library/b0ectfxd.aspx[^]

http://www.15seconds.com/issue/020910.htm[^]

http://dotnetslackers.com/community/blogs/bmains/archive/2006/09/06/Trace-Listening-in-ASP.NET-Applications.aspx[^]

Please refer this[^] guideline before posting your question.

And first try on google or some other popular search engine then post the question.

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Re: what is trace listeners

Not Active4-Jun-10 2:29

Not Active

4-Jun-10 2:29

Here[^]

I know the language. I've read a book. - _Madmatt

Re: what is trace listeners

JHizzle4-Jun-10 2:44

JHizzle

4-Jun-10 2:44

somasekhara777 wrote:
hello my dear...

That's a bit creepy

somasekhara777 wrote:
what is trace listeners and where we use this, and i know about <trace>

I can't add much to the previous 2 posts but: what are you hoping to achieve essentially? It may be that you need this, it might be that you don't but please post the scenario that you're working with so that we can advise.

Re: what is trace listeners

Jamil Hallal4-Jun-10 4:28

Jamil Hallal

4-Jun-10 4:28

One of the most useful debugging features of .NET Framework is Trace type (or class in C++). Functionally Trace is very similar to Debug type (and they share most of internal implementation), but unlike its Debug sibling that is supposed to be used only during debugging sessions, Trace functions can be compiled into a program and shipped to customers, so in case your users encounter a problem, they can activate trace by simply editing application configuration file.

Trace is easy to use and fully documented in .NET Framework documentation, so I will only briefly go through the basic trace features.

Refer to :
Writing custom .NET trace listeners[^]

http://www.codeguru.com/csharp/.net/net_debugging/tracing/article.php/c5919/NET-Tracing-Tutorial.htm[^]

Regards,
Jamil

IE8 on Windows 7 Does not Respond

Vimalsoft(Pty) Ltd4-Jun-10 2:15

Vimalsoft(Pty) Ltd

4-Jun-10 2:15

Good Day All

i have a machine that i use as a server, the machine is running Windows 7 and IIS 7. I am using Windows Xp and my browswe is IE8.

In my application i use Infragistics menu controls. The menu freezes, and they dont respond or calloapse. I have tried the Compatibility mode but it still does that.

Thanks

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: IE8 on Windows 7 Does not Respond

Vimalsoft(Pty) Ltd6-Jun-10 21:27

Vimalsoft(Pty) Ltd

6-Jun-10 21:27

Good Day All

I have found the Problem was not on Infragistics. I think someone who does the same as i do will have this problem. To Resolve the Problem i went to the IIS Manager -->Collapse the the tree and select the Application Pools-->In the Managed Pipeline Mode, it was Integrated, i changed it to Classic and it worked.

Thanks

what is the difference between appsettings and connectionstring

somasekhara7774-Jun-10 1:40

somasekhara777

4-Jun-10 1:40

hello my dear...
i have a doubt that in web.config file we can give database connection in

<appsettings> and also give in
<connectionstring>

what is the difference between both of them
please clarify my doubt
thanking you
yours
somasekhar

j somasekhar

modified on Friday, June 4, 2010 7:49 AM

Re: what is the difference between appsettings and connectionstring

Not Active4-Jun-10 1:55

Not Active

4-Jun-10 1:55

There is no doubt, you can use either appSettings or connectionStrings. ConnectionStrings has built in support in the ConfigurationManager class where as using the appSettings you have to do yourself. Also, connectionSettings is where other components will look by default for connection information.

I know the language. I've read a book. - _Madmatt

Re: what is the difference between appsettings and connectionstring

somasekhara7774-Jun-10 2:17

somasekhara777

4-Jun-10 2:17

thank you my dear

j somasekhar

Excel to sqlserver

amina894-Jun-10 0:54

amina89

4-Jun-10 0:54

Hi,

I have excel files where the teachers include student marks.
Excel files have these columns:
Id_Student ____libelle_matter1____libelle_matter2
how to import these files to table review(Id_Student,id_matter,marks)
I have the table matter: (id_matter, libelle_matter,coeff)??

Thanks.

Re: Excel to sqlserver

walterhevedeich4-Jun-10 1:31

walterhevedeich

4-Jun-10 1:31

Use import/export wizard of SQL server(http://msdn.microsoft.com/en-us/library/ms140052.aspx[^]). There's a feature there where you can map the fields from your excel spreadsheet to the fields of your table.

Re: Excel to sqlserver

amina894-Jun-10 2:00

amina89

4-Jun-10 2:00

Hi,thanks walterhevedeich
I want the teacher clicks on a button to send the files ,import/export wizard is manually, right?

Re: Excel to sqlserver

Sadheesh R7-Jun-10 20:53

Sadheesh R

7-Jun-10 20:53

Here is the C#.NET code...

// Connection String to Excel Workbook
string excelConnectionString = @"Provider=Microsoft .Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";

// Create Connection to Excel Workbook
using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
{
OleDbCommand command = new OleDbCommand ("Select ID,Data FROM [Data$]", connection);

connection.Open();

// Create DbDataReader to Data Worksheet
using (DbDataReader dr = command.ExecuteReader())
{
// SQL Server Connection String
string sqlConnectionString = "Data Source=.; Initial Catalog=Test;Integrated Security=True";

// Bulk Copy to SQL Server
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString))
{
bulkCopy.DestinationTableName = "ExcelData";
bulkCopy.WriteToServer(dr);
}
}
}

show multiple files in a single iframe at once

raghvendrapanda4-Jun-10 0:01

raghvendrapanda

4-Jun-10 0:01

Hy,
I have a requirement in which i have to show multiple files in a single iframe at one go so dat i can print them at a single click without having to open print dialog multiple times.The file type can be .pdf,.xls,.txt ets.
Please help

Is RowEditing Event not required in ASP.Net 2.0?

meeram3953-Jun-10 23:46

meeram395

3-Jun-10 23:46

I have a gridview in my form which I am populating data using SqlDataSource. The gridveiw has insert, update and delete. But somehow I forgot to write the RowEditingEvent.

Upon my surpise, when I clicked on Edit button in the grid while executing, the row automatically become editable. Obviously, I have declared the columns with EditItemTemplate.

Is the RowEditing Event not required when I use ObjectDataSource or SqlDataSource? I couldn't find such event in the msdn example also MSDN Link

Thanks
meeram395.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: Is RowEditing Event not required in ASP.Net 2.0?

walterhevedeich4-Jun-10 0:01

walterhevedeich

4-Jun-10 0:01

Nope its not. There's no such thing as required event in .Net. Events are raised even if there are no handlers to handle them.

http://msdn.microsoft.com/en-us/library/aa645739%28VS.71%29.aspx[^]

Critical decision to be taken by me

Sadheesh R3-Jun-10 23:04

Sadheesh R

3-Jun-10 23:04

Hello team,

I am in a very critical situation, wherein I will have to take an important decision. I have some existing C programs. Those C programs takes input from .DBF (dBase III) files and .BTR (BTRIEVE) files.

I have been given 2 options:

1) Convert .DBF files to .BTR files and .BTR files to .DBF files. These convertion can be done using .NET. If yes, give me some code snippets or some links where I can get the code.
2) Or using .NET is there any other way to replace this BTRIEVE concept itself? In other ways, instead of BTRIEVE, can we go for some other technology?

Pls advise....

Re: Critical decision to be taken by me

Sadheesh R7-Jun-10 20:49

Sadheesh R

7-Jun-10 20:49

Is there anyone who can respond to my query. This is bit urgent...Pls help me out...

Avoiding Button Double Click - AJAX

Karan_TN3-Jun-10 21:31

Karan_TN

3-Jun-10 21:31

currently i m using asp.net 2005 with c# (framework 2.0). i want to restrict the user to click the save button twice or more than that. Using ajax, i implemented it

<ajaxToolkit:AnimationExtender ID="Anibtnsave" runat="server" TargetControlID="btnsave">
                    <Animations>
                    <OnClick>
                      <EnableAction Enabled="false" /></OnClick>
                    </Animations>
                    </ajaxToolkit:AnimationExtender>

the above block will disable the button. its working fine. but i used few validation controls (ajaxToolkit:ValidatorCalloutExtender).
when i click the button the validation pop-ups and also button getting disable. please help me. - KARAN

Re: Avoiding Button Double Click - AJAX

saini arun3-Jun-10 22:20

saini arun

3-Jun-10 22:20

Try this:

private void checkButtonDoubleClick(Button button)
{
System.Text.StringBuilder sbValid = new System.Text.StringBuilder();
sbValid.Append("if (typeof(Page_ClientValidate) == 'function') { ");
sbValid.Append("if (Page_ClientValidate() == false) { return false; }} ");
sbValid.Append("this.value = 'Please wait...';");
sbValid.Append("this.disabled = true;");
sbValid.Append(this.Page.ClientScript.GetPostBackEventReference(button, ""));
sbValid.Append(";");
button.Attributes.Add("onclick", sbValid.ToString());
}

Copied from here
http://forums.asp.net/t/1362149.aspx[^]

Re: Avoiding Button Double Click - AJAX

michaelschmitt4-Jun-10 0:47

michaelschmitt

4-Jun-10 0:47

Nice ideas in this thread. I like.

Last Visit: 31-Dec-99 18:00 Last Update: 21-May-24 11:35

Refresh

ᐊ Prev 1...884 885 886 887888889 890 891 892 893 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.