Comments by Member 8893861 (Top 44 by date)

done thank u

done
thank u siddartha

I am trying the same
but how to find row cell value of that row ?


protected void CustomersGridView_SelectedIndexChanged(object sender, EventArgs e)
{


Response.ContentType = "Application/pdf";
Response.AppendHeader("Content-Disposition", "attachment; filename=filename.pdf");
Response.TransmitFile(Server.MapPath("~/.pdf"));
Response.End();
}

protected void GridView4_RowCommand(object sender, GridViewCommandEventArgs e)
{
int RowIndex = GridView4.....
}

could u suggest some link where i can find solution

thank u

Resolved
folder on remote server had no write permission
thank you

Resolved
folder on remote server had no write permission
thank you

Resolved
folder on remote server had no write permission
thank you

i tried both
my os is win08
my exact error is
Access to the path 'D:\INETPUB\VHOSTS\libacp.com\httpdocs\images\1234.jpg' is denied.
I dont know what to do , i tried many things .

could you please tell me how to unable it ?

i allowed permission to folder , but it is showing same error.

thank u

done
thank you

i tried parameters ,but i am not able to send value through query
string insquery = "insert into tbl_paper (paper_name,year_id,course_id,streame_id,semester_id)values (@0,@1,@2,@3,@4))";

objclsvrb.objsqlcomd = new SqlCommand(insquery);

// objclsvrb.objsqlcomd.Parameters.Parameters.Add("@ID", SqlDbType.Int);

//command.Parameters["@ID"].Value = customerID;


objclsvrb.objsqlcomd.Parameters.Add("@0", SqlDbType.VarChar);
objclsvrb.objsqlcomd.Parameters["@0"].Value = txt_filename.Text;

objclsvrb.objsqlcomd.Parameters.Add("@1", SqlDbType.VarChar);
objclsvrb.objsqlcomd.Parameters["@1"].Value = DD_course.SelectedValue;


objclsvrb.objsqlcomd.Parameters.Add("@2", SqlDbType.VarChar);
objclsvrb.objsqlcomd.Parameters["@2"].Value = DD_streame.SelectedValue;


objclsvrb.objsqlcomd.Parameters.Add("@3", SqlDbType.VarChar);
objclsvrb.objsqlcomd.Parameters["@3"].Value = DD_year.SelectedValue;

objclsvrb.objsqlcomd.Parameters.Add("@4", SqlDbType.VarChar);
objclsvrb.objsqlcomd.Parameters["@4"].Value = DD_semester.SelectedValue;






int temp = Convert.ToInt32(objclsfun.FnExeNonQuery(insquery));
if (temp == 1)
{
Response.Write("added");

}

public int FnExeNonQuery(string query)
{

objclsvrb.objsqlcon = new SqlConnection(objclsvrb.constring);
objclsvrb.objsqlcomd = new SqlCommand(query, objclsvrb.objsqlcon);
objclsvrb.objsqladapter = new SqlDataAdapter(objclsvrb.objsqlcomd);
objclsvrb.objds = new DataSet();
objclsvrb.objsqlcon.Open();
//objclsvrb.objSqladp.Fill(objclsvrb.objds);
int retIntValue = Convert.ToInt32(objclsvrb.objsqlcomd.ExecuteNonQuery());
objclsvrb.objsqlcon.Close();
return retIntValue;
}

thank you

problem solved
thank you very much

System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'libacp_pune020'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at businesslogic.clsfun.retdataset(String query) in F:\C # ALL\current web projects\Lib_Web\businesslogic\clsfun.cs:line 38 at Lib_Web.WebForm12.Button1_Click(Object sender, EventArgs e) in d:\plesk\vhosts\libacp.com\httpdocs\WebForm12.aspx.cs:line 29

should i post my connection code?

Ok , could you help me find a solutions ?

yes definitely i am using different login details for both

My question is , can i login in from my asp project from one hosting to sql server
with different hosting (with its login details )

Ok
But when i tried giving direct data source(servername, sql server authentication ) to grid view , and tested it my grid get populated

when i tried to catch the exception it show long error

may be i am doing a mistake in server name

actually my site is hosted on one server having sql (ip 1)
and i m connecting other hosting server with different slq (ip 2)

i have purchased space in both the places

ok i will do that
thank you very much

I created dummy db and is going to 64 bit location
C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.HOMESQLSERVER\MSSQL\DATA
I am not using duplicate db file name
I doubt if my DBA is not providing me proper sql server

I am using sql server 2008 R2
i am able to connect using username and password my DBA has provided
but after successful login when i tried to create Database it show me this error

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

I tried both asp.net as well as SSMS , i installed SQL server R2
I can connect local sql server , but when i add remote server ip address
, sql server authentication and username and password it gives error 25

Actually my DBA is saying that now a days we can not connect remote sql server by management studio , it get error 25 when i tried connecting server
i am using instance as 66.155.58.218:8443\HOMESQLSERVER
changed to : sql server authentication
username :
password :

can you tell me where i am wrong

my DBA is not responding properly , he says now a days we can not log in from management studio
as there is no such data i am sharing my user credential

yes i am getting longed in
by https://66.155.58.218:8443/

yes it is working in management studio

hello

i need to edit text in text box (bold, italic,color) and save it to html format in database .

and fetch html from database to text box (with bold, italic,color)

Than u v much
What data type i should use using access
and data type OLEObject
regards

thank u Bernhard

thank u sjelen

Thank u very much

Thank u Mathew .

icount is integer for for loop
if i scroll down viewer should display image one after another
but if i scroll down scroll down and scroll up is not working sequentially ,
for example if i have 4 images a1 a2 a3 a4 ,viewer should show first a1 and lastly a4 ,and at mouse upward first a4 and lastly a1 .but it does not , while upowrd it takes a3 a2 a1 a4.
No error message

thanks for ur reply
but i am gettting new error
Error 1 foreach statement cannot operate on variables of type 'DicomObjects.DicomDataSets' because 'DicomObjects.DicomDataSets' does not contain a public definition for 'GetEnumerator' D:\nitin\imageaccess3\imageaccess3\Form1.cs 97 13 imageaccess3

regards
nitin