|
I usually handle this on the front end but, as and exercise, here is something that works:
SELECT
REPLACE(ISNULL(SPACE(10 - LEN(CAST([MyIntField] AS VARCHAR(10)))),''),' ',0) +
CAST([MyIntField] AS VARCHAR(10)) AS ZeroPaddedNumber
FROM
[MyTable]
Just replace [MyIntField] & [MyTable] as appropriate and it should work. The number 10 represents the length of the resultant string (padded with zeros).
|
|
|
|
|
I want to list the tables of the selected access database and to view the data stored in this table I am using windows applicaiton (using c# language)
|
|
|
|
|
to get a list of tables from Acces DB try SELECT NAME FROM MSYSOBJECTS WHERE TYPE =6;
|
|
|
|
|
Use an OracleCommandBuilder.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
The method OracleCommandBuilder.DeriveParameters does'nt exist in ODP.Net 9.2 ,
I found it in ODT (Oracle® Data Provider for .NET Developer's Guide
10g Release 1 (10.1.0.3) ,but i use ODP.Net 9.2 .
I think that i hav to use odp 10.1.
thnx
ENSI TUNISIA
|
|
|
|
|
Creating a mysql-based application the user that use my application needs mysql server installed on its pc?
|
|
|
|
|
no need . but your user should install the driver or client browser.
So you can connect to a mysql server in the network.
Your code is cool as your are
Your work is cool as Your code
So be a cool code worker
|
|
|
|
|
i tried to install SQL Server 2000 on my Windows 2000 Advanced Server and i got error when the setup was configuring the server... it told to check the sqlstp.log file which has the following lines at the end...
i could not get the error...
can anyone help me ???
thnkx
*************************************************************
00:20:03 End Action: Locked Connectivity Files Check
00:20:03 Setup is installing Microsoft Data Access Components (MDAC) ...
00:20:03 G:\x86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
00:20:35 ExitCode: 0
00:20:35 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
00:20:35 D:\WINNT\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir "D:\WINNT\TEMP\SqlSetup\Bin" -DTCPkg "G:\x86\Other\dtcsetup.exe" -LogFile "D:\WINNT\sqlstp.log"
00:20:35 Process Exit Code: (0)
00:20:35 InstallMSSearch instance: MSSQLSERVER
00:20:35 Software\Microsoft\Search\Install:Version not present
00:20:35 MSSearch 2.0 or greater version check returned -1
00:20:35 Setup is installing the Microsoft Full-Text Search Engine ...
00:20:35 "G:\x86\FullText\MSSearch\Search\SearchStp.exe" /s /a:SQLServer
00:20:44 Process Exit Code: (0)
00:20:44 /Q:A /T :\WINNT\TEMP\ixp001.tmp
00:20:44 Setup is installing HTML Help ...
00:20:45 HTML Help installer exit code: 0
00:21:07 End Action InstallPkgs
00:21:07 Begin Action MoveFileData:
00:21:07 Enabled SELFREGISTERBATCH
00:21:07 Enabled CORECOMPONENTHANDLING
00:22:07 Begin Action: MoveFileDataSpecial
00:22:07 End Action: MoveFileDataSpecial
00:22:07 End Action MoveFileData
00:22:07 Begin Action ProcessAfterDataMove:
00:22:07 G:\x86\Binn\hhcol.exe D:\Program Files\Microsoft SQL Server\80\Tools\Books
00:22:08 End Action ProcessAfterDataMove
00:22:08 Begin Action BuildServer:
00:22:08 D:\WINNT\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath "D:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
00:22:08 Process Exit Code: (0)
00:22:08 Begin Action: CreateRegistrySetSQL
00:22:08 End Action: CreateRegistrySetSQL
00:22:08 Begin Action: RegWriteSetupEntry
00:22:08 End Action: RegWriteSetupEntry
00:22:09 Begin Action: CreateSer
00:22:09 End Action: CreateSer
00:22:09 Begin Action: SkuIt
00:22:09 End Action: SkuIt
00:22:09 SetFileSecuritySQLAndAdmin for D:\Program Files\Microsoft SQL Server\MSSQL returned: 1350, 1350
00:22:09 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
00:22:09 Begin Action: UpdateSystemPath
00:22:09 Path successfully updated.
00:22:09 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;D:\Program Files\Microsoft SQL Server\80\Tools\BINN
00:22:09 End Action: UpdateSystemPath
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:10 D:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "D:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 524698 -U sa -P
###############################################################################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=VISHUCOOL;UID=saWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()).
driver={sql server};server=VISHUCOOL;UID=saWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (ReadFile()).
driver={sql server};server=VISHUCOOL;UID=saWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (ReadFile()).
SQL Server configuration failed.
***********************************************************
|
|
|
|
|
This user[^] had the same problem.
A question that occurs to me is why it's using the Named Pipes driver. I can't recall whether Named Pipes is enabled by default on a new installation - I didn't think it was. I would have expected it to select Shared Memory. You could try checking to see whether there are any aliases configured in the Client Configuration tool (cliconfg.exe).
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
if any one know the code to view the tables in access database and display the data from any table plz send it quickly
|
|
|
|
|
What are you trying to accomplish and what language do you want to use?
|
|
|
|
|
to view tables try SELECT NAME FROM MSYSOBJECTS WHERE TYPE = 6
then run through the recordset one by one and use SELECT * FROM RECORDSET.Fields(0).Value
|
|
|
|
|
in a project i need some data for reporting, when i use same sentence in SQL server 2000 there is no problem, but in access i get "join clause error"
Select Sentence is here.
SELECT USR.USER_FULLNAME, CMP.C_COMPANYNAME, CMP.C_COUNTRY, CLRS.*,ORD.* FROM ORDERS ORD <br />
INNER JOIN COMPANIES CMP ON ORD.O_CUSTOMERID = CMP.C_COMPANYID <br />
INNER JOIN COLORS CLRS ON CLRS.C.ORDERID = O.O_ORDERID <br />
INNER JOIN USERS USR ON USR.USER_ID = ORD.O_WHOGET <br />
<br />
WHERE 1=1 ORDER BY ORD.O_ORDERDATE
 What s wrong ? ? ?
|
|
|
|
|
in Access SQL you have to set opening brackets after the from and closing after each join, when you have more than one join in the select.
you can also set the access mdb to ANSI 92 syntax (SQL Server) in extras/options/tables,querys then you dont have to set the INNER or the brackets.
Thomas
SELECT USR.USER_FULLNAME, CMP.C_COMPANYNAME, CMP.C_COUNTRY, CLRS.*,ORD.*
FROM (((ORDERS ORD
INNER JOIN COMPANIES CMP ON ORD.O_CUSTOMERID = CMP.C_COMPANYID)
INNER JOIN COLORS CLRS ON CLRS.C.ORDERID = O.O_ORDERID)
INNER JOIN USERS USR ON USR.USER_ID = ORD.O_WHOGET)
WHERE 1=1 ORDER BY ORD.O_ORDERDATE
thomas
|
|
|
|
|
thank u thomas for replaying,
i solved this problem, as writing a query (access stored procedure)
|
|
|
|
|
I have posted this problem a few times now in other areas. I have received some repsoinses but all suggestions fail. I have placed many statments in the code to verify that the data is being read. IT is. The only issue is the dataBind statement. I'm getting very frustrated!
I have many examples of how to bind a dropdownlist but NONE match the code that is generated in VS .NET. Since I am new to .NET and web programming I am having difficulty following the gerneated code. I am convinced my problem is in the way I am binding the data. The eror I get is
"Index 0 is not non-negative and below total rows count."
and it ocurs in the following line
DropDownList1.DataBind();
Here is some of the code. If you are intereseted in helping me I can post all of it.
<br />
private void Page_Load(object sender, System.EventArgs e)<br />
{<br />
if (!Page.IsPostBack) <br />
{<br />
BindListToDropDown();<br />
}<br />
}<br />
<br />
#region Web Form Designer generated code<br />
override protected void OnInit(EventArgs e)<br />
{<br />
InitializeComponent();<br />
base.OnInit(e);<br />
}<br />
<br />
private void InitializeComponent()<br />
{ <br />
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();<br />
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();<br />
this.dbListOfAirports1 = new dbListOfAirports();<br />
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();<br />
((System.ComponentModel.ISupportInitialize)(this.dbListOfAirports1)).BeginInit();<br />
this.DropDownList1.DataBinding += new System.EventHandler(this.Page_Load);<br />
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;<br />
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {<br />
new System.Data.Common.DataTableMapping("Table", "tblAirport", new System.Data.Common.DataColumnMapping[] {<br />
new System.Data.Common.DataColumnMapping("AirportCode", "AirportCode"),<br />
new System.Data.Common.DataColumnMapping("AirportID", "AirportID"),<br />
new System.Data.Common.DataColumnMapping("AirportName", "AirportName"),<br />
new System.Data.Common.DataColumnMapping("City", "City"),<br />
new System.Data.Common.DataColumnMapping("Latitude", "Latitude"),<br />
new System.Data.Common.DataColumnMapping("Longitude", "Longitude"),<br />
new System.Data.Common.DataColumnMapping("State", "State")})});<br />
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=0;Data Source=""D:\MGDevelopment\SIMDAC Viewer\DB\simdac_be.mdb"";Jet OLEDB:Engine Type=5rovider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";<br />
this.dbListOfAirports1.DataSetName = "dbListOfAirports"; <br />
this.dbListOfAirports1.Locale = new System.Globalization.CultureInfo("en-US");<br />
this.oleDbSelectCommand1.CommandText = "SELECT AirportCode, AirportID, AirportName, City, Latitude, Longitude, State FROM" +<br />
" tblAirport";<br />
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;<br />
((System.ComponentModel.ISupportInitialize)(this.dbListOfAirports1)).EndInit();<br />
<br />
}<br />
#endregion<br />
<br />
private void BindListToDropDown()<br />
{<br />
try <br />
{<br />
oleDbConnection1.Open();<br />
OleDbDataReader OleDbReader = this.oleDbSelectCommand1.ExecuteReader();<br />
<br />
oleDbConnection1.Close();<br />
DropDownList1.DataSource=OleDbReader;<br />
DropDownList1.DataTextField = "AirportName";<br />
DropDownList1.DataValueField="AirportID";<br />
DropDownList1.DataBind();<br />
<br />
}<br />
catch(OleDbException ex) <br />
{<br />
|
|
|
|
|
Just a shot in the dark as I'm a sleft-taught hobbiest, but I would write your try catch like this:
private void BindListToDropDown()
{
try
{
oleDbConnection1.Open();
OleDbDataReader OleDbReader = this.oleDbSelectCommand1.ExecuteReader();
DropDownList1.DataSource=OleDbReader;
DropDownList1.DataTextField = "AirportName";
DropDownList1.DataValueField="AirportID";
DropDownList1.DataBind();
oleDbConnection1.Close();
}
catch(OleDbException ex)
{
Notice I don't close the connection until after the DataBind.
Let me know if that works.
Jerry
Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons
Toasty0.com
Ladder League (beta)
|
|
|
|
|
Didn't work.
Thanks for the effort! i think it has something to do with the reader. Most examples I find do not use the reader.
Brian
|
|
|
|
|
Ok, it ws a shot in the dar.
Does the error point to either one of these lines of code?
DropDownList1.DataTextField = "AirportName";
DropDownList1.DataValueField="AirportID";
Jerry
Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons
Toasty0.com
Ladder League (beta)
|
|
|
|
|
if(IsPostBack)<br />
{<br />
string SQL="";<br />
switch(ddlLibrarySelection.SelectedItem.Text)<br />
{<br />
case"The Whole Library":<br />
SQL=ddlLibrarySelection.SelectedValue.ToString();<br />
break;<br />
case"ASP.NET":<br />
SQL=ddlLibrarySelection.SelectedValue.ToString();<br />
break;<br />
case"C#":<br />
SQL=ddlLibrarySelection.SelectedValue.ToString();<br />
break;<br />
case"C++":<br />
SQL=ddlLibrarySelection.SelectedValue.ToString();<br />
break;<br />
case"DirectX":<br />
SQL=ddlLibrarySelection.SelectedValue.ToString();<br />
break;<br />
case"Game Programming":<br />
SQL=ddlLibrarySelection.SelectedValue.ToString();<br />
break;<br />
case"SQL":<br />
SQL=ddlLibrarySelection.SelectedValue.ToString();<br />
break;<br />
case"Visual Basic":<br />
SQL=ddlLibrarySelection.SelectedValue.ToString();<br />
break;<br />
}<br />
string DbPath = Server.MapPath("bin/LibBooksProg.mdb"); <br />
string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;"+ <br />
@"Data Source="+DbPath+";"; <br />
OleDbConnection MyOleDbConn = new OleDbConnection(ConnStr); <br />
OleDbCommand Commandobj = new OleDbCommand( SQL,MyOleDbConn); <br />
MyOleDbConn.Open(); <br />
dgTestIt.DataSource= Commandobj.ExecuteReader();<br />
dgTestIt.DataBind(); <br />
MyOleDbConn.Close(); <br />
}<br />
}
Jerry
Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons
Toasty0.com
Ladder League (beta)
|
|
|
|
|
I am surprised that the previous code didn't work. I tried it using the pubs database and it worked fine. Make sure you close the database after calling DataBind. I tried closing before and got an error.
Following is my code:
<br />
private void BindListToDropDown()<br />
{<br />
string query = "select * from Authors";<br />
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();<br />
SqlDataReader dr = cmd.ExecuteReader();<br />
this.DropDownList1.DataSource = dr;<br />
this.DropDownList1.DataTextField = "au_lname";<br />
this.DropDownList1.DataValueField = "au_id";<br />
this.DropDownList1.DataBind();<br />
conn.Close();<br />
}<br />
|
|
|
|
|
If you want to bind the data to the dropdownlist you will need to use the dataset fill function.
Page_Load
sqlDataAdapter1.Fill(dataSet11);
DropDownList1.DataBind();
that's it!
Hope it helps...
Illegal Operation
WannaBe and GonnaBe Systems Developer
|
|
|
|
|
Tried this and got the message
An invalid data source is being used for DropDownList1. A valid data source must implement either IListSource or IEnumerable.
Thanks for the effort!
Brian
|
|
|
|
|
Hello,
I have a problem with Interbase/Firebird database. I need to monitor the changes in database in specific select. Therefore I have created a view and a trigger after_update on that view. But if there´s an update made directly on the table which is included in the view, an event is not raised. It is raised only when I make the update on the view. This behavior seems to me strange.
I thank you for ideas.
|
|
|
|
|
Hey dats not a great problem. Its the property of a view. If u create a trigger in table dat will perfectly work for a view. But in case of creating a trigger for a view it will not work on a table as only changes done on view can have an impact on the table but not for the triggers raised.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
