database cannot be connected??
Dim delconn As New SqlConnection _
("data source=15-46\SQLEXPRESS;AttachDbFilename =C:\Program Files\Microsoft SQL Server\MSSQL.1\ | | 1 | 73 | 5/20/2008 4:14:18 AM |
Securing querystrings where objCon isn't needed
Hey all,
Trying to add some security to what I'm learning I realized my querystring was vulnerable so I started looking through the threads on how to secure it. I've seen a few | | 8 | 52 | 5/20/2008 3:36:49 AM |
how to compare a value in database?
i am making a transaction function for my website, when people transfer an amount from account A to account B, it should check the amount if account A has enough money to transfer. here is my cod | | 4 | 48 | 5/20/2008 3:20:14 AM |
sql server connection problem
Hi,
| 2 | 55 | 5/20/2008 2:54:47 AM |
More problems with SQl and Vista
I just added all users as Db_owner :) Now I am gettimg this error:
The EXECUTE permission was denied on the object 'GetCountryByISO', database 'zikbay', | | 3 | 54 | 5/20/2008 2:53:08 AM |
Using SCOPE_IDENTITY()
Hi All,
I'm trying to return the last id entered via the following code, and I'm only getting '0' back.
1 < | | 1 | 62 | 5/20/2008 2:39:41 AM |
import excel data into sql express
hi,
i need to import excel data(2000 records) into sql server table.
i did all possible ways. but still i am getting the error
| | 19 | 57 | 5/20/2008 2:21:15 AM |
Using CONTAINS with SQL Express
Hi There,
After many days of trying to get a fulltext search running, I am able to execute the following SQL Command: ALTER PROCEDURE | | 1 | 56 | 5/20/2008 12:57:13 AM |
Sql Sum
I want to sum up all the number in a column an dput them into a textbox. What am I doing wrong here?:
DBconn = New | | 2 | 58 | 5/20/2008 12:40:52 AM |
Stored procedure optional search parameters
Hi I want to give the user the ability to search based on a number of criteria, however i do not know how to build my statement properly this is what i have so far; | | 11 | 65 | 5/19/2008 11:21:03 PM |
Changing the SQLDatasource SELECT for a Gridview
I cant seen to change the Select command for a SQL Datasource
try #1
SqlDataSourceProfilesThatMatch.SelectComman | | 3 | 86 | 5/19/2008 11:12:47 PM |
System.Data.SqlClient.SqlException' Timeout Expired The timeout period elap sed prior to completion of the operatio or the server is not Responding
Hi Everyone,
I have an ASP.Net webpage for uploading multiple files. The process is, when the client uploads files..using SQL queries I am inserting into a database1 and then c | | 1 | 653 | 5/19/2008 11:04:58 PM |
Whats wrong with my query
strCommand = "SELECT * FROM tblevents WHERE startingDate=#"&startDate &"# AND eventtitle like '%"&criteria &"%' ORDER BY " &sSortSt | | 6 | 51 | 5/19/2008 11:04:53 PM |
connection string help
hello all
i use (RDB Relational Data Base)
and i need the correct connection string to use it in my asp project Page_load
i dont want to us | | 4 | 56 | 5/19/2008 9:59:37 PM |
Multilanguage database design recommendations
Dear friends
I'm developping a multilanguage human muscle database and wanted to know your opinion about my design
Table Muscle:
-MuscleID(PK)
-Name_DE......... | | 7 | 64 | 5/19/2008 8:54:21 PM |
Database Design Questions
Hey guys, this is my first post here. I just joined recently and I am loving the videos as they've really helped me step into ASP.NET and VB. Just some background, I used to be a CS maj | | 4 | 43 | 5/19/2008 8:26:10 PM |
Dynamic WHERE Clauses
So how do you do dynamic WHERE clauses with asp.net?
I have a QueryString parameter with a value that will look like this. |1| or |1||2| or |1||2||3|&n | | 2 | 54 | 5/19/2008 8:16:06 PM |
Using the OnSelected Event of SqlDataSource
Hello,
on my site I have a sqldataSource and a listview working together. But now after selecting data from my database and before binding data to the listview i want to change the d | | 8 | 294 | 5/19/2008 7:40:11 PM |
Show data in a txtbox based on a key passed from the 1st page
On my Home page I have a gridview that has Four columns: CustomerID, Product, Quantity, then a link (which appears on each row..called View). When a user clicks View on | | 17 | 51 | 5/19/2008 7:09:59 PM |
data types for zip code and date (mm/dd/yy) in sql database
Hello All, i have a sql database with a table as follows. CustID (PK, Varchar(50) not null | | 3 | 56 | 5/19/2008 6:54:15 PM |
Server Error in '/' Application.
Hi, friends..
I wanna upload my web site but ? didn't configurate web.config file... I have newuser.aspx file that just contains createu | | 2 | 51 | 5/19/2008 6:17:49 PM |
sql query question
i have database Table (TABLE) like this
key Var Date
1 A 2/2/2008< | | 0 | 44 | 5/19/2008 5:33:07 PM |
Invalid object name 'dbo.DisclaimerLatestVersion'.
Hello everyone! Need help in this. Using a SP for selecting the most recent record in a set. system can contain up to | | 7 | 76 | 5/19/2008 4:40:00 PM |
SQL Update Statement Set Field Value to Column Default
Is there a way to set a field value to the column default in an update statement?
Eg.
UPDATE Table2 SET field1 = DefaultValue
where DefaultValue is the field1 column | | 8 | 52 | 5/19/2008 4:30:37 PM |
Encounter "No parameterless constructor defined ..." during the O nObjectCreated of an ObjectDataSource
I got the following error when trying to pass a parameter from an ObjectDataSource to a BLL during the OnObjectCreated event: | 2 | 78 | 5/19/2008 4:16:13 PM |
Returning no results
I have the following stored procedure that is returning nothing can anyone please help?
SELECT job_id, line_num, cust_id, cust_po_id, product_desc, form_num, | | 6 | 53 | 5/19/2008 4:14:42 PM |
help!!
hey guys. im doing this web project at uni. have to make a e-commerce website, where i have to have sell different products and have shopping carts and bla bla. im just stuck at the search bit. i | | 4 | 47 | 5/19/2008 4:14:08 PM |
login status problem
? added aspnetdb.mdf and login status my webform, ? saw log out but ? didnt log in site.. ? think problem is in web.config file.. how can configure web.config... or problem what?
? need | | 6 | 82 | 5/19/2008 3:59:15 PM |
Group By Team in SQL DataSource?
Is it possible to group by "Team" in the following SQL Datasource?
Each row has a numbers in their respective columns and need to be added up and only one row per team is shown | | 1 | 47 | 5/19/2008 2:46:59 PM |
sql view help
how can i make a view in my sqlexpress 2005 database that get data from oracle database or from RDB (old oracle database) | | 6 | 55 | 5/19/2008 2:37:54 PM |
Update function: why SQL Server update an empty string with 0?
I'm new to this forum.
This 'problem' has occured many times, but I've always found a way around it.
I have pages with datagrids, in which a user can edit a cert | | 23 | 45 | 5/19/2008 2:19:34 PM |
SQL 2005 vs SQL 2000
HI,
I Have my websites developed in sql 2005 and my host is providing SQL 2000.
WHAT problem i might face will my site run ?
or do i need to change things??
| | 5 | 54 | 5/19/2008 2:11:34 PM |
Read Stored Procedure Return
Hi,
Using Chandu Thota's book | 10 | 52 | 5/19/2008 1:39:56 PM |
An SQLDataSource on 2 other DataSources? show in a GridView
Hi,I have two SQLDataSources called "LeagueTableHome" an "LeagueTableAway" on my page.
I want to create another SQLDataSource called "LeagueTableTotal" on my | | 4 | 52 | 5/19/2008 1:34:49 PM |
Error Message: No Overload for method 'sqlparameter' takes 1 arguments
Dear All,
I have a problem while trying to update the content of my page to the database by the means of a stored procedure
string | | 3 | 63 | 5/19/2008 1:18:24 PM |
T-Sql Problem
My gridview after my query
Normal
0
false
false
false
EN-US
X-NONE
X-NONE
| | 5 | 44 | 5/19/2008 12:39:50 PM |
Single - Double Quotes problem in query
Hi All,
I am facing quotes problem. Without using the quotes
my query is running fine, but I need to use IIF condition so for that I
need quotes adjustment. I didn't figured | | 1 | 46 | 5/19/2008 12:28:30 PM |
import all tables from sqlserver to informix
hi
guys i need to import all tables from sqlserver to informix ...............
any idea really appreciated
Vi | | 0 | 42 | 5/19/2008 11:38:42 AM |
help me
hi there
i got a trouble,when i delete a single record,it delete all!
i am using vs2005 and sql2000.
private void button3_Click(object sender, EventArgs e)
| | 3 | 60 | 5/19/2008 10:39:59 AM |
what is logical and physical database design
hi we are in the process of developing a project and we r at the initial phase i.e. at the analysis phase and we have been discusssing on what is physical and logical database design | | 1 | 75 | 5/19/2008 10:30:15 AM |
LIKE syntax in a SELECT statement
What is the syntax for making a query using like, the below is my code
<asp | | 5 | 57 | 5/19/2008 10:11:26 AM |
How to configure SQLDataSource
Hi,
I am really having a hard time creating a parameter for the RadioButtonList radSearchField. I want to type 's' in the text the choose the co | | 3 | 67 | 5/19/2008 9:01:43 AM |
error: 26 - Error Locating Server/Instance Specified
I have been fixing this error many days but there is no result. The ways I tried so many that I can't remember. OS: Vista 64bit SP1. Visual studio 2008 Sql server 2005 | | 4 | 56 | 5/19/2008 8:52:31 AM |
Bit-data from SQL Server 2000 (2005 working, 2000 doesn't)
Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring | | 0 | 45 | 5/19/2008 8:44:52 AM |
error retrieving a record based on 3 parameters. Need help with forming my SQL statement
I am having trouble returning the correct record with my stored procedure.
my problem is that i don't know how to structure the sql statement to do the following:
given a set | | 6 | 45 | 5/19/2008 8:44:11 AM |
connection between database & website located at different places
I am creating a website. where the data to be stored in my server. I had my webspace from some service provider.
How can i connect the website and thee database.
--> website | | 3 | 41 | 5/19/2008 8:30:41 AM |
Using "NOT IN" with null values
Hi,
I ve a table, I want to fetch certain rows based on the value of a Column. That column is nullable, and contains NULL values. I used the following query,
S
| | 6 | 52 | 5/19/2008 7:52:13 AM |
move data between databases
hi, I currently uses SQL Server 2005. I need to move the data to my website, how do I do that? I have the SQL Server Management Studio Express but I couldn't not get it to export the da | | 3 | 43 | 5/19/2008 6:52:40 AM |
No result in WHERE__AND__Clause,why???
Hi y'all, I have a problem in my query I think maybe you guys could help. I have this query:
SELECT dbo.BOS_GL_Workplace.WpszState, Emp2.szName | | 3 | 52 | 5/19/2008 4:18:02 AM |
Tell a friend function with messages stored in MS SQL Server
Hi im finalizing a site for a custmer and now adding a Tell a friend function. I have done those before but not when storing
the mailmessage in the SQL server and my question is
< | | 7 | 50 | 5/19/2008 12:18:37 AM |