Re: Create Table Query - Database Discussion Boards

Re: Remembering the Query ResultsSet across Pages in a GridView

Brian C Hart2-Nov-07 7:18

Brian C Hart

2-Nov-07 7:18

I found a solution that worked for me....my SqlDataSource.FilterExpression in the page code is:

<asp:SqlDataSource ID="SqlDataSource1" ... FilterExpression="{0} LIKE '%{1}%'">
<FilterParameters>
          <asp:ControlParameter ControlID="SearchField" Name="field" PropertyName="SelectedValue"  Type="String" />
          <asp:ControlParameter ControlID="Value" Name="value"
                        PropertyName="Text" Type="String" />
</FilterParameters>

To solve my problem above, I handled the GridView.PreRender event like so:

protected void GridView1_PreRender(object sender, EventArgs e)
{
    SqlDataSource1.FilterExpression = "{0} LIKE \'%{1}%\'";

}

Basically, I just re-initialized my FilterExpression every time the GridView.PreRender event is fired. Thanks to you all.

Getting the length of a TextBox in VBA...

new_phoenix2-Nov-07 6:21

new_phoenix

2-Nov-07 6:21

How would I get the length of a textbox using VBA when there is no such code such as:

Dim intIndex, intIndexMax As Integer
intIndexMax = txtOutputFilePath.Length  // no such thing as txtOutputFilePath.Length
For intIndex = intIndexMax To 0 Step -1
   // try to find the directory path and separate it from the file name by using InStr to find the last \
Next

Does anybody have some code to separate the directory path from the directory path and file name combination? Please provide some assistance...

Re: Getting the length of a TextBox in VBA...

Paddy Boyd2-Nov-07 6:44

Paddy Boyd

2-Nov-07 6:44

Use a ruler?

(Or maybe something like txtOutputFilePath.Value.Length)

Re: Getting the length of a TextBox in VBA...

new_phoenix2-Nov-07 7:33

new_phoenix

2-Nov-07 7:33

I think that I may not have stated my question clearly. What I meant was the length of the string value in the textbox not the width of the actual textbox as an object on the form.

I tried to assign the value to a string and to check that but I cannot get the strTextBox.Length value either.

Instead, I decided to use the FileDialog Common Dialog control. However, I am having some trouble retrieving values from that control as well. Please see the message above.

Re: Getting the length of a TextBox in VBA...

BrokenS2-Nov-07 11:59

BrokenS

2-Nov-07 11:59

new_phoenix

Try: strTextBox.Text.Length

ken

Re: Getting the length of a TextBox in VBA...

anthoy4-Nov-07 21:25

anthoy

4-Nov-07 21:25

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..

Create Table Query

sindhutiwari2-Nov-07 2:53

sindhutiwari

2-Nov-07 2:53

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

Re: Create Table Query

Ghazi H. Wadi2-Nov-07 22:12

Ghazi H. Wadi

2-Nov-07 22:12

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
*/

SQL DATABASE BACKUP

kibromg2-Nov-07 0:51

kibromg

2-Nov-07 0:51

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

Re: SQL DATABASE BACKUP

Hesham Amin2-Nov-07 1:15

Hesham Amin

2-Nov-07 1:15

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.

Hesham A. Amin
My blog

Re: SQL DATABASE BACKUP

kibromg2-Nov-07 1:55

kibromg

2-Nov-07 1:55

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

Re: SQL DATABASE BACKUP

Hesham Amin2-Nov-07 23:00

Hesham Amin

2-Nov-07 23:00

Yes. If you use full backup option. Smile | :)

Hesham A. Amin
My blog

how can i Insert Multiple rows from frontend through a single query

Amit.Amit.Amit...1-Nov-07 23:15

Amit.Amit.Amit...

1-Nov-07 23:15

Hi Frieds.

how can i Insert Multiple rows from frontend through a single query.

thanx in advance..

Amit Metkar
3i-infotech, Mumbai.

Re: ,

r a j u u1-Nov-07 23:16

r a j u u

1-Nov-07 23:16

hi..

Re: ,

joemonvarghese1-Nov-07 23:20

joemonvarghese

1-Nov-07 23:20

hi
Please clarify your question

regards

Joe

Re: ,

Amit.Amit.Amit...1-Nov-07 23:48

Amit.Amit.Amit...

1-Nov-07 23:48

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.

Re: how can i Insert Multiple rows from frontend through a single query

r a j u u1-Nov-07 23:30

r a j u u

1-Nov-07 23:30

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... Smile | :)

Re: how can i Insert Multiple rows from frontend through a single query

Amit.Amit.Amit...1-Nov-07 23:51

Amit.Amit.Amit...

1-Nov-07 23:51

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.

Re: how can i Insert Multiple rows from frontend through a single query

r a j u u2-Nov-07 0:00

r a j u u

2-Nov-07 0:00

I think we can't get directly...additionally we have to use temp table like following query...

INSERT INTO mainTable SELECT * FROM tempTable;

Re: how can i Insert Multiple rows from frontend through a single query

Paddy Boyd2-Nov-07 6:47

Paddy Boyd

2-Nov-07 6:47

Pass it as xml and use OpenXml in the stored procedure?

Getting "No value given for one or more required parameters" OledbException?

Deepak Koduri1-Nov-07 21:32

Deepak Koduri

1-Nov-07 21:32

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

Re: Getting "No value given for one or more required parameters" OledbException?

sindhutiwari1-Nov-07 21:39

sindhutiwari

1-Nov-07 21:39

whats the command u r using

its me sid

Re: Getting "No value given for one or more required parameters" OledbException?

Deepak Koduri1-Nov-07 21:43

Deepak Koduri

1-Nov-07 21:43

Hi
This is my command
OleDbCommand cmd = new OleDbCommand("select * from Employee where EmpID=" + ListBox1.SelectedValue,con);

Thank u
Deepak

Re: Getting "No value given for one or more required parameters" OledbException?

sindhutiwari1-Nov-07 21:45

sindhutiwari

1-Nov-07 21:45

write this one
oledbcommand cmd = new oledbcommand("select * from employee where empid = @a",con)
cmd.parameters.addwithvalue("@a",listbox1.selectedvalue.text)

its me sid

Re: Getting "No value given for one or more required parameters" OledbException?

Deepak Koduri1-Nov-07 21:51

Deepak Koduri

1-Nov-07 21:51

Thank u! It's working

Could u explain why the previous one did not work?

Thank u
Deepak

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.