|
how to retrieve username and password from database while writing code for login page asp.net
|
|
|
|
|
|
It is a very regular stuff you just need to fire select query to the database table liek
Select * from [TableName] where [UserIdCol]=[UserId] and [PasswordCol]=[Password]
and get the output in the dataset or datatable
if you find any row in the dataset or datatable then allow the user to login and also you have the detail in the row as well
If your problem solve with the solution just coment and provide the rating 
|
|
|
|
|
Hi All,
I am using below method to find the text in the word document and replace.
word.Selection.Find.Execute(ref findText,
ref matchCase, ref matchWholeWord,
ref matchWildCards, ref matchSoundsLike,
ref nmatchAllWordForms, ref forward,
ref wrap, ref format, ref replaceWithtext,
ref replace, ref matchkasdia,
ref matchDiacrities, ref matchAlefHamza,
ref matchcontrol);
However we had a new requirement like searching the text which starts with # and end with #
eg: #name# -- it will be in the word document
In c# we need to get the value "name"
How to achieve this.Please Advice.
Ramkumar
("When you build bridges you can keep crossing them. ")
http://ramkumarishere.blogspot.com
|
|
|
|
|
I found my answer
http://stackoverflow.com/questions/2989194/select-range-by-string
Ramkumar
("When you build bridges you can keep crossing them. ")
http://ramkumarishere.blogspot.com
|
|
|
|
|
I have an asp.net webform which has a div element named 'contents', and a textbox on it. The div is loaded with some html, which I've retrieved into a string in the codebehind file. Inside this html, I need to be able to mark up various bits of text so that when a user clicks them, it sends a message back to the server, which then populates the text box (which is on the same form) with some other data.
The problem I'm having is how best to communicat back to the server- so in the code below,
1) What should the line alert("You clicked " + x); be, so that it uses ajax to call back to the server, sending the parameter 'hello'
2) What method would be invoked on the server? Would it be Page_Load again?
3) After having called the server, what code would I need to popluate the text box without sending back the whole page again (i.e. still using ajax)? The problem is not retrieving the text on the server, let's just say I receive 'hello' as a parameter on the server, and want to send back 'goodbye' to the text box, again using ajax
So my source aspx file has this in it...
<div id="contents" runat="server"></div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
and in my codebehind file in form_load, I have..
System.IO.StreamReader rdr = System.IO.File.OpenText("c:\\myHtmlFile.html");
string s = rdr.ReadToEnd();
this.contents.InnerHtml = s;
the HTML I'm loading into the div element is this
<script type="text/javascript">
function myfunction(x)
{
alert("You clicked " + x);
}
</script>
<p onclick="myfunction('hello')">hello</p>
When the user clicks 'hello', I want TextBox1 to say 'goodbye'. Again, it's the server that has to handle things here, without reposting the webpage though..
Anyone have any ideas? The simpler the better please! thanks in advance!
|
|
|
|
|
|
Say for instance I'm having a table with columns:
Name
Sex
Age
Location
I need to bind this data to a gridview with Templatefield with dropdownlist as ItemTemplate for columns such as Name and Sex and with textbox as ItemTemplate, so that I would be capable of editing the records in the gridview.
Please help me with a sample source code.
Thanks and regards,
Ram
|
|
|
|
|
|
how can i put banner in my website?
|
|
|
|
|
You can use the image control or html tag, and assign a value to src or imageURL that points to the picture file you wish to display.
Then you can move the html code to your desired location on your web page.
|
|
|
|
|
plz use html cmd in asp.net for banner more info w3school.com
|
|
|
|
|
i have 3 dropdown list box 3rd dropdown populate depending on 2nd drop down and 2nd drop down populate depnding on 1st value of drop down in asp .NET C# and the value should be fetched through database.
thanks.
|
|
|
|
|
|
|
I have written a small application to demonstrate this concept of cascading drop-down lists. Just submitted it. will send you the URL once it is published.
Every now and then say, "What the Elephant." "What the Elephant" gives you freedom. Freedom brings opportunity. Opportunity makes your future.
|
|
|
|
|
|
hmm interesting solution rahul....
|
|
|
|
|
Hi ,
We have created a new Webservice , in this service we are using exterenal webservice in this webservice wsdl namespce tage () is empty and getting this error : "Schema item 'import' from namespace ''. The namespace attribute cannot have empty string as its value.could you please assit me
Thanks,
Vinay
Vinay
|
|
|
|
|
Try regenerating the proxy (from the webservice again).
If you use the svcutil command, you can use the /namespace setting to define your own namespace.
Read more about this command tool here[^].
|
|
|
|
|
I am not using any tool to create proxy. I am expecting the proxy to get autogenerated when i do webreference from our project.
what namespace i have to mention in this tag "<xs:import namespace="">" currently which is present as empty in the WSDL we go from external service. For this whether I ave to work anything from our side or I ave to ask the external service guys only to solve this.
Error 1 Unable to import binding '*****' from namespace '******'. App_WebReferences/****/
Error 2 Schema item 'import' from namespace '****'. The namespace attribute cannot have empty string as its value. App_WebReferences/*****/
i am getting above two errors.
Please assist me...
Vinay
|
|
|
|
|
SALAM all. im doing a RESTful web service with ASP.net, and i have a problem when invoking few of web service that i've created. here is the architechture of my solution: BLL ==> i put in it my functions like this:
public static List<transaction> getTransaction(string ID)
{
var query = from v in SMARTDBEntities.Instance.transactions
where v.compteID == ID
select v;
if (query.Count() == 0)
{
return null;
}
else
{
return query.ToList();
}
}
DAL ==> I used generation item to create model.edmx Entity ==> i used POCO generation code to generate entitys from data base.
and in my service.cs classe i put on it my web services like this:
[OperationContract]
[WebInvoke(Method = "GET",
ResponseFormat = WebMessageFormat.Json,
UriTemplate = "Service/transactions/{cptID}")]
public List<transaction> getTransactions(string cptID)
{
return detailCompte.getTransaction(cptID);
}
and to make the response object serializable i add in the poco.context.cs Constructors
this.ContextOptions.ProxyCreationEnabled = false;
Now when i want to call my web service from my browser, an intermittent error appear. sometimes it work and displays for me the list of transaction and sometimes (most of time) it doesn't work, and displays to my an error:
Error 324 (net :: ERR_EMPTY_RESPONSE): The server terminated the connection without sending data.
I'm working with vista pack1
have you any idea for the way to fix this problem. thank youuuuu
zied JOUINI
|
|
|
|
|
Hi,
I've got a problem to manipulate a button outside of a updatepanel. I will try to clarify my problem as good as possible. 
I've got an aspx page, with an usercontrol in it. In the usercontrol there's an updatepanel.
Now, there's a button in the ascx and when the button is clicked, I want to enable a other button on the aspx. So, the button that should be enabled is outside the ascx and the updatepanel. I'm able to call the method in C# to enable the button, but nothings happens. I thank because there's an updatepanel?
Does anybody know how I can fix this?
Thanks in advance!
Mark
|
|
|
|
|
Mark Vlaeminck wrote: the button that should be enabled is outside the ascx and the updatepanel.
Put this button in another update panel. Have a async trigger defined in it for previous button click. This would complete the design. Now, whenever the button1 is clicked, this update panel will be invoked and refreshed.
|
|
|
|
|
Hi! I am trying to change the checked attribute of dynamically created html radio button in asp.net using jquery. I tried different methods but I am not able to change the attribute.
My aspx page is as follows,
<%@ Page Title="" Language="C#" MasterPageFile="~/FormMaster.master" AutoEventWireup="true"
CodeFile="ArabiaHRLetterSurveyForm.aspx.cs" Inherits="HRLetter_Arabia_ArabiaHRLetterSurveyForm" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<div class="latest" style="width: 98%; margin-left: 10px; margin-right: 10px">
<span class="corner-right">
<div class="actions">
<a href="#" class="status" id="lnkHistory" style="color: #fff">History</a></div>
HR Letter Survey Form </span>
</div>
<div style="width: 98%; margin-left: 10px; margin-right: 10px;">
<div>
<table cellpadding="0" cellspacing="0" width="100%" class="tableClass">
<tr class="trClass" align="right">
<th class="full" colspan="5">
Header
</th>
</tr>
<tr class="trClass" style="width: 100%">
<td class="first" style="width: 20%">
Request No
</td>
<td class="last" style="width: 80%">
<a href="#" class="status" id="lnkRequestNo" style="color: Blue" target="_blank">
<%=Request["requestid"]%></a>
</td>
</tr>
</table>
</div>
</div>
<div id="div_survey" runat="server" style="width: 98%; margin-left: 10px; margin-right: 10px;">
</div>
<div>
<table align="center">
<tr>
<td class="innerTd">
<a href="#" id="btnSubmit" runat="server" class="button-small" onserverclick="btnSubmit_Click">
<span class="corner-right-small">Submit</span></a>
</td>
</tr>
</table>
</div>
<asp:HiddenField ID="hUserIdEncrypted" runat="server" />
<asp:HiddenField ID="hInitiatorUserId" runat="server" />
<asp:HiddenField ID="hSurveyId" runat="server" />
<script type="text/javascript">
$("#lnkRequestNo").attr("href", "ArabiaHRLetterRequest.aspx?requestid=" + <%=Request["requestid"]%> +"&userId= " + $("#<%=hUserIdEncrypted.ClientID %>").val());
$("#lnkHistory").fancybox({
'width': 700,
'height': 400,
'autoScale': true,
'transitionIn': 'none',
'transitionOut': 'none',
'type': 'iframe'
});
$("#lnkHistory").attr("href", "ArabiaHRLetterSurveyFormHistory.aspx?surveyid=" + $("#<%=hSurveyId.ClientID %>").val());
$("#<%=btnSubmit.ClientID %>").click(function(ev) {
ev.preventDefault();
var id;
var selected;
$("#<%=div_survey.ClientID %> tr:not(:has(th))").each(function() {
$(this).find("td").each(function() {
var o = $(this);
var firstCol = o.parent().children().first();
id = firstCol.text();
selected = "N/A";
firstCol.next().next().find("input").each(function() {
if($(this).is("checked")) {
if($(this).val() == "YES")
selected = "YES";
else if($(this).val() == "NO")
selected = "NO";
else if($(this).val() == "N/A")
selected = "NA";
}
});
firstCol.next().next().find("textarea").each(function() {
selected = "TextArea";
});
});
alert(id);
alert(selected);
});
});
$("input").each(function() {
$(this).click(function(ev) {
alert($(this).val());
if($(this).val() == "YES")
{
$("input[value='YES']").attr('checked', true);
$("input[value='NO']").attr('checked', false);
$("input[value='N/A']").attr('checked', false);
}
else if($(this).val() == "NO")
{
$("input[value='YES']").attr('checked', false);
$("input[value='NO']").attr('checked', true);
$("input[value='N/A']").attr('checked', false);
}
else if($(this).val() == "N/A")
{
$("input[value='YES']").attr('checked', false);
$("input[value='NO']").attr('checked', false);
$("input[value='N/A']").attr('checked', true);
}
//$('#Yes').attr("checked",false).checkboxradio("refresh");
//$("input[type='radio']").attr("checked",true).checkboxradio("refresh");
//$('input[name="yes_no_na0"]').attr('checked', false);
//$(this).next().attr('checked', false);
//$(this).next().next().attr('checked', false);
});
});
</script>
</asp:Content>
My code behind file is as follows,
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using GWC.ToolKits;
using System.Data.Linq;
using System.Linq;
using System.Text;
using System.Windows;
public partial class HRLetter_Arabia_ArabiaHRLetterSurveyForm : System.Web.UI.Page
{
protected void Page_PreInit(object sender, EventArgs e)
{
}
protected void Page_Init(object sender, EventArgs e)
{
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindQuestions();
hInitiatorUserId.Value = EncryptDecrypt.EncryptDecrypt.GetDecryptedData(Request["userId"]);
hUserIdEncrypted.Value = Request["userId"];
var m1 = Database.GetSurveyId(Request["requestId"]);
hSurveyId.Value = m1.survey_id.ToString();
var m = Database.GetSurveyId(Request["requestid"]);
}
}
private void BindQuestions()
{
StringBuilder surveytable = new StringBuilder();
var m = Database.GetQuestions();
if (m.Count > 0)
{
surveytable.Append("<table cellpadding='0' cellspacing='0' width='100%' class='tableClass'>");
surveytable.Append("<tr class='trClass' align='right'>");
surveytable.Append("<th class='full'>Id</th><th class='full'>Questions</th><th class='full'>Answers</th>");
surveytable.Append("</tr>");
if (m.Count > 0)
{
for (int i = 0; i < m.Count; i++)
{
surveytable.Append("<tr class='trClass' style='width:100%'>");
surveytable.Append("<td class='first' style='width:5%'>" + m[i].question_id + "</td>");
surveytable.Append("<td class='first' style='width:60%'>" + m[i].question_description + " </td>");
if (m[i].question_type_id == 1)
{
surveytable.Append("<td class='last' style='width:35%'>");
surveytable.Append("<input id=\"rdoYes" + i + "\" name=\"yes_no_na" + i + "\" value=\"YES\" checked=\"false\" type=\"radio\">YES</input>");
surveytable.Append("<input id=\"rdoNo" + i + "\" name=\"yes_no_na" + i + "\" value=\"NO\" checked=\"false\" type=\"radio\">NO</input>");
surveytable.Append("<input id=\"rdoNa" + i + "\" name=\"yes_no_na" + i + "\" value=\"N/A\" checked=\"true\" type=\"radio\">N/A</input>");
surveytable.Append("</td>");
}
else
{
surveytable.Append("<td class='last' style='width:35%'>");
surveytable.Append("<Textarea id=\"txtComment" + i + "\" type=\"text\" runat=\"server\" style='width:98%; height:100px'></Textarea>");
surveytable.Append("</td>");
}
surveytable.Append("</tr>");
}
}
surveytable.Append("</table>");
div_survey.InnerHtml = surveytable.ToString();
}
else
{
}
}
private void SendNotificationAll(string userId, string subject, string body, string cc, string bcc)
{
try
{
string approvalEmail;
approvalEmail = EmployeeData.GetEmployeeEmailByUserId(userId);
MailHelper mailHelper = new MailHelper();
Utilities util = new Utilities();
mailHelper.SendMailMessage(util.GetValueFromConfigFile("SupportEmail"), approvalEmail, bcc, cc, subject, body);
}
catch (Exception exp)
{
LogManager logHelper = new LogManager(Request.PhysicalApplicationPath.Trim(), "HR Letter Request");
logHelper.LogError("[SendApproverNotification - ]" + exp.Message);
}
}
private void AlertMessage(string message)
{
string strScript;
strScript = "<script language=javascript>alert('" + message + "');</script>";
Page.RegisterClientScriptBlock("key", strScript);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DateTime datetime1, datetime2;
datetime1 = DateTime.Now;
datetime2 = datetime1.AddSeconds(1);
string request_no = Request["requestid"];
var m = Database.GetSurveyId(request_no);
string survey_id = m.survey_id.ToString();
Database.UpdateHRLetterSurveyMasterData(request_no, "2");
Database.RegisterHRLetterSurveyHistory(survey_id, hInitiatorUserId.Value, datetime1.ToString(), "C", datetime2.ToString(), "Survey Completed");
string peoplelinkUserId = GeneralData.GetCountryPeoplelink("1");
Database.RegisterHRLetterHistory(request_no, peoplelinkUserId, datetime1.ToString(), "E", datetime2.ToString(), "Survey Completed");
string messageid;
messageid = GeneralData.InsertMessage(request_no, peoplelinkUserId, "Survey Request[" + request_no + "]", "inbox", "0", "0", "HRLetter", DateTime.Now.ToString(), "1").ToString();
GeneralData.InsertMessageHistory(messageid, "inbox", DateTime.Now.ToString());
Utilities util = new Utilities();
SendNotificationAll(peoplelinkUserId, "Survey Request[" + request_no + "]", "<span style=\"font-family: Arial; font-size:12px\">Dear PeopleLink, <br /><br />Survey Request is completed.<br /><br />Click the link below for more details:<a href='http://" + util.GetValueFromConfigFile("ServerIPAll").ToString() + "/ArabiaHRLetterSurveyForm.aspx?requestid=" + request_no + "&surveyid=" + survey_id + "<br /><br />Thank you<br/>", "", "");
AlertMessage("Survey Request Completed");
Response.Redirect(Page.ResolveUrl("~/HRLetter\\Arabia\\ArabiaHRLetterSurveyForm.aspx?userid=" + hUserIdEncrypted.Value + "&requestid=" + request_no));
}
}
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
