|
I would like to ask if how Linq works in mvc 5 for visual studio? can you post some image or some step or code?
|
|
|
|
|
Hi, I am trying to create a report in Asp.net using report viewer and passing parameters. I have created the report (.rdlc) with Dataset with parameter that points to a function in DomainService. The function returns IQuerable from SQL server. I use that report in an .aspx page. When I launch the page it repeats the first record 5 times (there should be 5 different records). I'm sure I am missing something. Any ideas? Thank you!
here is html for page...
<body>
<form id="form1" runat="server">
<div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" InteractiveDeviceInfos="(Collection)"
WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="650px">
<LocalReport ReportPath="Construction\Reports\Test1.rdlc">
</LocalReport>
</rsweb:ReportViewer>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
</div>
</form>
</body>
here is vb.net code behind page...
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
Dim projectjey As Integer = Request.QueryString("projectkey")
ReportViewer1.LocalReport.DataSources.Add(New ReportDataSource("DataSet1", New ENGINEERSDevEntities1().spCNSTBidProposalReportByProjectKey(projectjey)))
Dim rptParameters As New ReportParameter()
rptParameters.Name = "projectkey"
rptParameters.Values.Add(projectjey)
ReportViewer1.LocalReport.SetParameters(rptParameters)
ReportViewer1.LocalReport.Refresh()
End If
End Sub
|
|
|
|
|
Got it to work, I needed to set up the datasource on the web page with an asp: EntityDataSource...
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" InteractiveDeviceInfos="(Collection)"
WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="636px">
<LocalReport ReportPath="Construction\Reports\CNSTReportProposalByProjectKey.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="EntityDataSource1" Name="DataSet1" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:EntityDataSource ID="EntityDataSource1" runat="server"
ConnectionString="name=ENGINEERSDevEntities1"
DefaultContainerName="ENGINEERSDevEntities1" EnableFlattening="False"
EntitySetName="vwCNSTBidProposalReportByProjectKeys">
</asp:EntityDataSource>
</div
|
|
|
|
|
hi, i have a hard problem with linq and asp.net
i have 3 table
(table1 = person)(table2 = equipment)(table3= ralation on person and equipment)
i have a page with a search button and a checklistboxthat bind with equpments
i want that user select one or more check list and then show persons that have those equipments
i create this page with elements and attach on this post
technology : Linq
please help
thanks
-------------------------
table 1
p_famil p_code
ali 1
reza 2
mohamad 3
kazem 4
---------------------------------
table 2
e_code e_title
1 home
2 car
3 job
--------------------------------
table 3
er_eq_code er_per_code
2 1
3 1
1 2
1 4
be happy
|
|
|
|
|
Hi,
Can you try the following, I have not tested this.
List<int> selectedEquipments = new List<int>();
//get the the selected values in this list
var query =
from t3 in table3
where t3.er_eq_code.Contains(selectedEquipments)
join t2 in table2 on t3.er_eq_code equals t2.e_code
join t1 in table1 on t3.er_pr_code equals t1.p_code
select new {t1.Name, t2.b, t2.c, t1.d, t1.e}; // Use your column names here
Hope this helps you.
modified 8-May-14 4:25am.
|
|
|
|
|
object[] obj = new object[2];
obj[0] = UserNameTextBox.Text;
//obj[1] = PasswordTextBox.Text;
obj[1] = FormsAuthentication.HashPasswordForStoringInConfigFile(PasswordTextBox.Text, "sha1");
SqlTransaction tran;
if (Business.CN_String.State == ConnectionState.Closed)
Business.CN_String.Open();
tran = Business.CN_String.BeginTransaction();
//business.select(tran, "check_login", obj);
DataSet ds = (DataSet) business.select_pera("check_login", obj);
---------
ERROR HERE
string type = ds.Tables[0].Rows[0]["Type"].ToString();
------------
tran.Commit();
Business.CN_String.Close();
Session.Add("Naitik", UserNameTextBox.Text);
Session.Add("Naitik1", "LoginUser");
if (Session["Naitik2"] == "WithoutLoginUser")
{
Response.Redirect("~/General/Product.aspx");
}
if ((Boolean)ds.Tables[0].Rows[0]["Authentication"] == true)
{
if (type == "admin")
Response.Redirect("~/Admin/Home.aspx");
else
//Response.Redirect("~/User/Home.aspx?userName="+UserNameTextBox.Text);
Response.Redirect("~/User/Home.aspx");
}
else
{
Response.Write("<script>alert('Please Check Your Email For Varification')</script>");
}
|
|
|
|
|
Your check_login procedure is not returning any rows.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
hi, i'm trying to develop dynamic profiles in which, the .aspx page will be created on signup.. i've already done the creating part.. and it is working fine, Now what i want to do is, i want my pages to be extensionless... like..
i want www.myurl.com/Profiles/sample.aspx?id=profilename to be like this www.myurl.com/profilename
where Profiles is folder and sample is an .aspx page residing in Profiles.
i'm using IIS 7, can any 1 tell me what should i do to achieve this? Thank U
|
|
|
|
|
For restful urls, use friendlyurls nuget package.
For your custom url needs like www.myurl.com/profilename, use and configure routing table.
You might wish to google on routing in asp.net.
|
|
|
|
|
how to use nuget package please explain...
|
|
|
|
|
|
You can create an algorithm to encrypt the QueryString parameter and same algoritm to decrypt the query string parameter on the requested page.
|
|
|
|
|
I am using a GoDaddy's smtpou.secureserver.net account to sending email by SMTP client from asp.net website. I have cross checked all almost all the key values and setting for SMTP but application still throw an exception at production server however the same code and logic working fine at my local machine.
Error message:
"System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 173.201.192.101:25 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)"
on sending third or 4th email.
It seems it does not connecting to server(remote machine). The emails sent perfectly earlier and i have not change any setting at the server side however getting the error again and again.
below are lines of code which i am using to send email by SMTP Client..
string SMTP_UserName = ConfigurationManager.AppSettings["SMTP_Username"].ToString();
string SMTP_Password = ConfigurationManager.AppSettings["SMTP_Password"].ToString();
string SMTP_Server = ConfigurationManager.AppSettings["SMTP_Server"].ToString(); ;
string SMTP_SSLRequired = ConfigurationManager.AppSettings["SMTP_SSLRequired"].ToString();
string SMTP_Displayname = ConfigurationManager.AppSettings["SMTP_Displayname"].ToString();
string SMTP_Port = ConfigurationManager.AppSettings["SMTP_Port"].ToString();
SmtpClient sClient;
NetworkCredential SMTPUserInfo = new NetworkCredential(SMTP_UserName, SMTP_Password);
//MailMessage mMessage = new MailMessage(From, emailTo, emailSubject, emailBody);
MailMessage mMessage = new MailMessage();
MailAddress mafrom = new MailAddress(From, SMTP_Displayname);
mMessage.From = mafrom;
if (lstTo != null && lstTo.Count > 0)
{
foreach (var item in lstTo)
{
if (item.ToString() != string.Empty)
{
mMessage.To.Add(item.ToString().Trim());
}
}
}
mMessage.Subject = emailSubject.Trim();
mMessage.Body = emailBody.Trim();
if (lstCC != null && lstCC.Count > 0)
{
foreach (var item in lstCC)
{
if (item.ToString() != string.Empty)
{
mMessage.CC.Add(item.ToString().Trim());
}
}
}
mMessage.Headers.Add("Message-Id", String.Concat("<", DateTime.Now.ToString("yyMMdd"), ".", DateTime.Now.ToString("HHmmss"), ">"));
mMessage.IsBodyHtml = true;
sClient = new SmtpClient(SMTP_Server);
sClient.Port = Convert.ToInt32(SMTP_Port);
if (SMTP_SSLRequired == "0")
{
sClient.EnableSsl = false;
}
else
{ sClient.EnableSsl = true; }
sClient.UseDefaultCredentials = true;
sClient.Credentials = SMTPUserInfo;
sClient.Timeout = Convert.ToInt32(ConfigurationManager.AppSettings["SMTPTimeOut"].ToString());
sClient.Send(mMessage);
// sClient.SendAsync(mMessage, null);
result = true;
any help would be greatly appreciated.
A lot of thanks in advance.
|
|
|
|
|
|
This problem might be caused due to port is not opening for the mail server SMTP, check the firewall setting
|
|
|
|
|
consider i have a two table in Database. if i want to bring first column of both table in the single grid view table that has to be displayed in the user screen, how do i do that..?
|
|
|
|
|
|
|
consider i have 3 table. the solution i need is
T1 C1-T2 C2 = T3 C3
T- Table C- column
i tried this but doesnt work
SELECT advamt,expamt,balance from [advance],[expense],[details] where (advamt-expamt)=balance;
|
|
|
|
|
Sorry for the late reply.I didn't get quite clearly but you have to try something like this
select T1.C1,T2.C2,T3.C3 from Table1 as T1 inner join Table2 as T2
on T1.id = T2.id inner join Table3 as T3 on T2.id =T3.id
Use the common columns in between two tables to make joins for your query
You have to learn to think like a computer or teach him to think like a human.
-Kornfeld Eliyahu Peter
|
|
|
|
|
thanq so much. 
|
|
|
|
|
I have a scatter chart plot in my project. The values to plot contains double values with less precision like 72.34, 70.43 etc.. But when plotted the values on the label is showing 72.34857554748 which look wierd. Could anyone please help me how to resolve this.
|
|
|
|
|
Can any one send me the code for asp.net life insurance project please.pleasesend it me to varunk1109@gmail.com
|
|
|
|
|
This is not the type of place where you would post such a request, this is a place where people help each other out with problems. You must make some sort of attempt to solve your own problem.
If you need help designing or implementing an insurance system, hire a consultant. If this is a homework assignment, then start doing your own work.
The folks here are very knowledgeable and very helpful, but you must make an attempt to solving your problem.
Good luck.
|
|
|
|
|
Message Removed
modified 24-Apr-14 6:41am.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
