|
Can any one make it syntactically correct 2 use inside c#
"SELECT Word,Category,Number,Gender,Person,Degree,ObjectType,Tense,Aspect,Mood,Comp1,Comp2,Comp3,Theta1,Theta2,Theta3 FROM HindiLex,Attributes,SubCategoryFrames,ThematicFrames where HindiLex.Word = N'"+word+"'" and HindiLex.AttrNo = "Attributes.AttrNo%" and HindiLex.LexSCFNo = SubCategoryFrames.LexSCFNo and HindiLex.ThemSCFNo = ThematicFrames.ThemSCFNo";
|
|
|
|
|
You can't write a query in C#, all you can do is pass the query from C# to your database. What database are you using ? You should read some of the articles on this site, I'm sure there's one for connecting to whatever DB you use.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Yes U R Right,
I wanna pass Query fm C#.
so for passing the query string syntax changes inside c#, is nt it...
i want that string syntax.
i am using SQL sERVER AS DB.
If possible pls modify to make it syntactically correct, thank U
|
|
|
|
|
cshivaprasad wrote: so for passing the query string syntax changes inside c#, is nt it...
Nope - C# is just calling SQL Server, so the syntax has to be what SQL Server expects. If you put a @ at the front of your string, as in
string s = @"this is the string";
then the only special character is to use "" for ". Otherwise, it's verbatim.
cshivaprasad wrote: If possible pls modify to make it syntactically correct, thank U
What is the reason for htis question ? Have you connected to the DB and had an error about syntax ? Where are you putting this SQL ? Are you creatings Connection objects and so on and connecting to SQL Server ? Have you tried your SQL inside SQL Server to make sure it's good there ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
This code is susceptible to SQL Injection Attacks. You inject a variable called word into the query string. You should use parameters instead. See SQL Injection Attacks and Tips on How to Prevent Them[^] it will give you information on how to call SQL from C#
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
I want to create some database objects (tables, stored procedures etc) from a TSQL script. The script is stored in an ASCII txt file, and was generated using the MS SQL Manager's "Generate SQL script" option.
This is my problem : the script file contains formatting (line breaks, tabs etc), TSQL comments and so forth. If I simply load the contents of the script file into a string variable, and execute this from my C# code the way I would any ad-hoc SQL command, the ASCII-text formatting breaks the SQL. For example,
"SELECT *
FROM MyTable;"
now becomes
"SELECT *\r\nFROM MyTable;"
This is not valid SQL, and an exception is thrown. If I parse out all the ASCII formatting (and TSQL comments etc), I can execute a very large TSQL script file as an adhoc SQL command with no errors. This is great, except that my stored procedures now lose all their nice formatting and comments, making them difficult to read.
So ... is there some way to execute an ASCII-formatted TSQL script from C# code without having to strip all the ASCII formatting out?
Thanks in advance!
|
|
|
|
|
spazzman wrote: This is not valid SQL, and an exception is thrown.
I doubt it is that because I have done that and it works perfectly. The only thing you need to parse out of the script are the GO statements as these are instructions to Query Analyzer and not SQL. The GO is a batch delimiter - In other words execute the bits between the GO statements as separate SQL commands from the .NET application.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Eek. I can't believe I missed that Thanks for pointing it out to me!
|
|
|
|
|
Hi,
My query looks like this
select distinct lh.id, od.storename
FROM LPNHeader lh
LEFT OUTER join LPNDetail ld on lh.Id = ld.LPNHdrId
LEFT OUTER JOIN OrderDetail od on ld.OrderDtlId = od.Id
INNER JOIN OrderShipmentLPN OSL ON LH.id = OSL.LPNHdrId
INNER JOIN ShipmentHeader sh on sh.id = osl.shipmentHdrId
WHERE sh.Id = 25
and the results are
346 SN1
347 SN1
347 SN2
348 SN2
348 SN3
349 NULL
I want to finetune this query to return distinct lh.id's, like given below
346 SN1
347 SN1
348 SN2
349 NULL
Tried distinct, group etc. I think that I am missing something, anybody any ideas. Thanks
|
|
|
|
|
Use a subquery to return the first storename for each id:
select distinct LPNHeader.id,<br />
Storename = (<br />
SELECT <br />
TOP 1 oh.storename <br />
FROM<br />
LPNDetail ld<br />
LEFT OUTER JOIN OrderDetail od on ld.OrderDtlId = od.Id<br />
INNER JOIN OrderShipmentLPN OSL ON LH.id = OSL.LPNHdrId<br />
INNER JOIN ShipmentHeader sh on sh.id = osl.shipmentHdrId<br />
WHERE <br />
LPNHeader.Id = ld.LPNHdrId<br />
AND sh.Id = 25<br />
)<br />
FROM<br />
LPNHeader
|
|
|
|
|
I've created a site with italian server and sql database that handle date time of type: ddmmyy
this site uploaded on an international server trow exception on date type:
how can i config out the date on web.config file to avoid these errors?
|
|
|
|
|
I am looking for some advise on the best practice of returning data in a datatable. Is using a DataAdapter and DataSet as shown below the best or only method?
public DataTable GetCompanyList(string strDBConnString)
{
SqlConnection oConnection = new SqlConnection(strDBConnString);
try
{
string sSQL = "SELECT * FROM Company ORDER BY CompanyName";
SqlDataAdapter oDataAdapter = new SqlDataAdapter(sSQL, sConnString);
oConnection.Open();
DataSet rDataSet = new DataSet();
oDataAdapter.Fill(rDataSet, "CompanyList");
return rDataSet.Tables[0];
}
catch (Exception e)
{
//Log error message and return null
return null;
}
finally
{
oConnection.Close();
}
}
|
|
|
|
|
Does anyone have ny idea about how to take incremental backups in MySQL? I am using the mysqldump command from the command prompt as follows:
mysqldump -uroot -proot --delete-master-logs qasync > backps/final6.sql
but everytime I take backup, it is the whole backup and not incremental.
|
|
|
|
|
|
I have tried all of this. But it does not work. If ny of you has mysql server installed, I would request you to try it out. This will give full backup and not incremental.
|
|
|
|
|
i try to find help here with ijvm assembly language and i cant find it. can u help me pliz?
|
|
|
|
|
to get an answer, you should first ask the right forum...
then, be sure that everyone can understand what you mean (for example, by not considering people knowing what ijvm is)...
one more thing : be pleasant over the forum, otherwise no one will help you. cross posting the forums under several acounts (referring this[^]) will never deserve you...
TOXCCT >>> GEII power
[VisualCalc 3.0 updated ][Flags Beginner's Guide new! ]
|
|
|
|
|
I am using .net 1.1 /sql server 2000, recently moved from the old Application block to Entlib data application block June 2005.
In all our applications we store the connection string in web.config file using custom encryption (VB dll).
ex: <add key="ConnectionString" value="2D2F447DA70A2CF1E1A61F2475B3D7F67592A67ACF108FFE9E08CFCE3C6463B5C175B6E6A5"/>
we used to decrypt the same and pass the conn string to sqlhelper. The new DAAB provides only :
Dim db As Database = DatabaseFactory.CreateDatabase()
without an option to pass connection string, i can use the dataConfiguration.config to store connection string but how to encrypt and decrypt. I cant use clear text for connection strings any other encryption methodology also cant be used.
Please help i am unable to find a solution, code snippets are very much needed.
|
|
|
|
|
Hi all,
We are writing a window service which tries to access a database server on
different network.
while connecting to one of the database it give error saying 'EXECUTE
permission denied on object 'sp_sdidebug', database 'master', owner 'dbo''.
But if we are trying to connect to the same Database with any web or windows
application it does not raise any error and we are able to connect to that
DB.
Thanks for your help
Praveen
|
|
|
|
|
Praveen_S wrote: But if we are trying to connect to the same Database with any web or windows
application it does not raise any error and we are able to connect to that
DB.
The error message you receive shows that you are actually connected to the database - otherwise it could not tell you about the individual access permissions on database objects.
The error is because the user you are connecting as does not have permission to EXECUTE the stored procedure. Check the account that is being used to connect to the database and check that account has sufficient privileges to run the desired stored procedure.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Uncheck 'Enable SQL Debugging' in Project Properties. This likely doesn't happen for anyone else because this is one of the options stored in the .user file (e.g. myproj.csproj.user), which is generally not placed under source control.
That's assuming you're getting that error when trying to debug. If you're getting it at some other time I don't know what's wrong.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
This is on SQL Server 2000, I don't think it's possible, but maybe there is some way of doing it, or another better idea?
If I have two tables, and I want to insert a new record into both of them, and at the same time set a field in one table to be the identity inserted field in the other, can that be done? e.g. the SQL I'd want to work would be for example:
insert into tablea inner join tableb on tablea.bid = tableb.id( a, b, c, bid ) values( 1, 2, 3, tableb.id)
|
|
|
|
|
|
OK, thanks, that's a good idea. But the question still remains about the SQL to use in the stored procedure.
|
|
|
|
|
You can retrieve the value of the identity column from the last insert performed using the @@IDENTITY variable. Due to the action of triggers, however, this can be the wrong value if one or more triggers that fired also performed an insert. On SQL Server 2000 and later the SCOPE_IDENTITY() function is a better choice.
So something like:
INSERT INTO tableb( c )
VALUES( 3 )
INSERT INTO tablea( a, b, bid )
VALUES( 1, 2, SCOPE_IDENTITY() )
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|