|
i am using vb.net.Its asp calender control that is inserting the date withit or it is the sql datatype that is storing it like that.If u can tell in detail how ca i ,i will b very greatful
Take it easy...
|
|
|
|
|
Sorry, I don't know VB.NET quite well so I don't know if it's the control that inserts the data with the date and time or is the db that store the data in that way. You'd debug your code to know this item.
MArc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.
|
|
|
|
|
The SQL DateTime type always includes both date and time (wouldn't that seem obvious from its name?). How you choose to display that is up to you. See if the display format for the datagrid column can be changed.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
While selecting from database itself convert it to date only format, then datagrid will show the same(Date Only)
select CONVERT(VARCHAR(10), DateTimeField, 103) AS DateOnly from tbl_Name
/*Above for date only*/
go
select DateTimeField AS DateandTime from tbl_Name
/*Abovefor date and time only*/
|
|
|
|
|
Thanks 4 repling i will try it and then let u know
Thanx Again
Take it easy...
|
|
|
|
|
Hi Buddy Could you please tell how can i set date/time datatype custom format in SQL like in MS Access [dd/MM/yyy].
I mean i want to store date in day/month/year [27/07/2005].
Muhammad Waqas Butt
waqasb4all@yahoo.com
|
|
|
|
|
|
Hi ALL
I want to create hyperlink column in datagrid.And i want to create it with the option auto generate columns.Can any one tell me how can i do this with this option its very to create with auto generate column = false, but with true?????????????
Thanking u in anticipation
Take it easy...
|
|
|
|
|
Hi Dears
I want to ask that if there is some query some thing like it
"select * accept oneColumn from table"
I want to do this bcz there r many columns in table and i dont want to write the names of all.If i dont want to select one column what can i do................
Thanking you in anticipation
Take it easy...
|
|
|
|
|
I don't think it's possible: the WHERE clause limits rows nor columns. So you'll have to list all the columns ... unless you want to use a bit of script/prequery that gets a list of all columns and then build a new query based on that.
Marc Soleda.
... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.
|
|
|
|
|
There is no syntax support for this in SQL. You can select all (*) or a list.
if you want to exclude a column you will have to type the entire list.
You could create a view in the database the excludes that column, and select * from the view...
Or you could select * from the table and just not use/display the column you aren't interested in.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
if you are using front end then limit the width size to zero. for that the columns you don't like to display.
|
|
|
|
|
Hello all,
I'm working on a webpage with access db using ADO.NET.
I made a web form that is causing me the glorious "Unspecified Error".
It happens when i refresh a page for 21 times (when the aspnet_wp process becomes too big to handle), what makes me believe that it may be a connection left unclose. Although i've checked all the connection and it seems pretty okay to me.
Do you know any way to view how many (and which ones if possible) connections are open?
Thanks a lot in advance.
- ASP.NET and C# -
- ASP.NET and C# -
|
|
|
|
|
Please can any one tell :
How can i find out how was deleted rows in
Microsoft SQL Server 2000
-is there any Tracing for users in MSSQL Database
agmb
|
|
|
|
|
make a table with the following rows
rowid
tablename
deletedby
In the delete trigger populate this table. This is a simple implementation of the audit trail.
Live Life King Size
Alomgir Miah
|
|
|
|
|
Is it possible to use a dataview to return multiple rows using two keys for the column? The result set must be based on two condition in the sort function for example, dataview.Sort = "Col1, Col2".
Now, how do I use the FindRows function to use 2 keys or do I use a different function? Should I forget the idea of using a dataview and stick with a datatable?
Thanks a lot!
|
|
|
|
|
subclass override and give your own implementation
Live Life King Size
Alomgir Miah
|
|
|
|
|
Dear Ixhan,
You can do this by using rowfilter property or select method for table of dataview.
This way u will get a set of rows that can be stored in other rowset or bind to a datagrid.
If it works then reply me.
|
|
|
|
|
My delete command is “DELETE FROM parentTable WHERE id = @id_Orig” for dataAdapter1 and “DELETE FROM childTable WHERE id = @id_Orig” for dataAdapter2(+ corresponding parameters). Then I call the parentRow.delete() command to delete the rows. Finally I call:
dataAdapter1->Update(parentTable);
dataAdapter2->Update(childTable);
This works if I only have ONE child row for that parent row. However, I get a System.Data.DBConcurrencyException if the parent row has multiple child rows. Why does this happen? Is this because adapter2 is trying to delete rows already deleted? If so how can I fix this? Thanks so much.
|
|
|
|
|
I'm using DataBinding to create a software. I use wizard to create many data form. How I can reuse OleDbConnection to create one and use it in many form that i can still using wizard with OleDbDataAdapter.
Nothing
|
|
|
|
|
;how to attach a database abc.mdf using mdac but not to install the whole server. My client should not to worry about the sql server Whole. i need it if any body knows i will be thankfull to u.
FIRE
|
|
|
|
|
You can't do this. To use an SQL server database, you must install the server.
MDAC is just an interface client, in this case, it interfaces to SQL Server.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
hi,
I am using sqlDataAdapter select command based on multiple tables to populate DataSet . I wanted to update only one table data by using UpdateCommand Property becauze sqlCommandBuilder is not supported for multiple base tables. plz help me to write Update Command. SelectCommand is as
sql = "SELECT a.prepaidID,a.revAccountNo,a.AccountNo AS origAccountNo," & _
"a.totalAmount, .description, .distAmount,b.fromDate,b.toDate,b.vtCode,
b.voucherNo,b.voucherDate" & _
" FROM prepaidDistribution a,prepaidDistributionDetail b" & _
" WHERE a.prepaidID = b.prepaidID and a.companyCode='" & compCode & _
"' and b.fromDate>='" & startDate & "' and b.toDate<='" & endDate & _
"' and b.vtcode IS NULL and a.accountNo like '" & accountNo & "%'"
plz help immediately
|
|
|
|
|
im reading a book "Network Programming in .Net with C# and Visual Basic.Net" by Fiach Reid
im now in the chapter 3 "Working with the sockets"
and im trying to execute the program that's starting at the page 82
and i received an error.Then i put a breakpoint to see what's the problem
then i saw that the problem happened in the Sub "acceptHandler" and this is the snippet code :
Public Sub acceptHandler(ByVal asyncResult As IAsyncResult)
receiveCallBack = New AsyncCallback(AddressOf receiveHandler)
'listenerSocket here = Nothing and i don't know why ?
clientSocket = listenerSocket.EndAccept(asyncResult)
recv = New Byte(1) {}
clientSocket.BeginReceive(recv, 0, 1, _
SocketFlags.None, receiveCallBack, Nothing)
End Sub
i don't know why listenerSocket in this code = Nothing
so this is the problem.
Smart_sdr
|
|
|
|
|
I’m trying to create a new access database and I get an error message that doesn’t make sense.
This is the code:
Dim cat As New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\NewDB.mdb")
This is the error message:
The Microsoft Jet database engine cannot open the file 'c:\newdata.mdb'. It is already opened exclusively by another user, or you need permission to view its data.; operation not complete
Doesn’t make sense because: how can it be opened by another user if it doesn’t exists. Why would I need permission to view its data if I am only creating it.
Any ideas about this issue?
Thanks,
Maritn
|
|
|
|