|
Hi all!!
I installed the SQL Server Express edition first and then SQL Server 2005, and then SQL Server Management studio wouldn't install. So I uninstalled both, and just installed SQL Server 2005, then everything was installed. But now I want to install SQL Server Express. But the last time that I did it in thorder I had errors with Visual Web Developer. How can I get both to work.
Has any one had the same sort of problem??
Regards,
ma se
|
|
|
|
|
hi there,
from what i have heard there is not yet a release version of express out yet, i am using the community preview edition and i have had some bugs with it, which can be expected!
|
|
|
|
|
I sorted it out...I clicked Stored Procedures>New stored procedure from the stored procedure folder on the left and from the Query Menu>Specify values for template> and then fill that form out and then it commits it to the database NO PROBLEMS!
|
|
|
|
|
I am working under VS2005 & Oracle DB (using OLEDB), Every thing is done through coding & works fine while fetching the records & displaying them in a Gridview & also inserting them to the DB works fine. But I have the following problem i.e. I’ve added a new bound field i.e. the edit button when I click the edit button the details in that row should be sent to the respective textboxes below. And later after editing the user clicks a different button which should update that record and also the Gridview has to reflect this change.
Can any body help me how to do this????
|
|
|
|
|
on GridView1_SelectedIndexChanged event write code below which give values from grid to textboxes
this.textbox1.text=this.GridView1.Rows[this.GridView1.SelectedIndex].Cells[0].Text;
this.textbox2.text=this.GridView1.Rows[this.GridView1.SelectedIndex].Cells[1].Text;
this.textbox3.text=this.GridView1.Rows[this.GridView1.SelectedIndex].Cells[2].Text;
this.textbox4.text=this.GridView1.Rows[this.GridView1.SelectedIndex].Cells[3].Text;
and so on but if u have to display in dropdownlist do as follow:
this.dropdownlist1.SelectedValue = this.dropdownlist1.Items.FindByText(this.GridView1.Rows[this.GridView1.SelectedIndex].Cells[5].Text).Value;
after u do changes click button Update (Button update is simple sql command)
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Thanks a lot, I really appriciate your timely response, but dude I some other problem when I click on the edit button it is giving me the following error.
"The GridView 'GridView1' fired event RowEditing which wasn't handled"
do you have any idea why is it?
|
|
|
|
|
When u add bound fields do not add edit field but u add select field then write code which i post before
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Dude Iam getting nuts over this thing
below is the detail error msg. I've tried all u wrote but still it is giving the same error
The GridView 'GridView2' fired event RowEditing which wasn't handled.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: The GridView 'GridView2' fired event RowEditing which wasn't handled.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[HttpException (0x80004005): The GridView 'GridView2' fired event RowEditing which wasn't handled.]
System.Web.UI.WebControls.GridView.OnRowEditing(GridViewEditEventArgs e) +323
System.Web.UI.WebControls.GridView.HandleEdit(Int32 rowIndex) +60
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +705
System.Web.UI.WebControls.GridView.RaisePostBackEvent(String eventArgument) +214
System.Web.UI.WebControls.GridView.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +244
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3838
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 :
confused:
|
|
|
|
|
1. click GridView2 select Properites then Events and delete event OnRowEditing
2. Delete Gridview, drag and drop new GridView
3. Check is ur vs.net installed curretly ??
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Is there any stored procedure to convert all the DB tables to Excel sheet
All the Sps to Excel sheet
Or any alternative?
"I find that the harder I work, the more luck I seem to have."
|
|
|
|
|
|
No Can U be more clear? I 'm not asking for whole structure of the table
I want all the names of the table in Excel sheet
"I find that the harder I work, the more luck I seem to have."
-- modified at 2:47 Friday 17th March, 2006
|
|
|
|
|
Ya I know how to use it and I have used it
But I want only the tablenames in an excel format not with data
Like tablename in one column and its description in other
Is there any SP for that
"I find that the harder I work, the more luck I seem to have."
|
|
|
|
|
you can modify the sp in this link
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1057989,00.html?bucket=ETA
|
|
|
|
|
I recently started a C# prototype using the OLE DB access method to read from a hefty Excel spreadsheet that we use at the office. The nice thing about OLE DB is you can read Excel worksheets pretty easily, and in block read style.
H O W E V E R, when was the last time you saw a clean error free, perfectly formatted spreadsheet?
That's where I am stuck. It seems the OLE DB driver/JET engine will happily retrieve the specified query range but it also supplies a null for any cell it doesn't like and considers to have an error. Is there a way to override this behavior and tell OLEDB through the DataSet or ExtendedProperties to retrive all data "as is" thus ignoring any cell errors?
FYI, here is how I am reading a worksheet in one read. In my case I know there are roughly 330-370 rows per worksheet, so I specify a range of 400 rows:
<br />
OleDbConnection con = new OleDbConnection( connectionOpts );<br />
con.Open();<br />
<br />
string query = string.Format( "SELECT * FROM [{0}$[1]]", tableName, queryRange );<br />
<br />
OleDbDataAdapter oleAdapter = new OleDbDataAdapter();<br />
oleAdapter.SelectCommand = new OleDbCommand( query, con );<br />
DataSet ds = new DataSet();<br />
int rowsProcessed = oleAdapter.Fill( ds, "data" );<br />
<br />
oleAdapter.Dispose();<br />
oleAdapter.Close();<br />
etc.<br />
Mike Luster
CTI/IVR/Telephony SME
|
|
|
|
|
How can I check if SQL Server is running through C# code without causing an exception?
|
|
|
|
|
|
I will like to store my .swf file format in my database. I heard that it will be easier if we store only the URL in database and for my file i can keep it in web.
Can anyone guide the best way to upload .swf file in database and retrieve it. I am using sql 2000 and asp.net
|
|
|
|
|
|
Now i have 3 steps in doing it which is
1. browse my file from harddisk
2. giving my file a name
3. upload my file to web server
So my question over here is, how to upload my url for the specific path to database?
my code are something like this for the 3 step
------------------------------------------------
Sub DoUpload(ByVal Sender As Object, ByVal e As System.EventArgs)
Dim sPath As String
Dim sFile As String
Dim sFullPath As String
Dim sSplit() As String
Dim sPathFriendly As String
'Upload to same path as script
'Internet Anonymous User must have write permissions
sPath = Server.MapPath("../Tutorial")
'sPath = Server.MapPath(".")
If Right(sPath, 1) <> "\" Then
sPathFriendly = sPath 'Friendly path name for display
sPath = sPath & "\"
Else
sPathFriendly = Left(sPath, Len(sPath) - 1)
End If
'Save as same file name being posted
'The code below resolves the file name
'(removes path info)
sFile = txtFileName.Value
'sFile = txtUpload.PostedFile.FileName
sSplit = Split(sFile, "\")
sFile = sSplit(UBound(sSplit))
sFullPath = sPath & sFile
Try
txtUpload.PostedFile.SaveAs(sFullPath)
lblResults.Text = "Upload of File " & sFile & " to " & sPathFriendly & " succeeded"
Catch Ex As Exception
lblResults.Text = "Upload of File " & sFile & " to " & sPathFriendly & " failed for the following reason: " & Ex.Message
Finally
lblResults.Font.Bold = True
lblResults.Visible = True
End Try
|
|
|
|
|
Can someone please tell me how I can impliment the try...catch statement in a stored procedure?
Thanks!!
Illegal Operation
Making Computer Software Talk
|
|
|
|
|
|
BEGIN TRY
SELECT * FROM Tablename;
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_MESSAGE() AS ErrorMessage;
END CATCH;
GO
"I find that the harder I work, the more luck I seem to have."
|
|
|
|
|
I have a function that uses the SqlDataReader to get data from a SQL Server 2000 database. The function works pretty fine until the point where the SqlDataReader will be closed. This can take a minute or more (see a piece of the log file).
2006-03-13 08:43:06 ; GetJobByID: Beginning of function
2006-03-13 08:43:06 ; GetJobByID: Start opening DB connection
2006-03-13 08:43:06 ; GetJobByID: Finished opening DB connection
2006-03-13 08:43:06 ; GetJobByID: Start SQL execution
2006-03-13 08:43:06 ; GetJobByID: Finished SQL execution
2006-03-13 08:43:06 ; GetJobByID: Finished creation of job object
2006-03-13 08:43:06 ; GetJobByID: Close reader
2006-03-13 08:44:16 ; GetJobByID: Close connection
2006-03-13 08:44:16 ; GetJobByID: End of function
As you can see the "Close Reader" command takes 1 minute and 10 seconds and I have no clue why. Additional info: During the function the process "System" runs with about 70 percent.
Thanks in advance,
CADMIN
|
|
|
|
|
HI CADMIN,
Well i am not that of an expert but why dont you close the SqlConnection with out closing the SqlDatareader and the re-open the SqlConnection when ever needed.
i hope you can try this and see if its working, just a test.
Thanks
|
|
|
|