|
There are two ways of doing integrated sql security. If you want to set permissions for each user (which I don't recommend) make sure you go into IIS and uncheck the allow anonymous access box for your web application. You will also need
<authentication mode="Windows"/> in your web.config.
What I do in my applications is create one windows account that has access to the database. Use a system account so that no one can use that account to log on to the machine. Then add the following your web.config
<authentication mode="Windows"/>
<identity impersonate="true" userName="yourDomain\yourSQLAccountUserName" password="PA$$word"/>
Then make sure the yourDomain\yourSQLAccountUserName account has appropriate rights in the database. Then if you want to do auditing you can always pass the userName of your current user in a sql parameter and update the table.
Also put your conn string in the web.config and use system.configuration.configurationmanager to get it.
Another thing is that it is best to use using blocks. Then you don't have to call close or dispose methods.
For example
public DataTable GetDataTable(string ProcName, SqlParameter[] parameters)
{
DataTable dt = new DataTable();
using (SqlCommand cmd = new SqlCommand(ProcName))
{
cmd.CommandType = CommandType.StoredProcedure;
using (SqlConnection conn = new SqlConnection(connString))
{
cmd.Connection = conn;
foreach (SqlParameter prm in parameters)
{
cmd.Parameters.Add(prm);
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Connection.Open();
da.Fill(dt);
cmd.Parameters.Clear();
}
}
return dt;
}
I didn't get any requirements for the signature
|
|
|
|
|
Hi guys, how can I open a log.txt file inside the webform.aspx window. I don't open and display inside the TextPad. I tried googling but couldn't find something helpful may be you can redirect me to the helpful resource.
Thanks
|
|
|
|
|
System.IO.File.ReadAllText("C:\yourfilepath");
I didn't get any requirements for the signature
|
|
|
|
|
Thanks for suggestion some ways but that's not what I am looking forward, sorry.
Actually, I have a LinkButton on a aspx page and if that is cliked I want to open any kind of file like txt,bmp,jpg,gif,doc,xls files in an another browser window.
You probably have seen like when we open the .doc from hotmail it open the document file in a browser window same i want something like that.
Thanks once again in advance.
|
|
|
|
|
That should be easy enough. Where is the file coming from?
you need to add the content type to the page that will display the file depending on the file for example
switch ( fileExtension )
{
case "pdf": Response.ContentType = "application/pdf"; break;
case "swf": Response.ContentType = "application/x-shockwave-flash"; break;
case "gif": Response.ContentType = "image/gif"; break;
case "jpeg": Response.ContentType = "image/jpg"; break;
case "jpg": Response.ContentType = "image/jpg"; break;
case "png": Response.ContentType = "image/png"; break;
case "mp4": Response.ContentType = "video/mp4"; break;
case "mpeg": Response.ContentType = "video/mpeg"; break;
case "mov": Response.ContentType = "video/quicktime"; break;
case "wmv":
case "avi": Response.ContentType = "video/x-ms-wmv"; break;
//and so on
default: Response.ContentType = "application/octet-stream"; break;
}
Response.BinaryWrite(btyeArrayOfFile);
I didn't get any requirements for the signature
|
|
|
|
|
string fileContent = System.IO.File.ReadAllText("yourfilepath");
Response.Write(fileContent)This will work only for text files
|
|
|
|
|
Do you mean you want just the text in a
<div><p>...</p></div>
construct?
Or, why not simply use an asp:TextBox control and assign the contents of your text file to its Text property?
Mitchell
|
|
|
|
|
I have the following vb.net code to read the excel data into a dataset. The code works fine and the excel data is converted to a dataset. If the excel file has a data in the same column in which some numbers are formatted as text (eg. 080) and some numbers are not formatted as text but formatted as numbers (eg. 100.01) then the dataset contains empty values for the ones that are formatted as numbers. Is there anyway to get those values as text?
Thanks,
Bharathy.
Public Shared Function GetDataSetFromExcel(ByVal excelFileName As String) As DataSet
Dim con As OleDbConnection
Dim dt As DataTable
Dim conStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + excelFileName + ";Extended Properties=Excel 8.0;"
con = New OleDbConnection(conStr)
Try
con.Open()
dt = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing)
If (dt IsNot Nothing) Then
Dim excelSheetNames(dt.Rows.Count) As String
Dim i As Integer = 0
For Each row As DataRow In dt.Rows
excelSheetNames(i) = row("TABLE_NAME").ToString()
i = i + 1
Next
Dim myCommand As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM [" + excelSheetNames(0) + "]", con)
Dim myDataSet As New DataSet()
myCommand.Fill(myDataSet)
Return myDataSet
Else
Return Nothing
End If
Catch ex As Exception
Throw (ex)
Finally
con.Close()
End Try
End Function
|
|
|
|
|
It sounds like this is an issue with the Excel driver attempting to guess the data type for the column. The driver has probably made the decision, based on sampling an initial number of rows (default is 8) that the column should contain text values. Values that look like they belong to another data type will be disregarded and show up as NULL. If you add the element 'IMEX=1' to your connection string this tells the driver to treat intermixed data in a column as text (see here[^])
If you need to increase the number of rows that the driver uses to guess the data type for a column, you need to make a registry change. See this article[^] for more information.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thanks a lot for your help. IMEX=1 did the trick.
|
|
|
|
|
Has anyone here played with this? I'm considering doing so, but I don't want to mess with it if it is vaporware or doesn't work outside of simple examples. What's the general impression of it? Has anyone run into any deal breakers with it that make you not want to use it?
Also, has anyone seen a situation where dynamic data handles hierarchical data (like groups that can contain other groups)?
Thanks,
Will
|
|
|
|
|
Can we dispose a datatable after use to free up the memory because it is huge in size
|
|
|
|
|
table = null;
mark it null so that when garbage collector runs it will free the memory
|
|
|
|
|
If it has a Dispose method, this should be called first. If not, then perhaps it shouldn't be a member variable, so it just gets disposed.
Hell, the page lifecycle means it will get removed unless it's stored in the session ( which would be stupid )
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
How to use group by in datatable in c#?
|
|
|
|
|
Hi,
I have placed a Telerik progress bar on my login page, this produces Javascript which makes calls to the Telerik.Web.UI.dll that is stored in the bin folder. However Forms Authentication is preventing access to this and producing JavaScript errors that 'telerik' is undefined. If I log into the site and go back to the login page it works fine.
Currently we have forms authentication set with the option path="/" meaning everything from the root down. Would it be better to have a new folder named "secure" and then any pages that need to have authetication sit under that folder, and change the forms authentication option to Path="/secure"?
Or is there a better solution?
Kind regards
Paul Custance
|
|
|
|
|
Hi,
I want to bind radio button with the database (MS Access). I have written some code.there are two radio buttons male and female. and one gender coloun in table yes/no (bool) type.
private void rbd()
{
try
{
database = new OleDbConnection(connectionString);
database.Open();
}
catch (OleDbException ex)
{
MessageBox.Show("Error in connection ..." + ex.Message);
}
string sqlStr = "SELECT * FROM city;";
dAdapter = new OleDbDataAdapter(sqlStr, connectionString);
dset = new DataSet();
dAdapter.Fill(dset,"city");
bindingSource = new BindingSource(dset, "gender");
radioButton1.DataBindings.Add("Checked", bindingSource, "gender");
radioButton2.DataBindings.Add("Checked", bindingSource, "gender");
during selection of radio button, i want to show data in grid based on selection??? any suggestions.
}
|
|
|
|
|
Are you binding city or gender? 
Apurva Kaushal
|
|
|
|
|
sorry, its gender. please ignore that syntex error
|
|
|
|
|
Oh ok.
Are you getting any error in this?
One more thing, the last parameter for the databindings is the navigation path (in dataset) i.e TableName.ColumnName. Is it the same in your case?
Apurva Kaushal
|
|
|
|
|
My web application displays perfectly fine in IE but in firefox it's completely messed up. How can I make it display the same in firefox??
|
|
|
|
|
By fixing it. FF and IE render the same HTML differently so you need to work out alternative ways to do the things you're doing in IE ( probably non standard ) and that are being rendered differently ( but probably correctly ) in FF
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
It is also worth noting that for the next IE release (IE8) Microsoft have worked some way further towards becoming much more standards compliant, which Firefox is already. So time spent fixing your site for Firefox will not be wasted
If you are using Stylesheets, take a look at this site, it gives examples on how to load seperate stylesheets according to the browser the user is accessing the site with:
http://www.mimoymima.com/resources/071115_stylesheets.php
Regards
Paul
|
|
|
|
|
Start by checking that the html that your app is rendering is valid. This is easy to do with Firefox if you download the HTML Validator plugin.
http://users.skynet.be/mgueury/mozilla/[^]
Words fade as the meanings change, but somehow, it don't bother me.
|
|
|
|
|
well, the problem is that the project is huge and I can't go through everyline of code to fix it in firefox. so I was wondering if there's anything in asp.net that can render html in firefox exactly like IE.
Maybe something in the web.config file or anything??
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
