|
thx 
|
|
|
|
|
i want to make sql statment that use mod % Div /
i have tow colum
tt | time
---------
1 | 1
2 | 2
3 | 9
i want to make list for all record if (time % 5 = 0)
* how can make this
Palestine
|
|
|
|
|
exactly how youve written it - mod operator in sql is %
so
SELECT * FROM myTableName
WHERE (time % 5) = 0
|
|
|
|
|
hi
could someone tell me why this code is not working, i mean the
insert query
<br />
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="CustomerID"<br />
DataSourceID="SqlDataSource1" AutoGenerateInsertButton="true" Height="50px" Width="184px" AllowPaging="true"><br />
<Fields><br />
<asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" /><br />
<asp:BoundField DataField="CompanyName" HeaderText="CompanyName" SortExpression="CompanyName" /><br />
<asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" /><br />
<asp:BoundField DataField="ContactTitle" HeaderText="ContactTitle" SortExpression="ContactTitle" /><br />
<asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" /><br />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" /><br />
<asp:BoundField DataField="Region" HeaderText="Region" SortExpression="Region" /><br />
<asp:BoundField DataField="PostalCode" HeaderText="PostalCode" SortExpression="PostalCode" /><br />
<asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country" /><br />
<asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" /><br />
<asp:BoundField DataField="Fax" HeaderText="Fax" SortExpression="Fax" /><br />
</Fields><br />
</asp:DetailsView><br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=MOHAMMED-TAMIMI;Initial Catalog=Northwind;Integrated Security=True"<br />
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [Customers]" FilterExpression="CustomerID='{0}'"<br />
InsertCommand="INSERT INTO [Customers]([CustomerID], [CompanyName]) VALUES (@custID, @company)" ><br />
<FilterParameters><br />
<asp:ControlParameter ControlID="GridView1" Name="CustomerID" PropertyName="SelectedValue" /> <br />
<br />
</FilterParameters><br />
<InsertParameters><br />
<asp:Parameter Name="custID" Type="String" /><br />
<asp:Parameter Name="company" Type="String" /> <br />
</InsertParameters><br />
</asp:SqlDataSource> <br />
Tamimi - Code
|
|
|
|
|
My Dear Friend,
The problem with this query is that the INSERT Statement is incomplete.
if you say: SelectCommand="SELECT * FROM [Customers]
than you're selecting all the parameter fields from CUSTOMERS which are 11 parameters.
Having said that your INSERT statemetn should have 11 parameter fields.
HOPE this helps you.
Good luck
Amadeo,
|
|
|
|
|
hi
i changed the select command to
"SELECT CustomerID,CompanyName FROM [Customers]" but i got the same
problem.
anyway thank you
Tamimi - Code
|
|
|
|
|
windows can store your logon information for network locations and web sites
in Control panel->user Account->manage my network password->> (Stored User Name and Password)
and you can see this informatin in a list and if you click properties you can see
server name & user name & password.
can add new entry and change them or remove if you want
How can i retreive the list of server name & username for all stored account
(put them in dropdownlist or saved them on DataBase)
using asp.net or vb.net code
can any one help me ????!!!!
Saeed
|
|
|
|
|
How do i find a process which i know the name of and determine if it exists.
e.g. find out if internet explorer is running.
Posted by The ANZAC
|
|
|
|
|
Here are two ways of doing it. Second one uses iteration which may prove to be resource heavy.
1st Method - GetProcessesByName(processname as String)
If Not IsNothing(Process.GetProcessesByName("iexplore")) Then
MessageBox.Show("Explorer is running.")
End If
2nd Method - GetProcess()
Dim objProc As System.Diagnostics.Process
For Each objProc In Process.GetProcesses
If objProc.ProcessName = "iexplore" Then
MessageBox.Show("Explorer is running.")
Exit For
End If
Next
|
|
|
|
|
hi
i have developed an application.i want to deploy it in a client machine,bt the problem is that i dont know how to make the crystal report database login information dynamic.can anybody help me in this regard to make the crystal report dynamic so that it can take the login information from the registry at the time of installation of the setup wizard?
how can i incorporate the microsoft.net framework in the setup along with the project so that it will automatically install the framework at the time of installation of projects?
any queries in this regard will be warmly solicited
i m pradip kishore from india,working in vb.net & asp.net
|
|
|
|
|
My goal is to open a URL in the default web browser. The URL is stored in a string variable. I use the following code to launch the browser:
system.Diagnostics.Process.Start(URL_string)
The browser pops up and opens the right site... if I don't use any scandinavian characters (ä, ö, å). If use Mozilla Firefox as my default browser, these characters will be converted to HTML-format (e.g. "ä" --> "%%C3%A4"). Internet Explorer doesn't do this.
How would it be possible to open Firefox so that it doesn't change anything in the string I'm using? The problem is that not all web pages support this kind of HTML-converting (they have a different character encoding) and therefore these pages won't open due to a faulty URL.
|
|
|
|
|
Maybe my question was confusing. I try again:
When I launch the browser with a string that contains URL, the URL-string is somehow changed when it moved to browser address bar. When there is a "ä" in the string, the browser gives %E4. Also the &-characters are converted to some %XX-form. Is there a way to prevent this happening? I would like to paste the URL as it is to browser and not change it at all.
|
|
|
|
|
Hi!
I need to do this for my final year project. Is this possible? If Yes, Then please explain How?
|
|
|
|
|
How can i find the Cdrom drive(e:\ or f:\ or G:\ , etc)
Is there any API function or property do this
MHF
|
|
|
|
|
|
Every task has easy way to do it. Thanks
Chatura Dilan
SC Java Programmer
|
|
|
|
|
Dim di As System.IO.DriveInfo
For Each di In My.Computer.FileSystem.Drives
'check that the drive is ready
If di.IsReady = True Then
If di.DriveFormat = "CDFS" Then
Do what you want here!
End If
End If
Next
This finds each cd drive on the computer, for each cd drive, you could add them to a listbox, combobox or anything else. Within the nested FriveFormat if, you can add an if statement.
If di.DriveLabel = Whatever your CD/DVD is! Then
Do what you want!
End If
Then once you have drive location, you can search it or something.
Hope this helped.
Posted by The ANZAC
|
|
|
|
|
Why check the drive format when you can just use DriveType property?
Dim di As System.IO.DriveInfo
For Each di In My.Computer.FileSystem.Drives<br />
If di.DriveType = IO.DriveType.CDRom Then<br />
'Then do what you want here<br />
End If<br />
Next
I'm not dumb I just have a huge command of thouroughly usless infromation.
|
|
|
|
|
i found that some emulated drives show up with drive type, but do not with drive format, so drive format is more effective for physical drives.
Posted by The ANZAC
|
|
|
|
|
Fair enough
I'm not dumb I just have a huge command of thouroughly usless infromation.
|
|
|
|
|
How can i find the Cdrom drive(e:\ or f:\ or G:\ , etc)
Is there any API function or property do this
MNG
|
|
|
|
|
Hello,
I am new to vb.net and wanted to know how to generate database for my application while i deploy it. and how the database will get created as .exe or .dll while its getting installed on clients computer. I have connected my application to sql server 2000. The small application is ready, now its time to deploy it. Please provide me the information as soon as possible.
-- modified at 12:24 Sunday 3rd September, 2006
Nikhil Bandekar
Mumbai,
India
|
|
|
|
|
Hi ,
The easyest way is copy the database file and attact it in client machine.
This example attaches two files from pubs to the current server.
EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'
Hava a nice day.
!alien!
|
|
|
|
|
hi,
how to export an excel file to an informix table using VB.Net
|
|
|
|
|
I was looking at my laptop's touchpad drivers and noticed, that it came with a program called MoodPad. This program just showed a black box that, when you touched the touchpad would change color, similar to a mood ring, on the window. I was wondering if anyone knew any of the APIs i could use to write code that could use a touchpad? I was thinking a game using the touchpad to draw symbols for spells or something...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
