|
I am developing an application for Win mobile 6.0 in visual studio 2008 under smart device.This application involves reading and writing the data from a table in SQL server 2005 to a C# smart device form.I cannot read and write the data to the table made in SQL server 2005 to c# form. Plz someone help me with the steps to be followed to achieve this. Also help me with the steps for database connectivity.
Thanks.
|
|
|
|
|
|
Hi;
I create a field(namely Id) which have two types(09a.. or 09b..) of alphanumeric value like;
Id
09a1001
09a1002
09b1001
09b1002
09b1003
from these numbers at time a i need maximum value of 09a (it will be 09a1002) series or maximim value of 09b series(it will be 09b1004).
Help me.
modified on Thursday, January 29, 2009 7:57 AM
|
|
|
|
|
You could have something like:
select max(convert(int, substring(id, 4, 9999)))
from tablename
where id like '09a%'
|
|
|
|
|
Hi ,
I have a application in which I have to store the user's data.So that he can retrieve it between its visits to the website.But I want that after 30 days that table should become blank.
Is there any way out.
Please give some guidance....
Thanx in advance.
cheers,
sneha
|
|
|
|
|
On SQL Server, this is generally achieved by using a SQL Agent that periodically scans the table for records older than "x" and removes them.
|
|
|
|
|
Thanks a lot...
It really worked...
cheers,
sneha
|
|
|
|
|
Sneha,
Pls give a brief about how did you do it?
Senthil
|
|
|
|
|
Hello mate,
Is it not going to effect your applications which are using the data from those tables, here I have similar problem like how to identify the unaccessed tables over a period of time.
Can u pls help me out,
Regards,
Ashok
ashok
|
|
|
|
|
I have a doubt regarding MS Access Database. I have two MS database with password protected. Now I want to join one inner join (example table a from first database, table b from second database) with the table how can i do it. When I was trying it's telling that not a valid password.
Problem both database are password protected. How I over come from the issue. Kindly do the favor.
|
|
|
|
|
On one of the databases could you try something like:
SELECT a.*, b.*
FROM sometable as a
INNER JOIN
[;DATABASE=C:\...\database.mdb;PWD=yourpwd].othertable b
ON a.column = b.column
WHERE ...
|
|
|
|
|
Hi Mika Wendelius,
It is a great solution. Thanks a lot for the help.
Thanks
Solomon.S
|
|
|
|
|
You're welcome.
P.s. I noticed that this was a cross-post. Next time, post only on one forum.
|
|
|
|
|
This same question was posted in the Visual Basic Forum. Try not to cross-post.
|
|
|
|
|
Hello Friends,
How to create DFD for my project documents.
My project definition is Inventory System.
Please help me.
Thanks in advance.
Pin
|
|
|
|
|
I'm curious, what's DFD? Data Flow Diagram?
|
|
|
|
|
DFD Stands for Data Flow Diagram.
It is one kind of Graphical Representation of the flow of Data in Project.
For example my project is about Inventory Management System.
In My project there is :
Stock - inward
Stock - Outward
Customer
Suppliers
Bank
Order process
etc...
how to represent this using Data Flow Diagram. (dfd 1.0, 2.0...)
Please help me,
Thanks in advance.
Pin
|
|
|
|
|
|
Please clarify your question
"It reads like a B3 page (and for those who don't know what B3 is, it means bullsh*t Baffles Brains)" - Pete O'Hanlon
|
|
|
|
|
DFD Stands for Data Flow Diagram.
It is one kind of Graphical Representation of the flow of Data in Project.
my project is about Inventory Management System.
In My project module is :
Stock - inward
Stock - Outward
Customer
Suppliers
Bank
etc...
how to represent this using Data Flow Diagram. (dfd 1.0, 2.0...)
Please help me,
Thanks in advance.
Pin
|
|
|
|
|
And it sounds like a homework question. Ask your tutor or read a book. you never learn if someone else does it for you.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
You are absolutely right.
refer any site(if u have any) from which i can get basic idea.
thanks for your reply.
Pin
|
|
|
|
|
Kindly Let Me know the maximum Value which is recommended for the rows in a particular table.
Some of my tables have more than 60 lakhs rows..
Kindly Suggest??????????
Thanks in Advance...
|
|
|
|
|
There is no real limit, it is all dependant on disk space and hardware performance. You may want to look at partitioned tables for performance. Also when you get to these volumes of data indexing is crucial.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
As many as you need, and no more.
|
|
|
|