|
Open the table in MS Access in the design-view, and set Index to "Yes (No Duplicates)". Set Required to "No" and Allow zero length to "Yes".
That should do the trick 
I are troll
|
|
|
|
|
It is not working because Unique required only one null value. So I run the form first time it takes one blank column but when next time I run the form it given an error of the duplicate records.
|
|
|
|
|
hi
in my project i convert excel file in xml and then upload the file in data base . here i use SQL Server 2005. In my excel file consist one record D'Souza when such name comes program throw run time exception as Incorrect syntax near 'Souza
i use following query for insert a record
string istr = "insert into sheet1(Personnel_Area,EE_Grp,Employee_Group,ESgrp,Employee_Subgroup,Cost_ctr,Cos
t_Center,PSubarea,Personnel_Subarea,Peres_no,Personel_Number,Designation,D
esigna,Pos,Age_of_Employee,Birthdate,Complete_name)values('" + Convert.ToString(dataGridView1.Rows[i].Cells[0].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[1].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[2].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[3].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[4].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[5].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[6].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[7].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[8].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[9].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[10].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[11].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[12].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[13].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[14].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[17].Value.ToString()) + "','" + Convert.ToString(dataGridView1.Rows[i].Cells[18].Value.ToString()) + "')";
need a help
|
|
|
|
|
You seem to be quoting your values using single quote (i.e. ') character.
So the ' in D'Souza is taken to be the end of the value.
Have a look at how Transact-SQL deals with quoted strings and the use of single (i.e.') and double (i.e. ") quotes.
Regards
David R
|
|
|
|
|
Hi,
I have a view. i want to get the columns in a view along with its database and servername.
For example, Employee table resides in CSCEmp server's Emp database.
I have a view in CSCDet server that will have a column "EmpName" of [CSCEmp's] Employee table.
When i list view information, i want to display like
view view'sserver Columnname column'sServer
EMPView CSCDet EmpName CSCEmp
Is there a way to do like this.
Thanks.
|
|
|
|
|
Look into the information schema views (under system views in management studio) or sysobjects in 2k. These will give you all the information about SQLs internal structures.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi, as i said. i have a windows form application within the internal organisation users and a web appplication hosted with some hosting company for external users. Both application need to share a common databse? how to share and where to place the databse?
Also is this the same case to share database among different users within the company using windows forms application?
|
|
|
|
|
So you have asked this question 8 times including in the Lounge - I'm bloody sure there were some excellent answers in there, go away and do some work.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
oh its really great to know that some one is hear just to count the questions and for any other --- Else.. I thought i can get some codes without doing any work at all..lol...according to your valuable stupid sugestion i will do my work lol....!If you dont know the answer better dont reply to people..and i am bloody sure that i asked the question only twice, one in C# forum and other in database forum... C# forum people suggested me to ask there lol... read the posts before comment (do your work first  )... 
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Oops 
My apologies - I did not read follow the links to the questions.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I'm searching for logic which will help me to retrieve table records based on "start index" parameter and parameter which specifies the returned records count. Example:
dbo.Records
num
1
2
3
4
5
SELECT num FROM dbo.Records will return 5 records. I cant find a function or something other which will help me retrieve the following logic
input params : @startIndex = 2 , @recordsCount = 2
so when i perform the select statement to retrieve the 2 records (3 and 4)
If there is no answer with an exact function, is there a wordaraund ?
Please help.
Regards Hris.
|
|
|
|
|
try this ...
select top @recordsCount num from dbo.records where num >= @startIndex
You may also be able to use something like this ...
select num <br />
from dbo.records <br />
where (num >= @startIndex) and (num <= @startIndex + @recordCount)
I haven't tested it, but it is probably close.
|
|
|
|
|
Hii
I am storing images in my sql server 2005 database. Is there any sql query or any other way to get the size of the image stored in my table?
Thanks in Advance
|
|
|
|
|
SELECT DATALENGTH(imagecolumn) FROM sometable
|
|
|
|
|
Hi ppl
Take a look a simple query.
String sql = (@"
SELECT Ins_ID, Ins_Nm
FROM Institution_Profile
WHERE Ins_ID = '{0}'
", combobox.Text);
If the query above works perfect without no erro then why the below query is not working.
String sql = (@"
SELECT Ins_ID, Ins_Nm
FROM '{0}'
WHERE Ins_ID = '{1}'
", tableName.text, Ins_ID.Text);
Anybody ans this pls
Thanks
|
|
|
|
|
It might be that you have made a typo.
Try changing tableName.text, Ins_ID.TexttableName.Text, Ins_ID.Text.
But on the other hand it could be anything. If you ask a question about an error, tell people what the error is and which part of the posted code gives the error, otherwise most members will ignore you.
Also please don't use text speak in your posts. We older folks don't understand it and once again you are cutting down the number of people willing to help you.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Remove the single quotes from the tablename: FROM '{0}' becomes FROM {0}.
|
|
|
|
|
Fantastic....Worked
Thanks dude
|
|
|
|
|
This continues to be vulnerable to SQL Injection attacks.
|
|
|
|
|
To paraphrase dialog from the film 'Riddick': The CPer in me says that he has only just started learning SQL and nobody has given the little bit of help that he needs to continue with his project. However, the pedant in me says that I should tar and feather him for not following established best practice at all times; Ignorance of the Law is not a defence.
|
|
|
|
|
You should be using parameterised queries rather than injecting values into a SQL Statement. This is easy for data elements like the ID value, but slightly more difficult, yet doable, for the table name. As it stands your code is vulnerable to attack.
|
|
|
|
|
How to retrive attribute Name
<names>
<zipcode zc="*">
<rule rll="%LEIN">
Here the thing is in some Names tag the attribute of Rule is RL or RLL.
<rule rll="%LEIN">
<rule rl="LE%">
I am getting error at bold line below. Bcz, i mentioned direcly RLL. If RL exists as attirbute then getting error. how to get attribute name?
XmlNodeList NameList = doc.GetElementsByTagName("Names");
foreach (XmlNode node in NameList)
{
XmlElement nameElement = (XmlElement)node;
foreach (XmlNode xnode in nameElement)
{
XmlElement childElement = (XmlElement)xnode;
if (childElement.Name.ToLower() == "rule")
{
if (childElement.HasAttributes)
strrule = childElement.Attributes["RLL"].InnerText.ToLower();
}
}
}
G. Satish
|
|
|
|
|
Don't want to give stored proc to client? What are your options if there is one?
Thanks
dev
|
|
|
|
|
devvvy wrote: Don't want to give stored proc to client
Then don't
Have you considerd encrypting it?
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
I didn't know you can encrypt them? (stored proc in db owned by client)
dev
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
