|
new_phoenix
Try: strTextBox.Text.Length
ken
|
|
|
|
|
Does anybody have some code to separate the directory path from the directory path and file name combination? Please provide some assistance...
try using dir() like this..
<br />
dir(txtOutputFilePath.text)<br />
im using it on vb6 hope it helps you..
|
|
|
|
|
hi
my aim is to create a ms access database table using c#.net
query for creating a table which i am using is
create table tab
(
name varchar(30),
dateofbirth datetime,
photo ole object
)
now the error is coming at ole position please suggest me what database type should i replace from Ole object to get rid of the problem
i will be heartly thankful to ......U.......
regards
sindhu tiwari
Always Innovative
|
|
|
|
|
use the key word image instead
create table tab
(
name varchar(30),
dateofbirth datetime,
photo image
)
cheers
Raz
/*
Ghazi Hadi Al Wadi, PMP, ASQ SSGB, DBA
*/
|
|
|
|
|
Hi all,
I have a SQL2005 database running in my PC.I would like to keep a back up to a CD.However i am not sure which files i have to copy.
When i try to copy database primary Datafile in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
It Comes up with an error saying file is being used,can't copy.
Please advice
Thanks
|
|
|
|
|
Copying files is not the right way to do it.
You should create a backup for the database as described here[^]
you get "file is being used" because SQL Server service opens the file.
|
|
|
|
|
Thank you very much.Its very helpfull.
After having the file forinstance BackUP_database.bak.Does it mean that this file contains all the script for creating the database together with the datas stored in table.
Thanks
|
|
|
|
|
Yes. If you use full backup option.
|
|
|
|
|
Hi Frieds.
how can i Insert Multiple rows from frontend through a single query.
thanx in advance..
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
|
hi
Please clarify your question
regards
Joe
|
|
|
|
|
I m Using .Net as Front end, in code behind i hv a datatable which has multiple rows (row count is variable),
And now i want to insert this data of datatable into database through a single SP/query..
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
Use Databasename
GO
INSERT INTO tablename(Fieldname)
SELECT 'raj'
UNION ALL
SELECT 'mukesh'
UNION ALL
SELECT 'aneesh'
UNION ALL
SELECT 'pradeep'
UNION ALL
SELECT 'kishore'
GO
try this...
|
|
|
|
|
Thanks
but i can not use this type of query, because row count is variable and i want to insert all row at a time.
Amit Metkar
3i-infotech, Mumbai.
|
|
|
|
|
I think we can't get directly...additionally we have to use temp table like following query...
INSERT INTO mainTable SELECT * FROM tempTable;
|
|
|
|
|
Pass it as xml and use OpenXml in the stored procedure?
|
|
|
|
|
Hi
I am using an Oledb connection in my application.
My connection string is
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; datasource=C:\\Project\\DataBase.mdb");
and I am getting Oledb Exception at
OleDbDataReader dr = cmd.ExecuteReader();
What is the problem,help me
Thank u
Deepak
|
|
|
|
|
whats the command u r using
its me sid
|
|
|
|
|
Hi
This is my command
OleDbCommand cmd = new OleDbCommand("select * from Employee where EmpID=" + ListBox1.SelectedValue,con);
Thank u
Deepak
|
|
|
|
|
write this one
oledbcommand cmd = new oledbcommand("select * from employee where empid = @a",con)
cmd.parameters.addwithvalue("@a",listbox1.selectedvalue.text)
its me sid
|
|
|
|
|
Thank u! It's working
Could u explain why the previous one did not work?
Thank u
Deepak
|
|
|
|
|
see for everything there are predefined
steps
follow that
u r problem was incorrect syntax in the query.........
sindhu tiwari
(Electrical and Electronics Engineer)
its me sid
|
|
|
|
|
hi
i wanna create a table in access database with few fields
my query is
create table tab
(
name varchar(30)
)
now this is working fine
but what for a ole object
create table tab
{
photo Ole object
}
is giving error
please solve this
regards
sindhu tiwari
its me sid
|
|
|
|
|
.net expert u have not understood my problem
i know how to store a photo and retrive it my problem is creating a table
dynamically throug c# code which has a field with data type ole object
regards
sindhu tiwari
no one is expert everyone is still in learning stage
its me sid
|
|
|
|
|
HI,
My aim is to create a table in ms access database the field names,data types and the size will be given dynamically
If any one knows how to create ms access datatable please let me know
as i am struck at this position in my project
Regards
Sindhu Tiwari
its me sid
|
|
|
|