|
Please give me actual query for following action
I want data from two different database to single table
(as same field name)
ex. database1.table1 as field <name>
database2.table2 as field <name>
result into database1.table3 as field <name>
how to write query
thanking you
abglorie
|
|
|
|
|
| This is ASP.Net forum.It'll be better if you ask your question in "General Database" forum. Cheers!!
Brij
|
|
|
|
|
select *
from FirstDatabase.dbo.Table1 t1
join SecondDatabase.dbo.Table2 t2 on t1.id=t2.id
where (your condition if any)Regards
Keyur Satyadev
|
|
|
|
|
abglorie wrote: Please give me actual query
No, we are not here to do your work.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi all,
I am using Local reports(RDLC) for my reports in Asp.net
I am have the following code in my button.I am able to send my pdf report as mail,and every thing is ok,
But Problem is I am unable to produce a Confirmation message,like "Mail sent successfully".How could i change my code.Pls help me Very Urgent.
Here it is skipping message.I am directly getting preview and sending mail.
Private Sub BTN_ITCLETMAIL_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTN_ITCLETMAIL.Click
Dim PrefAddrid As String = DDL_COMMUADDRS.SelectedValue
Dim rep As LocalReport = ReportViewer2.LocalReport
Dim Balmail As New Bal_EmailForm
RegisNum = Trim(LblItcRegNum.Text)
Dim conn As New SqlConnection(conString)
Dim da As New SqlDataAdapter
Dim ds As New ReportDataSource
Dim row As GridViewRow = Nothing
Dim Chkcount As Integer = 0
Dim intStatus As Integer
' ''For PDF
Dim warnings As Warning() = Nothing
Dim streamids As String() = Nothing
Dim mimeType As String = Nothing
Dim encoding As String = Nothing
Dim extension As String = Nothing
Dim bytes As Byte()
Dim FolderLocation As String
'Dim FLAG_VIE_REPORT As String
'' ====================
FolderLocation = Path.GetTempPath
Dim filepath As String = FolderLocation & RegisNum & "ITCLetter.pdf"
Try
File.Delete(filepath)
Session.Contents.Remove("Error")
rep.ReportPath = System.AppDomain.CurrentDomain.BaseDirectory & "ReportRdlcs\ITCLetter.rdlc"
Dim cmd As SqlCommand = New SqlCommand("RepGetOnlyAdderssDataForDemandLetter", conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@RegistrationNumber", RegisNum)
cmd.Parameters.AddWithValue("@PrefContactAdderss", PrefAddrid)
da.SelectCommand = cmd
myDataSet.Clear()
da.Fill(myDataSet, "RepGetOnlyAdderssDataForDemandLetter")
ds.Name = "AddressDetforDemandLetter_RepGetOnlyAdderssDataForDemandLetter"
ds.Value = myDataSet.Tables(0)
rep.DataSources.Add(ds)
Dim params(3) As Microsoft.Reporting.WebForms.ReportParameter
Dim strDemStudName As String = Nothing
strDemStudName = Trim(LBL_CLIENT.Text)
Dim p1 As Microsoft.Reporting.WebForms.ReportParameter
p1 = New Microsoft.Reporting.WebForms.ReportParameter("Name", strDemStudName)
params(0) = p1
Dim strDemAccountNum As String = Nothing
strDemAccountNum = Trim(TXT_ITCACCNUM.Text)
Dim p2 As Microsoft.Reporting.WebForms.ReportParameter
p2 = New Microsoft.Reporting.WebForms.ReportParameter("ITCAccountNum", strDemAccountNum)
params(1) = p2
Dim strDemOutstandingamt As String = Nothing
strDemOutstandingamt = Trim(TXT_ITCAMTOUTSTAND.Text)
Dim p3 As Microsoft.Reporting.WebForms.ReportParameter
p3 = New Microsoft.Reporting.WebForms.ReportParameter("ITCAmtOutstanding", strDemOutstandingamt)
params(2) = p3
Dim strCurrentDate As String = Nothing
strCurrentDate = Format(Convert.ToDateTime(dbToday.fdate), "dd MMMM yyyy")
Dim p4 As Microsoft.Reporting.WebForms.ReportParameter
p4 = New Microsoft.Reporting.WebForms.ReportParameter("CurrentDate", strCurrentDate)
params(3) = p4
If myDataSet.Tables(0).Rows.Count > 0 Then
Hidecontrols.Value = 1
ReportViewer1.Visible = False
ReportViewer2.Visible = True
ReportViewer2.LocalReport.SetParameters(params)
'' ''For PDF Conversion
bytes = ReportViewer2.LocalReport.Render("PDF", Nothing, mimeType, encoding, extension, streamids, warnings)
Dim fs As New FileStream(FolderLocation & RegisNum & "ITCLetter.PDF", FileMode.Create)
fs.Write(bytes, 0, bytes.Length)
fs.Close()
Response.ContentType = "application/pdf"
Response.WriteFile(FolderLocation & RegisNum & "ITCLetter.PDF")
''For Sending mail
Balmail.ToAddress = Trim(TXT_StudItcEmail.Text)
Balmail.BccAddress = Trim(TXT_StudItcBCc.Text)
Balmail.CCAddress = Trim(TXT_StudItcCc.Text)
Balmail.Subject = Trim(TXT_ItcSubject.Value)
Balmail.Message = Trim(TXT_ItcBody.Value)
Balmail.Attachementone = FolderLocation & RegisNum & "ITCLetter.PDF"
intStatus = Balmail.SendMailNew()
If intStatus = 0 Then
Dim strScript As String = "<script type=text/javascript language=javascript defer=defer>;"
strScript += "myAlert('Management College of Southern Africa', 'Mail Sent Successfully', 'return false;');"
strScript += "</script>"
Page.ClientScript.RegisterStartupScript(Me.GetType(), "myAlert", strScript)
End If
Response.End()
Else
Hidecontrols.Value = 0
End If
Catch SqlExep As SqlException
s = "An SQL Server 2005 Exception Has Occured At: " + "<br>" + "<b>" + "Method Name & File Path & Line Number:" + "</b>" + Space(5) + SqlExep.StackTrace.ToString + "<br>" + "<b>" + "Error Description:" + Space(5) + SqlExep.Message + "</b>"
Session("Error") = s
Catch IOExep As IOException
s = "An IO Exception Has Occured At: " + "<br>" + "<b>" + "Method Name & File Path & Line Number:" + "</b>" + Space(5) + IOExep.StackTrace.ToString + "<br>" + "<b>" + "Error Description:" + Space(5) + IOExep.Message + "</b>"
Session("Error") = s
Finally
If Not (Session("Error") = "") Then
Response.Redirect("../Exception_Throw.aspx")
End If
RegisNum = ""
End Try
End Sub
Regards,
Narendra.S
|
|
|
|
|
do one thing see the code and match your code (code is in C# syntax).
//code
public static bool SendMail(string FromEmail, string FromName, string ToEmails, string MailBody, string Subject, string CcEmails, string BccEmails, bool IsBodyHtml)
{
try
{
System.Net.Mail.MailMessage objMail = new System.Net.Mail.MailMessage();
//Mail From Field
if (!String.IsNullOrEmpty(FromName))
{
objMail.From = new MailAddress(FromEmail, FromName);
}
else
{
objMail.From = new MailAddress(FromEmail);
}
//Mail To Field
if (!String.IsNullOrEmpty(ToEmails))
{
objMail.To.Add(ToEmails);
}
//Mail Cc Field
if (!String.IsNullOrEmpty(CcEmails))
{
objMail.CC.Add(CcEmails);
}
//Mail Bcc Field
if (!String.IsNullOrEmpty(BccEmails))
{
objMail.Bcc.Add(BccEmails);
}
//Mail Subject Field
objMail.Subject = Subject;
//Mail Body Field
objMail.Body = MailBody;
objMail.IsBodyHtml = IsBodyHtml;
try
{
SmtpClient smtp1 = new SmtpClient();
smtp1.Send(objMail);
return true;
}
catch (Exception ex)
{
//HttpContext.Current.Response.Write(ex.Message.ToString());
return false;
}
}
catch (Exception ex)
{
string mess = ex.Message.ToString();
return false;
}
}
// now in your code if its return true then fire your script. it will show the message as if your script is without error.Regards
Keyur Satyadev
|
|
|
|
|
Hi,Thanks for reply,
I am able to view message in other situations like inserting or updatating tables.
I am unable to get message in this particular scenario,when i render a rdlc report into pdf.
Regards,
Naren
|
|
|
|
|
Hi,
I want to select directory using fileupload or button(if possible). But using File Upload control it goes enter into that selected directory for file. I want to reach upto only that perticular selected directory.
How can I do this??
Thanks
sjs
|
|
|
|
|
You can not select a directory.This is file upload control,we can just files only.
Also Have alookCheers!!
Brij
|
|
|
|
|
i agree there is no such facility with fileupload control...
|
|
|
|
|
yes  Cheers!!
Brij
|
|
|
|
|
Hi,
i just upload a ms document file from my local system. when i clicking on go button. its automatically convert into pdf format using pdf995. its working fine in my local system.
But its not working in server
suddenly displayed the foolowing error:
{Retrieving the COM class factory for component with CLSID {16AA0B9E-79AC-43B5-86CA-AB961FBEED5F} failed due to the following error: 80040154. }
could you please give me the possible answerYours,
KaNNaN
-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"
|
|
|
|
|
have a look to the following links.
Link 1
Link2 Cheers!!
Brij
|
|
|
|
|
PDF CONVERSION
Dim filesource As Object ="\\192.168.0.1\d\kannan\document\test.doc"
Dim app As New Word.Application
Dim missingValue As Object = Type.Missing
Dim ac As New Word.Application()
Dim myTrue As Object = True
Dim myFalse As Object = False
Dim document As New Word.Document
app = ac.Application
app.DisplayAlerts = Word.WdAlertLevel.wdAlertsMessageBox
document = app.Documents.Open(filesource, myTrue, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue)
app.ActivePrinter = "PDF995"
'app.ActivePrinter = "PrimoPDF"
app.ActiveDocument.PrintOut(myFalse, myFalse, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue, myFalse, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue, missingValue)
document.Close(missingValue, missingValue, missingValue)
app.Quit(missingValue, missingValue, missingValue)
OPEN WORD DOCUMENT
Dim WordApp As New Word.ApplicationClass()
Dim missing As Object = System.Reflection.Missing.Value
Dim fileName As Object = TextBox2.Text
Dim newTemplate As Object = False
Dim docType As Object = 0
Dim isVisible As Object = True
Dim aDoc As Word.Document = WordApp.Documents.Add(fileName, newTemplate, docType, isVisible)
WordApp.Visible = True
aDoc.Activate()
this function all r working fine in local system. if i can using in iis showing COM errors....Yours,
KaNNaN
-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"
|
|
|
|
|
Hi all,
Right now i am working on some S/W developement and in my project i want
to move columns of gridview to rightside or leftside at runtime and this gridview is generated at runtime.
so any one who has any suggestions on this pls reply....
Thank U
|
|
|
|
|
| do you want to move the columns in the same grid or in another grid? Cheers!!
Brij
|
|
|
|
|
|
Suppose I have a server control which executes some javascript function on every page postback. For the sake of simplicity, let's say it renders like this:
My control
<script type="text/javascript">window.alert('My control is in the page');</script>
This, of course, works, a popup window is displayed on every postback. Now imagine that the control is nested in an UpdatePanel control. Then the popup is displayed on full page postbacks, but not on partial postbacks where only the UpdatePanel is refreshed (although the javascript is still rendered to the page, it is not executed).
My question is: How do I execute some javascript function on truly every postback, partial or full? It is obvious that "standard" methods for such scenario, like RegisterClientStartupScript, are out of the question.
(As an example, if I want to write my own Timer server control, I need the execute some javascript which after some time interval causes postback. This is easy with full page postbacks, when this javascript is normally executed, but when the Timer is in UpdatePanel (and enabled during partial postback), I need to run the javascript after the partial postback, which I cannot see how.)modified on Tuesday, February 16, 2010 3:30 PM
|
|
|
|
|
|
Thanks, this helped a lot. I also learned that ScriptManager.RegisterStartupScript method simplifies this functionality.
H
|
|
|
|
|
Hello friends,
Hope u r doing good.
I have a scenario as following:
We have two dropdown lists and left menu on the master page. We have 7 content pages based on the master page.
After the selection of two dropdown lists, the menu will be populated. Once the menu populates, the menu will have links to 7 content pages.
When we click on the links in the menu, the dropdowns should not be refreshed (Master Page content should not be refreshed), Only the content of the content page should be displayed in the content area without refreshing the whole master page.
Whenever we click on other content page link, only the content place holder area should be replaced without refreshing everything on the page. We want to hold the values of dropdown lists while loading the content pages.
Any Ideas how to acheive this?
Thank you in Advance,
Raheem MA
|
|
|
|
|
i can suggest u better if u put html snippet here.
what i understand is u can use html iframe control to load different pages inside page without refreshing the page.you just need to change "src" property of iframe.
|
|
|
|
|
you can use the update panel with conditional mode. it is better way as user fill that the entire page is not refresh. put the update panel in both master page and all content page and set the mode conditional. now when you want to update any panel just write
updatepanel1.update() method. this is easiest way to achieve as per me.
hope this will help you.Regards
Keyur Satyadev
|
|
|
|
|
I dont think it'll work.because he wants to update only the content page mot master.But every page(content page) has a different URL/page and the whole page will get refreshed when we'll be changing the url.
Please correct me if I am wrong.Cheers!!
Brij
|
|
|
|
|
Thank you for your quick responses.
Any way to acheive my required functionality?
Thank you in advance,
Raheem MA
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
