Comments by oliver grace (Top 57 by date)

show your code to us.

Hi Accept Solution

change int to varchar in sql also

still you are getting input string error or some other error?

objParamater = objDataAccess.NewParameter();<br>
objParamater.ParameterName = "@id";<br>
objParamater.DbType = DbType.Varchar;//change int to varchar<br>
objParamater.Direction = ParameterDirection.Input;<br>
objParamater.Value = id;<br>
objArrayList.Add(objParamater);

also change parameter int to string

what value you are passing through DDLAieee.selectedItem.value.

ok what value you are passing

Check your DDLAieee.selectedItem.value must be in integer type.

I am working on XSLT.

have u heard about namevaluecollection try to use this to get it...

in your second form call response.redirect within that write your previous form name and checkbox.checked,
this will redirect your checkbox value to first form. call this in first form pageload.
then u will get it........

Hi what query u passed for this....
and try to call city method also in pageload

Try this,
dt1.columns.contains("null")
otherwise try to call this in
dt1=dt1.columns.remove(dt1.columns.contains("null"));
if (dt1.Rows.Count > 0)
{
GridView1.DataSource = dt1;
GridView1.DataBind();

inside update panel

I declaring like this only but chkbox.items[i].selected always shows me false.

Thank a lot genius....

Thanks a lot genius........

this url works fine when encrypt my file.when i decrypt my file getting error like bad data.

error:
System.Security.Cryptography.CryptographicException: Bad Data.

hi, I have added my code here:
http://www.codeproject.com/Questions/435183/how-to-set-large-file-set-in-asp-net

still I have same error :
ERROR: Object reference not set to an instance of an object

<httpruntime maxrequestlength="20480" executiontimeout="600">


I have tried httpruntime but i am getting this error.
ERROR: Object reference not set to an instance of an object.

using ASP.NET I have created application.when i upload any file in that that should be stored into sharepoint document library.


protected void btnUpload_Click(object sender, EventArgs e)
{
SPSite mySite = SPContext.Current.Site;
SPWeb myWeb = mySite.OpenWeb();
UploadDocument(myWeb);


}
public void UploadDocument(SPWeb site)
{
if (FileUpload1.HasFile)
{
SPFolder folder = site.GetFolder("Bill");

SPFileCollection files = folder.Files;

Stream fStream = FileUpload1.PostedFile.InputStream; //path of the file to upload

byte[] contents = new byte[fStream.Length];

fStream.Position = 0;

fStream.Read(contents, 0, (int)fStream.Length);

fStream.Close();

string Filename = FileUpload1.FileName;

string URL = SPContext.Current.Site.Url + "/Bill/" + Filename;

SPFile currentFile = files.Add(URL, contents);
}
}

thanks for your reply but i want to upload my document in sharepoint document library.is there any other way..

Is share point 2010 already has document management system or have to install DMS Seperatly.

can you provide code for this.

i too using windows authentication but i dont know how to connect report builder to aspx page.when i run my report builder it working fine.i want to run this in visual stdio.

how to avoid $ symbol

one issue date M/d/yyyy like this coming i cannot see my date

Execellent...got the answer.Thank you

is this thing possible in stored procedure..

then how to retain existing table id value

name,address i am getting fine except id ...
new id's generating for existing table data's

BUT HERE I AM NOT GETTING EXISTING TABLE Id values

EXCELLENT THANKS A LOT.....

ok and once again thank you so much

Error like this:
-----------------
Msg 271, Level 16, State 1, Line 4
The column "Id" cannot be modified because it is either a computed column or is the result of a UNION operator.
Caution: Changing any part of an object name could break scripts and stored procedures.

I tried this but its not working..
CREATE TABLE TestTable2
(

srlNo int NOT NULL
IDENTITY(1, 1),
Id varchar(100),
Name varchar(50) NULL,
Addres varchar(100)
)
ON [PRIMARY]
go

CREATE TABLE TempTable2
(
Identifier int NOT NULL
IDENTITY(1, 1),
Id as 'test'+cast(Identifier as varchar(100)),

Name varchar(50) NULL,
Addres varchar(100)
)
ON [PRIMARY]
go

SET IDENTITY_INSERT TempTable2 ON
go

IF EXISTS ( SELECT *
FROM TestTable2 )
INSERT INTO TempTable2 ( Id, Name,Addres )
SELECT Id,
Name,
Addres
FROM TestTable2 TABLOCKX
go

SET IDENTITY_INSERT TempTable2 OFF
go

DROP TABLE TestTable2
go

Exec sp_rename 'TempTable2', 'TestTable2'

but i cant get like that

yes

for integer id its working fine...when i use varchar for id getting problem.

existing table i have id varchar(100) how to set identity for id

using stored procedure can we do this concept in single table ?

same identity concept not working for id with varchar value

can we set varchar id to auto generic

my old table srlno is identity now i created ID id identity can i get both identity in a table...

Thank you Very mach... i got the answer

Where is the dbo.Names table are you already created this table

Thank you...But my requirement is when i alter a table old column data also i need....is there anyother way.

Thank you for your reply ..in this approach i can't retain the existing data..
when i alter a table i want to have my existing data also...is there anyother way.....

Amitgajjar thanks for your link its very useful for me...

public static void WriteLogInformation(string info1,string info2,string info3)
{
string filename = @"D:\sql\XMLDOCUMENTS\testlog2.xml";
//string filename = @"D:\sql\XMLDOCUMENTS\" + DateTime.Now.ToString("yyyy-MM-dd") + "Log.xml";
StringBuilder sbuilder = new StringBuilder();
using (StringWriter sw = new StringWriter(sbuilder))
{

using (XmlTextWriter w = new XmlTextWriter(sw))
{


//w.WriteStartElement("Root");
w.WriteStartElement("Username");
w.WriteElementString("Info1", info1);
w.WriteElementString("Time", "Logged at '" + DateTime.Now.ToString() + "'");
w.WriteEndElement();
w.WriteStartElement("UI");
w.WriteElementString("Info2", info2);
w.WriteEndElement();
w.WriteStartElement("Message");
w.WriteElementString("Info3", info3);
w.WriteElementString("Time", DateTime.Now.ToString());
w.WriteEndElement();

}
}
using (StreamWriter w = new StreamWriter(filename, true, Encoding.UTF8))
{
w.WriteLine(sbuilder.ToString());
}

}
Can I use this method for my application.i want to call this method into all the pages in my application.
If I set root for this method each & every page generate the root but i need common root for my application.


Thank you All