|
I have a table which name is login & contain 3 columns. Such as: Name,password & code. In code column contains the table name. eg: table1,table2 so on.
And I also create the table of same name as mentioned in code column which is mentioned above.
My requirement is that I insert the value in table1 or table2. but in insert query I want to put the table name from the code column.
I use following two methods but it didn’t work::
string code = " select code from login where user_name= name";
da = new SqlDataAdapter(code, con);
string s = da.Fill(ds, "c");
string time = " insert into '"+s+"' values (getdate(),getdate())";
da = new SqlDataAdapter(time, con);
da.Fill(ds, "b");
------------OR-------------
string code = " select code from login where user_name = name'";
string time = " insert into '"+s+"' values (getdate(),getdate())";
da = new SqlDataAdapter(time, con);
da.Fill(ds, "b");
thanks in advance
|
|
|
|
|
tell me how can i use Sql server User Define Function in Asp.net .
i am using this by Stored Procedure but it create Problem , can anyne tell me hw to do this.
|
|
|
|
|
hmm.... it seems to me that you're a bit lost. We can't really give you any help based on this vague post that you can't get from MSDN. What does 'it create problem' mean ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Okay, I've got a page with two drop down lists, both of which are databound to separate datasources. The first drop down determines what is displayed in the second. Here's my problem, I don't want the second dropdown to be visible on the page if it isn't populated with items. Any ideas on what I may do here? I've tried this:
if dropdownlist1.items.count = 0 then
dropdownlist1.visible = false
This doesn't even make the drop down list visible even if there are items in it. What am I doing wrong?
|
|
|
|
|
May be you have to do this .
If (DropDownList1.Items.Count==0)
{
DropDownList2.Visible=false;
}
else
{
DropDownList2.Visible=true;
}
|
|
|
|
|
How about:
dropdownlist1.visible = (dropdownlist1.items.count > 0)
or how about making it invisible by default and making it visible in the code that adds items to it ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Can anyone suggest some good free tools to track all the HTTP requests going through my machine??
I am more interested in header details like cookies exchanged between server and client.
I am currently using tools like Fiddler Web Debugger, HTTP Watch, etc... but not much of help.
Thanks.
~AHAGeek
|
|
|
|
|
|
Thanks for reply.
Thats a nice tool..but its more of a network tracer which gives me ips and protocol..
I need to trace my http request, and all the information exchanged as cookies, html and other stuff...
~AHAGeek
|
|
|
|
|
|
Hello .. i'm new in asp.net : i need to use POST vars ... instead of GET : Request["myGetvars"]
my problem is that i want to send data from one page to another page without using the Session[] vars ...
how can i do this ?
than you for your help and i hope that i'm clear. 
|
|
|
|
|
Use Request.Form[] instead of Request.QueryString[] to get the form values that was posted to the page.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
You Can use Querystring , HyperLink .
|
|
|
|
|
Hi
i created a web service using wcf,when i deployed the service on my webserver i got the following error:
This collection already contains an address with scheme http. There can be at most one address per scheme in this collection.
Parameter name: item
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.ArgumentException: This collection already contains an address with scheme http. There can be at most one address per scheme in this collection.
Parameter name: item
after doing some research i learnt that i needed to make a change to my ServiceHost code in the .svc
the change was to add the fatory attribut as seen below,the problem i'm having is that .net is saying that factory is an attribute that does not exist, can anyone assist...
Factory="CustomServiceHostFactory" %>]]>
Many Thanks
|
|
|
|
|
|
Dear All,
I am encountering a wierd behaviour,when writing a Server control where the namespace of the control starts with Style. Please clarify if I am doing something wrong or if I use any reserved keywords?
Issue details are below
1) Create a custom control using the following code
namespace Style.Enum //you can have any namespace which stars with Style.
{
public class EnumClass
{
public enum SomeEnumType
{
TYPE1,
TYPE2
}
}
public class ServerControl : WebControl
{
private EnumClass.SomeEnumType eType;
public ServerControl()
{
}
public EnumClass.SomeEnumType ETYPE
{
get
{
return eType;
}
set
{
eType = value;
}
}
}
}
2) Now add this control in a web page. (sample code)
<%@ Register Assembly="StyleEnum" Namespace="Style1.Enum" TagPrefix="cc1" %>
...
...
<cc1:ServerControl ID="ServerControl1" runat="server" ETYPE="TYPE2" Width="202px" />
3) Now you will get an error as below
Error 1 'System.Web.UI.WebControls.Style' does not contain a definition for 'Enum' X:\XXX/XXXXXX\EnumIssue.aspx
4) If you modify your code with namespace Style1.Enum and other related codes..., you can avoid this issue....
For the past two days, sleeplesly I am verifying all my codes and finally this issue seems something I am not able to understand the reason (according to me I am doing right here.).
Changing the namespace in my application is a bit tough job, as there is a lot of dependency on namespace
Happy Coding,
A.Sivakumar
|
|
|
|
|
can any body guide me how can i set session timeout in my web.config???
i have written following statement and it is not working actually my requirement is if session timeout then page should be redirected to login page how is it possible????
<system.web>>
<sessionstate mode="InProc" timeout="1">
umerumerumer
|
|
|
|
|
Your web.config section did not appear in the message.
What you can do is to use a base page, or master page. Set a session variable such as username when the user logs on.
In the page load of your base page or master page check to make sure the session variable is not null.
If it is null, redirect the user to the log on.
Also you might want to put a javascript timer on the page so that it will warn the user if he is idle for 20 min.
I didn't get any requirements for the signature
|
|
|
|
|
<system.web>
<sessionState mode="InProc" timeout="30"/>
|
|
|
|
|
I have a pop-up window that gets displayed after a button has been evoked on the parent window.
The pop window contains an img with text that conveys to the user that the current file is downloading and an iframe.
The iframe does the bulk of the work ... it populates a infrigistics grid that inturn populates an xls document that gets compressed ... and so forth ... however the problem arises when one wants to navigate to another page from the parent page... it takes long to load another page.
It's very confusing what is the relationship beween a popup window and it's parent ... maybe this will aid me in deducing a solution
|
|
|
|
|
i am using Crystal report with asp.net 3.5...
it load sucessfully and displays records in it but when i click on any record it gives me error logon failure can any body please guide me where is the problem????
if it logon first time then why it gives error after clicking on it... i have applied postback checks but all in vain....
umerumerumer
|
|
|
|
|
Hello,
I just finished a web application which works fine with IE7. But clicking on the login button in Firefox does nothing. No errors. I need to know what the problem is. Thanks in advance...
Obinna, Nigeria.
//obinnaaj Eof
|
|
|
|
|
|
here's the main section of my code on the signonform.aspx.cs file:
string fromDbase = loginDset.Tables[0].Rows[0]["PASSWORD"].ToString();
bool comparisonSucceeded = Cryptographer.CompareHash("SHA256Managed", password, fromDbase);
string userCode = loginDset.Tables[0].Rows[0]["USER_CODE"].ToString();
DataSet personalDset = new DataSet();
personalDset = dl.DIMS_GetDimsUSers(userCode, ref msg);
if (msg != string.Empty)
{
relayBox.Text = "errormsg";
msgBox.Text = "DIMS Error 399: Could not retrieve all DIMS users";
return;
}
if (comparisonSucceeded)
{
Session["auditNo"] = Session.SessionID;
string operation = "LOG IN";
dl.DIMS_InsertAuditTrail(Session["auditNo"].ToString(), personalDset.Tables[0].Rows[0]["NAME_OF_LECTURER"].ToString(), personalDset.Tables[0].Rows[0]["USER_CODE"].ToString(),operation.Trim(), ref msg);
relayBox.Text = "welcome";
return;
}
thanks again!
//obinnaaj Eof
|
|
|
|
|
You'll have to provide more information, such as what the code is doing.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
