|
Hello guys,
I want your help
I want to store different files (their data) into the data base how do I do that?
I have a table called Files with one blob field FileData, the table's structure is as follows
File(FileID IDENTITY(1,1), FileData text);
I am doing this application in MFC (VS 2005).
I accepted the file name from user, opened it using CFile::open method ,read data into TCHAR buff & inserted into DB as follows,
TCHAR szBuff[_MAX_PATH];
CString strSQL = _T("INSERT INTO Files(FileData) VALUES '%s'");
CString str = strSQL;
strSQL.Format(str,szBuff);
m_pDataBase->ExecuteSQL,strSQL);
tell me if I am doing mistake by taking a TCHAR array & what is the alternate way for it.
Remember that the files could be of any type & later stage I need to read the file data back.
I am new to MFC so please help me
Thanks in advance
|
|
|
|
|
I'm trying to generate the SQL scripts of a SQL Server database automatically by the use of the ScriptTransfer method of the Database2 COM class. It would have been nice if the DROP commands would be generated for the foreign keys too but it seems impossible. I've been playing with all the options of the Transfer object but all in vain: everything gets generated but the FK DROP statements.
I don't know if it is relevant or not but here are two fragments from the C++ code that i have used so far:
// ...
#define SQL_SCRIPTING (
SQLDMOScript_ClusteredIndexes |
SQLDMOScript_Indexes | \
SQLDMOScript_IncludeHeaders | \
SQLDMOScript_PrimaryObject | \
SQLDMOScript_Drops )
// ...
pTransfer->ScriptType=(SQLDMO_SCRIPT_TYPE)SQL_SCRIPTING;
pTransfer->CopyAllTables=VARIANT_TRUE;
pTransfer->CopyAllStoredProcedures=VARIANT_TRUE;
pTransfer->CopyAllFunctions=VARIANT_TRUE;
pTransfer->CopyAllTriggers=VARIANT_TRUE;
pTransfer->CopyAllViews=VARIANT_TRUE;
pTransfer->CopyAllObjects=VARIANT_TRUE;
pTransfer->CopySchema=VARIANT_TRUE;
pTransfer->DropDestObjectsFirst=VARIANT_TRUE;
Any workaround on this issue?
"quot capita, tot sententiæ"
rechi+
|
|
|
|
|
Hi all,
I want to get the data from tables of two different database.Is it possible
Pls help
thanks
lucky
|
|
|
|
|
you can select data from tables in different databases as:
Select A.Flds , B.Flds From Server1.db1.dbo.Table1 A<br />
Inner Join Server1.db2.dbo.Table1 B A.Fld = B.Fld
Regards,
Javed
|
|
|
|
|
what is the query for displaying records with a particular date eg. Feb 02 2006 and displaying records within a range eg. Feb 02 2006 to Feb 04 2006
in which format the user have to input the date in asp.net?
i need british format. in which format i have to store the date. Please give in detail.
Thanks in advance
|
|
|
|
|
dansoft wrote: in which format the user have to input the date in asp.net?
I always use ISO format when typing SQL in Query Analyzer, but for accessing the application through ADO.NET (ASP.NET is for web applications and has nothing to do with the database). I don't worry about the date format as I use parameters. For example
SqlCommand cmd = new SqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = "SELECT * FROM MyTable "+
"WHERE SomeDate BETWEEN @startDate AND @endDate";
cmd.Parameters.Add("@startDate", theStartDateTimeObject);
cmd.Parameters.Add("@endDate", theEndDateTimeObject);
SqlDataReader reader = cmd.ExecuteDataReader();
theStartDateTimeObject and theEndDateTimeObject are DateTime objects. If you use these then you don't need to know what format to write the dates in to the SQL String - and nor should you need to convert it.
The database should be used for storing information. You shouldn't really be doing any localisation functions with the database as that is all presentation layer stuff.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
can you please give me the code in vb.net format? i don't know c#.net
I need to display records with a particular date also. for eg. records having current date or any other specific date.
Thanks
|
|
|
|
|
dansoft wrote: can you please give me the code in vb.net format? i don't know c#.net
Are you serious? Its the same framework - the only differences are a few minor syntactical ones.
Dim cmd As SqlCommand
cmd = New SqlCommand()
cmd.Connection = myConnection
cmd.CommandText = "SELECT * FROM MyTable " & _
"WHERE SomeDate BETWEEN @startDate AND @endDate"
cmd.Parameters.Add("@startDate", theStartDateTimeObject)
cmd.Parameters.Add("@endDate", theEndDateTimeObject)
Dim reader As SqlDataReader
reader = cmd.ExecuteDataReader()
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
the value 1233.65774858
what i need 1233.65 but i am getting 1233.6500000000
vivek
|
|
|
|
|
Use Convert Function
convert(decimal(10,2), 1233.65774858)
Regards,
Javed
|
|
|
|
|
thanks mr. khan the method is really cool.
vivek
-- modified at 4:39 Monday 6th February, 2006
|
|
|
|
|
Hi
at the moment, I'm trying to delete all records in a table.
(1) What i do is create a dataAdapter that drags out all records and fill it into a dataset.
(2) go through each record in the dataset, and mark it as Delete
(3) Update the Database using Update from the Data Adapter.
This method seems rather slow and inefficient.
I was wondering is there another way of deleting all rows in a table without having to populate a dataset?
thanks
|
|
|
|
|
Try to use this:
Dim Conn As New SqlConnection<br />
Dim cmd As New SqlCommand<br />
Conn.ConnectionString = "Data Source=Server; Database = DB ; Integrated Security=SSPI"<br />
Conn.Open()<br />
cmd.Connection = Conn<br />
cmd.CommandType = CommandType.Text<br />
cmd.CommandText = "Delete From TableName"<br />
cmd.ExecuteNonQuery()
Regards
Javed
|
|
|
|
|
thanks a lot
your help is appreciated.
|
|
|
|
|
Hi
Say i have two tables in Access
Order and Order_Items where Order is the parent and Order_Item is the child and it is linked by the columns order_ID.
order_ID in the Order table is the primary key and done by autonumbering whilst order_ID in the Order_Items is a foreign key.
my problem is this. i have both tables and schemas put onto a dataset, where i create new rows, but i do not assign an order_ID for any of the rows i create because Access would autonumber them when i call an Update.
The problem is that how do i link Order_Items record with Order record in the dataset? would i have to update the database every time i create an Order record in order to get assigned an order_id before i can then create child items in the Order_Item table that link to this order_ID or is there some sort of feature in ADO.NET that allow you to link two records together without having to assign a value to the linking columns?
Thanks.
|
|
|
|
|
csharp_boy wrote: how do i link Order_Items record with Order record in the dataset?
well regarding linking the two tables ,I assume that u are already using a typed dataset and an xml schema with the relation for that schema as you have mentioned .
so in order to link the tables for creating new items or basically to ADD a row in a table that has a forign key you need to do this:
//define a new row just for adding it in the forignKey Field in the child table
//so my Typed Dataset is "DataSet_tll_tables"
//and you have to make the row from the class of Your DataSet
//and intilize it with DataSet Object that you are using
WindowsApplication1.DataSet_all_tables.OrderRow temp_row_for_adding = dataSet_all_tables1.Order.NewOrderRow();
//for loop to get values of the parent row in the parent table //just for adding a new row\\
for(int i=0;i
|
|
|
|
|
I'm trying to figure out why I keep getting a error searching my database with ado. Here is my search button
<br />
Private Sub CmdSearch_Click()<br />
Dim SQlnameSearch As String<br />
SQlnameSearch = txtSearch.Text<br />
Adodc1.RecordSource = " Select * FROM Customers WHERE (ContactLastName)= '" & SQlnameSearch & "' "<br />
Adodc1.Recordset.Requery <-- errors here <br />
Adodc1.Refresh <-- if the above line is commented out it errors here<br />
' want to fill the datagrid with the results of the search from above.<br />
DBGrid1.Visible = True<br />
End Sub<br />
Now if i build mt own connection like so
<br />
Dim cnn As New ADODB.Connection<br />
Dim rst As New ADODB.Recordset<br />
Dim fld As ADODB.Field<br />
<br />
' Open the connection<br />
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _<br />
"Data Source=" & App.Path & "\databases\PoolApp.mdb"<br />
<br />
strSearchCustomer = FrmSearch.Searchtxt.Text<br />
rst.Open _<br />
"SELECT ContactLastName FROM Customers WHERE ContactLastName = '" & strSearchCustomer & "' ", _<br />
cnn<br />
<br />
<br />
' Print the values for the fields in<br />
' the first record in the debug window<br />
For Each fld In rst.Fields<br />
<br />
MsgBox rst.Fields.Count <-- I get 1 record but unable to fill the datagrid. <br />
<br />
Next<br />
<br />
' Close the recordset<br />
rst.Close<br />
Any help would begreatly appreciated
Help is great only if you ask correctly
|
|
|
|
|
jlawren7 wrote: Help is great only if you ask correctly
You said it yourself! You say this code generates errors, but you never say what those errors are. It's kind of impossible to help you without knowing what the errors are.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
This error comes when using the adodc1.recordsource =
Runtime error '91'
object varible or With block varible not set
This line is highlighted in Yellow
Adodc1.Recordset.Requery
the other section ( built my own connection results in nothing )
Help is great only if you ask correctly
-- modified at 14:44 Sunday 5th February, 2006
|
|
|
|
|
You're calling Requery on a RecordSet object that is null, or Nothing in VB. You cal only call this method on a RecordSet object that has been returned by a previous query, if that previous query returned anything at all.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Well since i have tried to go a different route
Now I'm dtuck with filling a dtagrid witrh the table contents. Then once that is working I would like to use a sql search to get the records i want
here is what I have now
<br />
Option Explicit<br />
<br />
' Create a Recordset<br />
Dim rst As ADODB.Recordset<br />
<br />
Private Sub Command1_Click()<br />
<br />
Set rst = New ADODB.Recordset<br />
rst.CursorLocation = adUseClient<br />
<br />
' Add columns to the Recordset<br />
rst.Fields.Append "Customer ID", adInteger<br />
rst.Fields.Append "First Name", adVarChar, 40, adFldIsNullable<br />
rst.Fields.Append "Last Name", adVarChar, 40, adFldIsNullable<br />
rst.Fields.Append "Address", adVarChar, 60, adFldIsNullable<br />
rst.Fields.Append "Phone Number", adInteger<br />
' Open the Recordset<br />
rst.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Testing\v003\databases\db1.mdb; Persist Security Info=False"<br />
<br />
<br />
' Populate the Data in the DataGrid<br />
Set DataGrid1.DataSource = rst<br />
End Sub <br />
<br />
A simple datagrid, command button on a form <br />
|
|
|
|
|
Man, you are really confused about these object works.
You didn't perform a query against that database at all. All you did was create a blank recordset, add some columns to it, then bound the empty recordset to a datagrid.
You need to actually execute a query against the database. Something like this will return all the records in the specified table:
Dim rs As New ADODB.Recordset
Dim conn As New ADODB.Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"C:\Program Files\Testing\v003\databases\db1.mdb;Persist Security Info=False"
rs.CursorLocation = adUseClient
rs.Open "tableName", conn, adOpenStatic, adLockReadOnly, adCmdTable
Set DataGrid1.DataSource = rs
This probably won't run as listed. I haven't used VB6 in over 5 years now...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
connection is dao, os is winxp, I want to disable SSPI. do you know how it is possible?
|
|
|
|
|
this query show error
SELECT distinct jr.txtjcode FROM jobmast J,JobsRound JR WHERE j.txtjcode=jr.txtjcode and and convert(smalldatetime,j.dtcompletion)>= CONVERT(nvarchar(11),getdate()) ORDER BY jr.txtjcode asc, j.datecompletion asc
erro is
Server: Msg 145, Level 15, State 1, Line 1
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
i want to show jr.txtjcode in asc order of datecompletion is a date
All I ever wanted is what others have....
CrazySanker
|
|
|
|
|
SELECT distinct jr.txtjcode,j.datecompletion FROM jobmast J,JobsRound JR WHERE j.txtjcode=jr.txtjcode and convert(smalldatetime,j.dtcompletion)>= CONVERT(nvarchar(11),getdate()) ORDER BY jr.txtjcode asc, j.datecompletion asc
include the j.datecompletion field in the select list.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
