|
Hi to all
I have a problem with database in vb.net using sqlexpress.
My problem is:
I have created a .mdf database file and tables in it, and written code for inserting data to this table through command object. But my real prob is when i supply the connection string which is created by the "data configuration wizard" to this cmd object then on runtime insert executes and also data is visible in datagridview but when i check the data in the table it is not there and all fields are NULL.
given connection string.
("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\LIB.mdf;Integrated Security=True;User Instance=True")
But on the otherhand if i give connection string as ::
"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\LIB\LIB\LIB.mdf;Integrated Security=True;User Instance=True"
then data is successfully inserted in the database and i m also able to view it in my database table.
So if Any one can help me it will be highly appreciable.
Thanks.
|
|
|
|
|
Is'nt this a problem of relative Vs global paths ?
I give you an example I know: if you call GetCurrentDir within a code that you execute through Debug-->Start Without Debugging command then you'll have something different as when you go to the Debug directory of your executable and run it from there.
Thus this may lead to different behaviours as when we have relative entries, such that things will work fine, in one case, and fail in the other.
Ahmed. Tunisia.
|
|
|
|
|
I remember this being much shouted about way back, but can't remember the correct term for doing this to search on. Can anyone remind me please?
|
|
|
|
|
|
Accessing database file (.sdf) after changing extension (say .abc) causes error in connection string.
Hi,
I have requirement of creating database .sdf file with some different extension say .abc.
If I do so and in connection string if I try to give the string as
Dim strConnectionString As String = "C:\SQLCEDatabases\DBFileName.abc; Password ="ABCD123";"
Then it causes an error/Exception saying
"Unknown connection option in connection string: C:\SQLCEDatabases\DBFileName.abc; password."
Can I get the solution by which I can access the database file after changing its extension and accessing it through code (C# or VB.NET)
Thanks & Regards
Manish Jape
|
|
|
|
|
CListCtrl m_table;
CDaoDatabase db;
db.Open("D:\\ktt.mdb");
short n_table=db.GetTableDefCount( );
CDaoTableDefInfo TableInfo;
for( int i=0; i
|
|
|
|
|
how can i remove the system objects such as MSystemQueries,... in the list
|
|
|
|
|
Hi..
i need sql query for the ollowing requierment
input -anydate (9/05/2007)
output-given dtae presents which quater(2 quater)
Revathi Raj
|
|
|
|
|
|
I have created reports using reporting services and also created reportview control in my web applicaion.When i select the report from the dropdown it displays correct report but why it still shows the report paramter of the report even if i slelect some other report from drop down.Pls let me know how i can implement this that when user select some other report before clicking on the report button it should diplay blank page.It should not show the parameters of some other report.
|
|
|
|
|
I have a small search function that searches a telephone database on e.g. surname, suburb, and tel no. The data source is two tables, TelPerson and TelNumber, with one TelPerson record to many TelNumber records. I'm battling a bit with my search SQL, which joins the two tables to allow a search on person details as well as on phone number, but I only want one record returned if the search is on person details only.
For example, Investec Bank have 419 telephone numbers, but if the user searches for 'Investec', I only want to return one record, but if the user also includes a telephone number search criterion, I want to show all the records for Investec where the number matches.
|
|
|
|
|
Its a bit ugly, but I think the following should do the trick:
select P.Name, T.PhoneNumber
from TelPerson as P
inner join TelNumber as N
on N.PersonId = P.PersonId
where (@SearchName = '' or P.Name LIKE '%' + @SearchName + '%')
and (N.PhoneNumber = @SearchPhone or (
@SearchPhone = '' and
N.PhoneNumber in (
select min(PhoneNumber) from TelNumber where PersonId = P.PersonId)
))
order by P.Name, P.PersonId, T.PhoneNumberThis assumes that a blank-string equals no criteria. If possible then I would recommend using a stored procedure to make the code more logical.
Regards
Andy
|
|
|
|
|
Thanks Andy, a close variant seems to work just fine.
|
|
|
|
|
Sometimes a UNION can run pretty quick. A simple GROUP BY will eliminate duplicates.
SELECT
TelPersonId
FROM
TelPerson
WHERE
@criteria1 IS NOT NULL AND
Investec LIKE '%' + @criteria1 + '%'
UNION
SELECT
TelPersonId
FROM
TelPerson
INNER JOIN
TelNumber
ON (TelPerson.TelPersonId = TelNumber.TelPersonId)
WHERE
@criteria2 IS NOT NULL AND
TelNumberText LIKE '%' + @criteria2 + '%'
GROUP BY TelPersonId
|
|
|
|
|
i am working on one application where i used sqlserver2005 reporting service.
i used oracle 10g as my datasource for the report.
i deployed report on server successfully.
but what my problem is , on server , where i deployed my report, oracle is not there. so it gives me error when i run report on server.
i want to set connectionstring for the report at runtime so that i can give reference to another server and deploy report on current server where oracle is not there.
i have need to set connectionsting at runtime bcz of when i generate report through report wizard in business intellegence. it takes service name as servername.
now what exactly i want to do is:
i want to deploy report on server having connectionstring to another server.
e.g. On server 'A' , i want to deploy report but connectionstring for the datasource includes server 'B'.
i want to include both servername and servicename in the connectionstring
software developer
|
|
|
|
|
Sorry but im not sure if it's called buffer, but im having a problem pasting all my create table statements in oracle sql*plus..
Not sure how to enlarge that "buffer"
Many thanks![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
I normally save my script as a SQL file, then use the SQL*Plus "start" command to run it.
|
|
|
|
|
Doh.. How??
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
|
The Following number is called an Attribute code
"120080200000"
These are 6 pairs. i want to chance the 5th pair to '10' and not tember with the other pairs. here is the query but it gives me undesirable results.
update property
set attrib_code = substring(attrib_code,1,8)+ substring(attrib_code,9,2)+ '10'
and substring(Attrib_code,11,2) + '00'
where property_id = 15985
Please Help
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: here is the query but it gives me undesirable results.
You should describe the undesirable results. That way we can concentrate on what is likely to be wrong rather than have to waste time reading the whole thing to figure it out.
If you are normalising your database (which is generally a good idea), the first normal form should split this out in to separate columns. If you need it all joined up you can always create a calculated column for that purpose. If you need it joined up and indexable then a trigger can be created to ensure that happens.
|
|
|
|
|
I understand, mybe you can explain in detail how the substring is working, there are more than 40 000 records, am a junior, i have used this before and it worked, this code i used for something within the organisation. its true am normalasing the table, can you please tell me
how the substring work , i try to google it, but the explanation were not clear, i know there is a starting position and replce position. in this case
xx xx xx xx xx xx i want to change the 5th pair only, but my query temper with the last pair and change the 5th pair please help
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: mybe you can explain in detail how the substring is working
See the documentation for SUBSTRING[^].
Vuyiswamb wrote: its true am normalasing the table, can you please tell me
I don't know anything else about your table. All I can see is you appear to be modifying only part of a column value. That suggests to me that the column breaks the first normal form. i.e. you should split out all values into separate columns.
SUBSTRING(Value, 1, 8) + ReplacementValue + SUBSTRING(Value, 11, 2) Value is the name of the column, ReplacementValue is the value you want to replace the 5th pair with.
|
|
|
|
|
Thank you it worked, infact we were talking abot the same thing, i did not understand you, but now i do. tell let me ask you something. have you ever modify a large number of records by mistake? if yes what did you do, and how did you feel after that?
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: have you ever modify a large number of records by mistake?
Yes.
Vuyiswamb wrote: if yes what did you do?
I restored the backup.
Vuyiswamb wrote: how did you feel after that?
Normal. Why?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
