|
Sir/Madam,
I have a table , having two fields , first for name and second for roll number.I don't have serial number field in that table.Can , I display Serial number field in the datagridview , with those two fields.
I mean if i have ten records in the table. Then datagrid should display record no for each row, like for first row it should display 1 , and for second row , there should display 2 and so on.This should happen in the extra column in the datagridview.Is it possible.
Please help.
Thanks and regards
Pankaj
|
|
|
|
|
Hi,
You can use sql query in this case. If your current sql query is -
select name,rollno from students
Then modify the query as -
select 0 as [Serial No.],name, rollno from students.
This modified query will generate a column named Serial No. whoes rows will be filled by 0. Then in the program use a counter to count the rows, in the RowDataBound event handler. Replace the text in column 0 with the counter value. You will get your desired resutls.
Hope i am clear enough.
I am assuming that you are using SQL Server as database.
"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder
coolestCoder
|
|
|
|
|
Sir/madam,
I am facing problem in the crystal reports.Now , Suppose I have 20 records into the database(each record contain one field for name).I am able to display them in the reports in the vertical order , to get the print outs .But the problem is , I am not able to display these 20 records in two column.Two columns means , First column has ten records and second column has 10 records.Actually , the purpose of using two columns is , I want to save the page . I want to put the names on the envelope , after getting the print out , I will cut those names from page and finally will be pasted on the envelope.Is there any option to do this task.Hope , I am trying to make u understand my problem.
Please help.
Thanks and regards
Pankaj
|
|
|
|
|
Hi
I need to conver c# project to vb.net
from
http://www.codeproject.com/csharp/eventscheduler.asp[^]
I did it for the class library (by using a translator )
now I need to implement the code and I can't do it
Schedule s = new IntervalSchedule("Test_Interval", DateTime.Now.AddMinutes(10), 45, TimeSpan.Zero, new TimeSpan(TimeSpan.TicksPerDay));<br />
s.OnTrigger += new EventScheduler.Invoke(ScheduleCallBack);<br />
Scheduler.AddSchedule(s);
I wrote
MessageBox.Show("Test will now create Interval schedule")<br />
Dim s As New ES.IntervalSchedule("Test_Interval", DateTime.Now.AddMinutes(1), 45, TimeSpan.Zero, New TimeSpan(TimeSpan.TicksPerDay))<br />
and it's won't work with s.ontrigger.....
What can I do
|
|
|
|
|
Hi, in windows form designer in vs 2005 pro, how to display a grid (a small dot) on the form like vb.net 2003?
|
|
|
|
|
I recently learned that on XP (and later) OS, you do not need to register activeX, if you use "isolated" option from vs 2005 menu to create a special manifest file.
Does anyone know how can I make the required manifest lines if I only have VS 2003 ?
Thanks,
Atara
|
|
|
|
|
VS2003 doesn't create manifest files. I also don't see how a COM dll can work without being registered, unless the manifest contains the GUIDs and so on, and everything has to be in the same directory.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
The manifest should contain clsid.
This technologie (COM dll can work without being registered) should work on XP sp2, and Vista. according to the documentation it should work on .Net 1.1
but I can not find the exact format of the needed manifest file 
more about this "Reg Free COM" technologie in -
http://msdn.microsoft.com/msdnmag/issues/05/04/RegFreeCOM/[^]
Atara
|
|
|
|
|
I solved it with the help of:
(1) Escape DLL Hell - Simplify App Deployment with ClickOnce and Registration-Free COM
(VS 2005 Article)
http://msdn.microsoft.com/msdnmag/issues/05/04/RegFreeCOM/
(2) Registration-Free Activation of COM Components: A Walkthrough
(VS 2003 Article)
http://msdn2.microsoft.com/en-us/library/ms973913.aspx
(3) oleView.exe
C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\oleView.exe (or . . . \Tools\Bin)
oleView.exe: File->View TypeLib
The solution:
1. The main manifest (myProg.exe.manifest):
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity
type = "win32"
name = "myProg"
version = "1.0.0.0" />
<dependency>
<dependentAssembly>
<assemblyIdentity
type="win32"
name="myAxFile.X"
version="1.0.0.0" />
</dependentAssembly>
</dependency>
<dependency>... more files ...</dependency>
</assembly>
2. The myAxFileN manifest (myAxFileN.X.manifest):
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity
type="win32"
name="myAxFileN.X"
version="1.0.0.0" />
<file name = "myAxFile.ocx">
<comClass
clsid="{...clsid...}"
threadingModel = "Apartment" />
<typelib tlbid="{...tlbid...}"
version="1.0" helpdir=""/>
</file>
<comInterfaceExternalProxyStub
name="myAxName"
iid="{...iid...}"
proxyStubClsid32="{00020424-0000-0000-C000-000000000046}"
baseInterface="{00000000-0000-0000-C000-000000000046}"
tlbid = "{...tlbid...}" />
</assembly>
The id are taken from oleView.exe: File->View TypeLib generated file.
I hope it will help you to start digging your specific needs.
Atara
|
|
|
|
|
or, you can use only one manifest file, e.g:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0" >
<assemblyIdentity type="win32" name="myProg.exe" version="1.0.0.0" />
<file name="file1.ocx">
<typelib tlbid="{...}" version="1.0" helpdir="" />
<comClass clsid="{...}" tlbid="{...}" threadingModel="Apartment" />
</file>
<file name="file2.ocx">
...
</file>
</assembly>
Note: all *.ocx, *.dll files of the activeX should also be in the same folder, with the manifest and the exe files.
Atara
|
|
|
|
|
:->Hello all,
I want to make a vbs file that will take some data and then will redirect me to a nwe web page with the entered data as a query string,
is there any one can help me or have a ready done vbs file 
Thanks alot
Hamody
|
|
|
|
|
What is a VBS file ? Do you mean a script for classic ASP, using VBScript ? I heartily recommend you use ASP.NET, unless you hate yourself. Having said that, the web development forum is for ASP questions.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
yeah i mean visual basic script file,
i want to make it as a sparated file without using visual stuodio.net
for example;
make a new text file ane write the following lines inside it:
Dim m
MsgBox "You must enter a quantity."
and then save it as ddd.vbs, then double click on it, u will see its action.
i want to make a one as this but for the purpose that i asked in my sent question 
Thanks alot
Hamody
|
|
|
|
|
Well, how is this script going to be run via a web site, if it's just sitting at a random place on your hard drive ? Why does it matter than you use or don't use VS ?
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
hellllllo,
i want to make a separate vbs file, i cannt use vs.net to run t through vs.net or i dont want to run it under html document.
please man, if u know how i can call a web page through the vbs file send t to me
Thanks alot
Hamody
|
|
|
|
|
Mohammad Daba'an wrote: i want to make a separate vbs file,
OK - this file is never going to run under .NET. It doesn't matter what you use to edit it.
Mohammad Daba'an wrote: i dont want to run it under html document.
OK, then where does the query string magically come from when you run this file. When you double click on it, how does it relate to a URL at all ?
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Dear There,
ok, for the editting, I will use notepad to write the vbs file,
i just need now the code that i can use to call a url, eg, www.yahoo.com
by running this vbs file 
Thanks alot
Hamody
|
|
|
|
|
Oh, I see. You just want to launch a URL, and create a query string. I thought you wanted to process one.
I'm not sure, but I know that in C++ and C#, the code to run a program will run the default browser and open a URL, if you pass it a URL.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
ok dear, u now understand 80% of what i want,
in asp.net when i want to go to another page i put (response.redirect("........"))
i want to know what is the code to open a url when i click on button for example in using vbs,
i willnt use asp.net, the example i sent u is on vbs, i will make a vbs file that when i open it it will appear an input box inside it and it has 2 button, ok and cancel, when i fill the url and press ok it will open an IE page and display the url i entered.
i want the code that will call the entered url, hope u understand me now 
Thanks alot
Hamody
|
|
|
|
|
Yep, I understand. We've been discussing this for 4 hours. It took me 30 seconds to find how to open a web page with VBS, via a simple google search
set Window = CreateObject("InternetExplorer.Application") Window.RegisterAsBrowser = True
Window.Navigate("www.microsoft.com")
Window.MenuBar = True
Window.ToolBar = True
Window.AddressBar = True
Window.StatusBar = True
Window.FullScreen = False
Window.Resizable = True
Window.Visible = True
Window.Width = 850
Window.Height = 720
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
man thank u for the time u spent with me,
man we r nt all the same, u have 2 b better to help the 1s like me.
tell me, for ur search on google, what is the text u put on the search box to get this codes n a short time,
man :-> am still new with vbs, i just started learning t since yesterday ...
thanks a lot tooooooo much for ur help 
Thanks alot
Hamody
|
|
|
|
|
I typed in 'vb script open web page'
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Hi
dear
I am very new to vb.net and here too...Please help me in understanding vb.net
I need help ..in regards with database programing
I am working on an assignment . as a too i am using vb.net and microsoft access.
Please advise me how to connect database created in microsoft access using vb.net
m.adil.farooq
mcs & acca
adil-farooq@maktoob.com
|
|
|
|
|
|
If you want to become a programmer, you need to learn how to use some high level and complicated tools. Number one tool in your arsenal is right here[^]
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
