|
I developed an project in vb for storing some quotations in sql db and displaying it on ASP web page on daily basis. when i am adding quotes in the database, whenever i am using single quotation mark i am getting some run time error .. i need a solution to solve this problem.
Give me an instant solution to rectify this problem
regards,
Tech_spidy
|
|
|
|
|
Hi
Replace single quotation with double quotation before sending to database.
it will be like this
comment's will be comment''s
Cheers
Navaneeth!!
|
|
|
|
|
hi Navaneeth,
thanks for ur immediate response.. see while displaying some motivational quotes like, it wouldn't look good.. In official sites we can't go display like this.
thanks for ur temprory solution. if you/anyone know the exact solution please reply..
regards,
Tech_spidy
|
|
|
|
|
Hi,
I think Navaneeth mend to say: Replace the single quotation by two single quotations.
Wout Louwers
|
|
|
|
|
Hi Tech_Spidy
Don't worry. In database only single quote will be stored. It won't store '' in table.
Cheers
Navaneeth!!
|
|
|
|
|
Thank you so much navaneeth..
wht u suggested is exactly working..
regards
Tech_spidy
|
|
|
|
|
Use parameters to insert strings in to the database. That way you don't have to escape quotation marks. And you improve the security of your application.
|
|
|
|
|
ok.. i will try tht.
thanks for ur response.
regards
Tech_spidy
|
|
|
|
|
In SQL 2000 there is some thing called
SET QUOTEDIDENTIFIER ON/OFF
Pls check this. would help you.
|
|
|
|
|
thanks for ur response krish. but i m using sql server for this wat navaneeth suggested is working exactly .
regards
Tech_spidy
|
|
|
|
|
Hello all
am creating simple application in vb.net 2005 sql server 2000 as my back end,
My problem is for gender identification am creating Radio buttons in the Frontend. How do I Specify data type (varchar/ navarchar/float) for that Radio buttons? How i store its value in the back End? Please help me
|
|
|
|
|
Hi
In my point of view, you can store the values as varchar. If it is male then store in table like M. When fetching the data, check if that is M.
Cheers
Navaneeth!!
|
|
|
|
|
Hello,
You can use bit data type if your gender is limited to male/female. If your gender is more than 2 types i.e. male/female/unknown then you can use tinyint or int.
Thanks
Mehedi Hasan
|
|
|
|
|
how i will do this in C#?
list all doctors whose birthday falls between the coming weeks Wednesday and next week Tuesday. The client will run this report every week. So say the client runs it on 12th February which is a Monday it will list all doctors whose birthday is between 14th-20th Feb.
|
|
|
|
|
try using these functions
getdate()
datepart()
dateadd()
|
|
|
|
|
Hi all,
How can I convert all the data that is present in SQL server in to XML format. If its big, then atleast provide me some link. Thank you.
Regards,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
Hi
Fill a dataset with your data from SQL database. User dataset's write XML function to create XML file.
OR
Read the database row by row and write each row using xml text reader
Cheers
Navaneeth!!
|
|
|
|
|
Sorry for the late reply, but I need it without using the .Net coding. And from SQL server tools or from any other database tools. Please help me if you could. Thank you.
Regards,
Mohd. Abdul Aleem,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
Hi ,
i've just started using slq server 2005 express. I know how to put a table into a dataset and then if i have two datasets i can make a relation between them via code[DataRelation].But why then , do we make relations in the database itself?
My scenario:
In my DB I have Three tables:
Persons : PID , Name
Items: ItID , Name
Purchases PID , ItID.
[there are 2 relations FK_Purchases_PID , FK_Purchases_ItID]
I have listboxes on my plain app , one of them is filled with the persons names. Now if i click a particular name i should get the corresponding purchases?
If i load each table into a dataset and then remake the relatioships via code it seems silly.
Would someone show me the best way to do the aforementioned?
I'm using C# 2.0 , .NET 2.0 and sql server 2005.
Thanks
Gideon
|
|
|
|
|
giddy_guitarist wrote: But why then , do we make relations in the database itself?
Because that's where the relationships are supposed to go. Datasets are ephemeral when compared to a database. Putting a relationship in a database is longer lasting and its existance will ensure data integrity across any and all applications that use the database.
giddy_guitarist wrote: If i load each table into a dataset and then remake the relatioships via code it seems silly.
Personally, I rarely ever use datasets. If anything is required from System.Data in the presentation layer I start questioning my design because there is probably something wrong with it. Other than for quick throw-away apps I ensure the data layer and presentation layer are quite well separated.
|
|
|
|
|
thank you for your quick reply.
giddy_guitarist wrote: But why then , do we make relations in the database itself?
What i mean is , whatever examples i've seen load tables into a Dataset then make relations in them! In my case , i need to Navigate from :
Person->Purchase->Item;
I have'nt seen code that can load relations from the database itself. So the only options would be to redo the relations in the dataset or execute a sql query or something?[im a complete beginner with sqlsevr 2005! and not very good at plain sql too!]
Yes , i'm just making a plain throw-away app to learn basic sqlserver. Or is there something on MSDN that would show me how to just get data from an sqlserver DB via C# code!. There are just some dumb wizard/ databinding examples.
http://msdn2.microsoft.com/en-us/library/ms186197(VS.80).aspx[^]
http://msdn2.microsoft.com/en-us/library/803kw7az(VS.80).aspx[^]
thanks
Gideon
|
|
|
|
|
giddy_guitarist wrote: Or is there something on MSDN that would show me how to just get data from an sqlserver DB via C# code!. There are just some dumb wizard/ databinding examples.
Look at what the wizards create (not the best example in the world, auto-generated code rarely is, but it will show you against your database). You will find a filename.designer.cs file which contains all the autogenerated code.
The basic sequence for accessing the database in your code is aquire-query-release. Like this:
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = queryOrStoredProcedureName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(parameter details);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
cmd.ExecuteNonQuery();
object result = cmd.ExecuteScalar();
while(reader.Read())
{
}
conn.Close();
Note: it is good practice to close the connection as soon as possible. The connections come from a pool so getting a new connection is quite fast.
You can also search MSDN on any of the class names given above. That will tell you more about what this does.
|
|
|
|
|
hi Colin,
I'm afraid i have to nag you for just a few more questions:
what i did was try to encapsulate your code into a method:
One in a public static class for filling a listbox:
public static void FillListBox(string query, ListBox theListbox)<br />
{<br />
using (SqlConnection conn = new SqlConnection(<br />
@"Data Source=.\SQLEXPRESS;AttachDbFilename=|path|\Experiment.mdf;Integrated Security=True;User Instance=True"))<br />
{<br />
SqlCommand cmd = new SqlCommand(query, conn);<br />
conn.Open();<br />
SqlDataReader reader = cmd.ExecuteReader();<br />
theListbox.Items.Clear();<br />
while (reader.Read())<br />
{<br />
theListbox.Items.Add(reader[0]);<br />
}<br />
reader.Close();<br />
cmd.Dispose();<br />
conn.Close();<br />
}<br />
}
And another local method to Execute inserts and deletes:
private void ExecEdit(string query)<br />
{<br />
using (SqlConnection conn = new SqlConnection(<br />
@"Data Source=.\SQLEXPRESS;AttachDbFilename=|path|\Experiment.mdf;Integrated Security=True;User Instance=True"))<br />
{<br />
SqlCommand cmd = new SqlCommand(query, conn);<br />
conn.Open();<br />
cmd.ExecuteNonQuery();<br />
cmd.Dispose();<br />
conn.Close();<br />
<br />
}<br />
}
Basically ,i have a simple hotel app that uses access. I have to upgrade it, since everyone was just talking about sqlserv05 i decided to use it too lol.I cant exactly call myself proficient at C# and i hardly know much about dbs , and oh yea , i'm 16
My questions are:
1. Theres a good load because sometimes i need data often and this queries the DB and causes some slightly noticeable lag. Thats why i had the Dataset in mind. 50% of the time , i dont need *live* data. I realized i cant have a method that returns an SqlDataReader without a global open connection.So how do i cache raw?
2.I have a PersID column in the persons table.Should i let it be an autonumber or Generate some hash because customers once removed are stored in an archive table.New and archived customers should'nt have same IDs , i noticed that even if a delete a customer with ID=2 , the next customer has an ID:3 . But i'm curious about where this is stored? what if i wanted to purge the DB of all customers so ID will start from 1 again?
3. This is slightly embarrasing but , the thing i have to install on my clients pc is the file on this page thats 53 mb right?
http://msdn.microsoft.com/vstudio/express/sql/download/[^]
or is there a *smaller* runtime pack
I know i need this to automate the intall correct?:
http://msdn2.microsoft.com/en-us/library/bb264562.aspx[^]
Thanks so much
Gideon
|
|
|
|
|
giddy_guitarist wrote: 1. Theres a good load because sometimes i need data often and this queries the DB and causes some slightly noticeable lag. Thats why i had the Dataset in mind. 50% of the time , i dont need *live* data. I realized i cant have a method that returns an SqlDataReader without a global open connection.So how do i cache raw?
I'd recommend creating a business layer that has your business objects in it. This separates the database from the user interface (which is regarded as best practice). However, that is quite a complex thing to explain in a forum post. You might want to do a search of "Design Patterns" to get an idea of some of the things you can do. Martin Fowler has a good reference guide on Enterprise Design Patterns and there are also the foundation patterns published by Grady Booch et al. The best introduction to the area is "Head First Design Patterns". It gives some great and easy to understand explanations, but the examples are in Java. If you can live with that I would recommend that book as a good starting point before delving in to the more academic books by Booch et al.
That aside, you can use a SqlDataAdapter to populate a DataSet . I don't tend to use them myself, so you might like to look them up in MSDN.
giddy_guitarist wrote: 2.I have a PersID column in the persons table.Should i let it be an autonumber or Generate some hash because customers once removed are stored in an archive table.New and archived customers should'nt have same IDs , i noticed that even if a delete a customer with ID=2 , the next customer has an ID:3 . But i'm curious about where this is stored? what if i wanted to purge the DB of all customers so ID will start from 1 again?
I'd stick with using an integer and having an IDENTITY set on the column. The smaller the key the more efficient it is. Using a GUID takes 4 times the space of an integer.
If you delete all rows from the table then the next row that is inserted will continue id sequence from where it left off. You can reseed the identity if you want, but I wouldn't bother. The most common reason I've wanted to do this was for testing. And if I'm testing I usually ensure that my whole test environment is reset - that means ditching the database and rebuilding it from a script.
giddy_guitarist wrote: 3. This is slightly embarrasing but , the thing i have to install on my clients pc is the file on this page thats 53 mb right?
Yes. SQL Server 2005 Express edition is quite large - but then again, it is increadibly powerful for how much you paid for it. (i.e. you get a lot of power for nothing).
Remember that a SQL Server is installed on one central machine (a server) and used by many clients. So, it doesn't need to be installed on every machine.
giddy_guitarist wrote: I know i need this to automate the intall correct?:
Unfortunately, I can't see what that is as MSDN isn't working for me at the moment.
|
|
|
|
|
hi Colin,
Yea , dont worry , i did do a good amount of reading on OO development , design patterns etc .. i'm kinda doing a three tiered app. UI, Business and Data.
My model isnt very *good* though.... i cant seem to seperate business from data sometime. A business operation ends up manipulating data. Like if a something is added to the customers bill , BillingService adds it to the Customers Dues , this is just copying the amount into the Dues table , so this class is somewhat a mix between a data and business entity. Or should i have a seperate class under the dataServies namespace just to put an amount under a customers due?
ok , i have a few more sqlserver questions:
1. When i create a new sql db via VS i get a bunch of xsc , xss , xsd files and a Dataset?[like myDBDataSet] What are all these files?
2. Why does an application setting class have to be created. The only sepecial property i see is the connection string. DO i have to use the above class to change the conn string , my string will be a little complex because the application works over a network and it has to query the network class for the right path to the DB.
About sql server , it just seemed odd that the developer and user has to download the same thing. lol
Thanks!
Gideon
|
|
|
|