Tagged Questions
0
votes
1answer
23 views
Add, delete row and rebind large no of data
In my application I am using Json to bind data from sql as (bind data as per scroll) approach.
It is working fine but I when I delete or add new data , I want that row should be updated without ...
0
votes
0answers
28 views
Hyperlink to new window (solely separated window)
In parent window I will dynamic hyperlink add attribute
String.Format("window.open('{0}','mywindow','_blank',", url)
something like that.
And so when user click on the hyperlink, it will open the ...
1
vote
1answer
57 views
MySQL query taking forever to run, what is wrong?
I am using this to make a query where i goes upto 20 in c#.net mysql connectivity.
This query takes forever to execute and when I run it in MySQL shell it takes 3 mins.
All other queries run fine.
...
0
votes
1answer
23 views
Asp.Net multiple join tables issue from Sqldatasoruce Query Builder into one gridview
In Visual Studio 2010 with ASP.NET 4, I am trying to join several tables together to put the results in a gridview and details view with sqldatasource. In the sqldatasource wizard I have chosen to ...
0
votes
2answers
51 views
Calculation in Asp.Net
Below is the code I want to apply a logic to subtract a Quantity before update in database ? May i know how to write a logic in code? kindly advise.
Example WMWTContQTy.text value subtract from DB ...
0
votes
3answers
21 views
Updating Entity Framework Model after adding a field to a previous look up only table
To better illustrate the problem :
I have a table called Action with key AID and I have a table called Requirement with RID.
Previously I had a lookup table that simply held an AID and an RID.
This ...
0
votes
0answers
11 views
ASP .NET connection string for a LoginID created using a self-signed certificate
I created a certificate in SSMS (Sql Server 2008) using
CREATE CERTIFICATE testcert
ENCRYPTION BY PASSWORD = 'pwd for testcert'
WITH SUBJECT = 'Test Certificate',EXPIRY_DATE = '12/31/2015'
then ...
0
votes
1answer
47 views
Retrieve value from ListView
I need to retrieve some value from my ListView, which is bound with SQL to Order by Price ASC
Requirement :
Counts of total rows in the list
Minimum Price and Seller Name, who has minimum price ...
0
votes
2answers
24 views
Bulding Menu with asp.net using the Database
I have an table in database and I need create Menu in my project using this database.
How I create this with asp.net c#? I need transform this line "N:\A\B\C" in menu style Tree View. But this menu ...
0
votes
2answers
61 views
Creating Search Function in asp.net
I am trying to make search function in my web application.
Basically, i have one text box and one button.
Also i have listbox to render the search results.
I am using follwing query on access which ...
0
votes
0answers
13 views
Can I simply import aspnet_membership table to a new SQL instance that will keep usernames and passwords in tact?
I did see a similar post on this, but it didn't specifically say whether or not the hashed passwords and usernames would remain in tact.
The situation is that I rebuilt our eCommerce platform on a ...
0
votes
2answers
31 views
filter gridview based on dropdownlist selected value
Im trying to do a exercise filter GridView based on selected value in DropDownList.
I have a list of names in dropdownlist and when i click in the name i want that information of persons appears in ...
0
votes
2answers
21 views
storing data in a xml format file
I m trying to build a function that will retrieve 'some' SQL data from multiple tables, and store it in a file in the XML format.
If I do it with C#, is it as simple as:-
SQL statement,
retrieve ...
1
vote
1answer
58 views
Getting regular expression from database
I Have my regex in a SQL Database
for example: ^[A-Z Ñ\s\.\,\\"\%]+$
Then, i get it with a SQL Reader
sql.Reader["Regular_Expression"].ToString()
But, that return the following: "^[A-Z ...
0
votes
6answers
73 views
Passing strings in Sql query from C#
I Have a sql query as below:
Select CatId
From tbl_T2H_Category
Where Category IN ('Category3', 'Category4', 'Category6')
Now what i want is the values inside IN clause should be added ...
