|
It's a database question which needs to be moved to General Database Section.
It seems that following line is creating problem for you:
Select @sessionvalue= empmaster.EmpGUID,Themesetting.th_name from empmaster inner join EmpTheme on empmaster.EmpGUID = EmpTheme.EmpGUID inner join Themesetting on EmpTheme.themeid = Themesetting.themeid
where employeeid=@username and password=@password
To get rid of this error, make sure that all columns are assigned to a local variable. For example, just create another variable and store th_name column into this. Your problem will be vanished.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
When I move a data directory containing few media files the session gets expiered. Can anybody help me out in find what is going wrong in the process of moving the directory.
Thanks in advance.
Sekhar
|
|
|
|
|
What is your session mode and Session expire time ? And How long time is taking to moving the directory ?
|
|
|
|
|
My session mode is 'InProc' and expiry timeout is '90' minutes. And it takes maximum 30 seconds to move the directory. Please Help.
Thanks.
Sekhar
|
|
|
|
|
hello
I am sending Mail using smtpclinet.send Method()
all work fine
but Issue is that when i send Mail it All time return True no Error if Undelivar Mail due to any reason like mailbox full,Wrong Mail Address etc.
so How can we notify that mail is undeliver due to Wrong any reason and Send Mail to Administrator that that mail is undeliver
I aslo Tried using
client.SendCompleted += new SendCompletedEventHandler(client_SendCompleted);
client.SendAsync(message, userMessage);
But That time it's give error Like mail sending Fail if E-Mail address is True
Please Provide Solution ASAP
Regards
Kirti Darji
kirti
|
|
|
|
|
Hi,
One thing needs to be clear. We are not supposed to give you a solution rather than we can help you to assist you. Nobody here is paid to provide you a solution. So using a sentence like "Please Provide Solution ASAP" may be rude sometimes.
As far as your problem is concerned, I would like to suggest you to go through the following links which may be useful:
http://forums.asp.net/p/1189023/2038523.aspx[^]
http://forums.asp.net/t/1111538.aspx[^]
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
|
i got wrong value after sorting grid ....i click on item command after after sorting i got wrong value....
|
|
|
|
|
This[^] will explain what you've done wrong.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
ratheeshnair123 wrote: i got wrong value after sorting grid ....i click on item command after after sorting i got wrong value...
What do you mean by wrong value ? what you did for sort the grid data?
|
|
|
|
|
how we can bind checkboxlist using jquery
One person's data is another person's program.
--J.Walia
|
|
|
|
|
Are there any differences at all in setting up the web.config for a .NET 3.5 app vs. a 2.0 to make use of the asp .net membership provider?
Is the same version 2.0.0.0 of the membership provider in the web.config still the one to use with the 3.5 version of the framework? Also, what if the connection string is encrypted in the registry, how would the connectionstringname and connection be set for membership to use then?
I have come up empty handed trying to find answers to the above questions.
Please help,
Thanks
Revolutionary: Disk drives go round and round.
|
|
|
|
|
I'm having a problem with getting my new site to upload. I'm using asp.net/vb.net as well as using the new ajax control toolkit as well and after uploading my page to my server I come acrossed an error that I'm not sure how to fix. The site is located at:
http://www.watsonowen.com/NewSite/SiteTemplate/
The error I'm getting is Parse error and states this "Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The system cannot find the file specified."
If someone could please help me fix this problem I would greatly appreciate it.
|
|
|
|
|
Owen Watson wrote: The error I'm getting is Parse error and states this "Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. The system cannot find the file specified."
Does your hosted site have the specific framework and AjaxToolkit installed?
|
|
|
|
|
Seems rather obvious, the AjaxControlToolKit assembly is not in the correct location.
only two letters away from being an asset
|
|
|
|
|
Just place the AJAXControlToolkit.dll in the bin directory of your project or install it in the global assembly cache.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
I am trying to follow some instructions in a VB2005 book which changes the value of DefaultClientScript by viewing the DOCUMENT Properties. The problem I have is that I do not see this property listed. I tried searching for an answer and found many articles suggesting changing this on the Property Pages on the General Section. Trouble is I don't have any general section.
All I want to do is to change the default to VBScript
Am I missing something simple?
flowerppk
|
|
|
|
|
|
I have tried both these two ways that mentioned in msdn website but i couldn't find any propery pages dialog box in View.It doesn't work. Kindly pls advise what's going on? Do I need to change some setting?
Default script is always JavaScript.
flowerppk
|
|
|
|
|
dear all;
i am so much confused .... actually i want to do a small project that shows around 180 offices name and when ever we click on the collapsible panel a panel will be expanded and gives the details of the clicked office.( from the database).. the details are ( like telephone,email,specifications... etc)
so how i can do this.. if we use a user control with collapsible panel it will hamper the page so much i.E the page load will be so much heavy....
pls help in that .. any suggestions..............pls pls i am urgent regarding this
|
|
|
|
|
omerqq wrote: if we use a user control with collapsible panel it will hamper the page so much i.E the page load will be so much heavy....
If the information is same for all user load the data in the Cache, so it will not hit database every time to retreive user information and data population will be fast.
|
|
|
|
|
Well you could load the data...wait..."pls pls i am urgent regarding this". Sorry, don't respond to rude requests like this. It may be urgent to you but not the rest of us.
only two letters away from being an asset
|
|
|
|
|
Are you going to show 180 offices in a single page or will you use pagination? Surely if you are going to show 180 offices and its related information which comes from the database, your page load will be affected as far as the performance is concerned.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
Hi!
I have 2 tables in MS SQL database - one is just ID and Description of an Client Type, the other is ID, name, address and ClientType_ID. I have a GridView which is binded with SqlDataSource. The select statement returns all. I have made on the place of the ClientType_ID to be shown a DropDown List with the Description of the Client Type, not the ID, so the user can choose from it. I've enable on my SqlDataSource update, insert & delete statements. I was hoping when I edit the GridView and change the value in the DropDown List that it will update the table. But not only that didn't happend, but I have this error:
Incorrect syntax near 'nvarchar'.
Is anyone has any suggestions how to update the ClientType_ID in the table with the names of the clients, but choosing from the Description, not the ID of the ClientType?
What's with this error?
10x in advance!
This is the gridView and the sqlDataSource
<pre> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:LegalConnectionString %>"
SelectCommand="SELECT * FROM [Clients]" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [Clients] WHERE [ClientID] = @original_ClientID AND [ClientType] = @original_ClientType AND [First Name] = @original_First_Name AND [Last Name] = @original_Last_Name AND (([BULSTAT] = @original_BULSTAT) OR ([BULSTAT] IS NULL AND @original_BULSTAT IS NULL)) AND (([Telepohone number] = @original_Telepohone_number) OR ([Telepohone number] IS NULL AND @original_Telepohone_number IS NULL))" InsertCommand="INSERT INTO [Clients] ([ClientType], [First Name], [Last Name], [BULSTAT], [Telepohone number]) VALUES (@ClientType, @First_Name, @Last_Name, @BULSTAT, @Telepohone_number)" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [Clients] SET [ClientType] = @ClientType, [First Name] = @First_Name, [Last Name] = @Last_Name, [BULSTAT] = @BULSTAT, [Telepohone number] = @Telepohone_number WHERE [ClientID] = @original_ClientID AND [ClientType] = @original_ClientType AND [First Name] = @original_First_Name AND [Last Name] = @original_Last_Name AND (([BULSTAT] = @original_BULSTAT) OR ([BULSTAT] IS NULL AND @original_BULSTAT IS NULL)) AND (([Telepohone number] = @original_Telepohone_number) OR ([Telepohone number] IS NULL AND @original_Telepohone_number IS NULL))">
<DeleteParameters>
<asp:Parameter Name="original_ClientID" Type="Int32" />
<asp:Parameter Name="original_ClientType" Type="Int32" />
<asp:Parameter Name="original_First_Name" Type="String" />
<asp:Parameter Name="original_Last_Name" Type="String" />
<asp:Parameter Name="original_BULSTAT" Type="String" />
<asp:Parameter Name="original_Telepohone_number" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ClientType" Type="Int32" />
<asp:Parameter Name="First_Name" Type="String" />
<asp:Parameter Name="Last_Name" Type="String" />
<asp:Parameter Name="BULSTAT" Type="String" />
<asp:Parameter Name="Telepohone_number" Type="String" />
<asp:Parameter Name="original_ClientID" Type="Int32" />
<asp:Parameter Name="original_ClientType" Type="Int32" />
<asp:Parameter Name="original_First_Name" Type="String" />
<asp:Parameter Name="original_Last_Name" Type="String" />
<asp:Parameter Name="original_BULSTAT" Type="String" />
<asp:Parameter Name="original_Telepohone_number" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ClientType" Type="Int32" />
<asp:Parameter Name="First_Name" Type="String" />
<asp:Parameter Name="Last_Name" Type="String" />
<asp:Parameter Name="BULSTAT" Type="String" />
<asp:Parameter Name="Telepohone_number" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1"
ForeColor="#333333" GridLines="None" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" DataKeyNames="ClientID">
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Select"
Text="Select"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ClientID" HeaderText="ClientID" InsertVisible="False"
ReadOnly="True" SortExpression="ClientID" />
<asp:TemplateField HeaderText="ClientType" SortExpression="ClientType">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList6" runat="server" DataSourceID="SqlDataSource2"
DataTextField="Description" DataValueField="ClientType">
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:DropDownList ID="DropDownList5" runat="server" DataSourceID="SqlDataSource2"
DataTextField="Description" DataValueField="ClientType" OnSelectedIndexChanged="DropDownList5_SelectedIndexChanged" SelectedValue='<%# Bind("ClientType") %>'>
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="First Name" HeaderText="First Name" SortExpression="First Name" />
<asp:BoundField DataField="Last Name" HeaderText="Last Name" SortExpression="Last Name" />
<asp:BoundField DataField="BULSTAT" HeaderText="BULSTAT" SortExpression="BULSTAT" />
<asp:BoundField DataField="Telepohone number" HeaderText="Telepohone number" SortExpression="Telepohone number" />
</Columns>
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
<EmptyDataTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
DataTextField="Description" DataValueField="ClientType" SelectedValue='<%# Eval("Description") %>' Width="155px">
</asp:DropDownList>
</EmptyDataTemplate>
</asp:GridView>
Help please!!
|
|
|
|
|
Hello,
I want to store cookies of multiple user logged in different times on same pc.
Is this possible?
Thanks in advance
Regards,
Milind
|
|
|
|